-----------------------------------------------------------
New Message on BDOTNET
-----------------------------------------------------------
From: Ambujnautiyal
Message 2 in Discussion
1) Suppose u have a SP CREATE PROCEDURE DeleteAuthor
(
@au_id varchar(11)
)
AS DELETE FROM authors where [EMAIL PROTECTED] 2) From the DataAccess Layer
string conn = "data source=(local);initial catalog=pubs;user id=sa;pwd=sa;";
string sp = "DeleteAuthor";
SqlConnection sqlconn = new SqlConnection(conn);
sqlconn.Open();
SqlCommand cmd = new SqlCommand(sp,sqlconn);
cmd.CommandType = CommandType.StoredProcedure;
SqlParameter prm = new SqlParameter();
prm = cmd.Parameters.Add("@au_id",SqlDbType.VarChar,11);
prm.Direction = ParameterDirection.Input;
prm.Value = ""; // Capture required value here. ( This will be passed across
layers from UI to Business Layer and further to DataAccess.
try
{
cmd.ExecuteNonQuery(); } From the Business Logic Layer u can pass the
required parameters to the data access method. u can also make the connection
string in the web.config instead of the dataaccess layer.
Regards Ambuj
-----------------------------------------------------------
To stop getting this e-mail, or change how often it arrives, go to your E-mail
Settings.
http://groups.msn.com/bdotnet/_emailsettings.msnw
Need help? If you've forgotten your password, please go to Passport Member
Services.
http://groups.msn.com/_passportredir.msnw?ppmprop=help
For other questions or feedback, go to our Contact Us page.
http://groups.msn.com/contact
If you do not want to receive future e-mail from this MSN group, or if you
received this message by mistake, please click the "Remove" link below. On the
pre-addressed e-mail message that opens, simply click "Send". Your e-mail
address will be deleted from this group's mailing list.
mailto:[EMAIL PROTECTED]
