Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 .NET Inside SQL Server (2005)
 Muliple stored procedures - single command

Author  Topic 

clownshoes2009
Starting Member

2 Posts

Posted - 2009-04-30 : 20:37:29
Hi everyone. I have a few problems with Stored procedures.

I have two of them that both need to be called on the same page by the same event (Button_Click)

The two stored procs are called "AddCustomer" and "AddEntry"

Here is my code to call one of them - I wondered if anyone can tell me if it is possible to call them both with the same command?

String strConnString = System.Configuration.ConfigurationManager.ConnectionStrings["constring"].ConnectionString;
SqlConnection con = new SqlConnection(strConnString);
SqlCommand cmd = new SqlCommand("AddCustomer", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@OrderID", HttpContext.Current.Session["OrderID"].ToString());
cmd.Parameters.AddWithValue("@FirstName", HttpContext.Current.Session["UserFName"].ToString());
cmd.Parameters.AddWithValue("@LastName", HttpContext.Current.Session["UserFName"].ToString());
cmd.Parameters.AddWithValue("@PhoneNumber", HttpContext.Current.Session["UserPhone"].ToString());
cmd.Parameters.AddWithValue("@Email", HttpContext.Current.Session["UserEmail"].ToString());
cmd.Parameters.AddWithValue("@Address", HttpContext.Current.Session["UserAd"].ToString());
cmd.Parameters.AddWithValue("@PostCode", HttpContext.Current.Session["UserPCode"].ToString());
cmd.Parameters.AddWithValue("@EntryNumber", HttpContext.Current.Session["Entries"].ToString());
try
{
con.Open();
cmd.ExecuteNonQuery();
}
catch (Exception ex)
{
throw new Exception("Execption adding account. " + ex.Message);
}
finally
{
con.Close();
}I'd really appreciate the help! Also have another thread needing a little help finishing off my stored procedures syntax! Any help would be ever so gratefully received.

Thanks.
   

- Advertisement -