如何在c#中创建存储过程

Code
 1创建存储过程：        
 2string strSql = "";
 3        SqlConnection sqlCon = new SqlConnection(Master.HeadStartConnString);
 4        SqlCommand sqlCommStoreProcedue = new SqlCommand();
 5        sqlCommStoreProcedue.Connection = sqlCon;
 6        sqlCommStoreProcedue.CommandType = CommandType.Text;
 7          strSql = "Create PROCEDURE #ImgeUpdate \n @RptImage Image, \n @RptDescription varchar(1000) \n as update Reports set RptImage = @RptImage, RptDescription = @RptDescription where RptID = " + rptID;
 8          sqlCommStoreProcedue.CommandText = strSql;
 9          sqlCon.Open();
10          sqlCommStoreProcedue.ExecuteNonQuery();
11执行存储过程：
12        SqlCommand sqlCom = new SqlCommand();
13        sqlCom.Connection = sqlCon;
14        sqlCom.CommandType = CommandType.StoredProcedure;
15        sqlCom.CommandText = "#ImgeUpdate";
16            if (filUL.HasFile)
17            {
18                int intImgSize = filUL.PostedFile.ContentLength;
19                Stream ImgStream = filUL.PostedFile.InputStream;
20                byte[] ImgContent = new byte[intImgSize];
21                int intStatus = ImgStream.Read(ImgContent, 0, intImgSize);
22
23                SqlParameter prmImg = new SqlParameter("@RptImage", SqlDbType.Image);
24                prmImg.Value = ImgContent;
25                sqlCom.Parameters.Add(prmImg);
26                sqlCom.Parameters["@RptImage"].Direction = ParameterDirection.Input;
27            }
28        SqlParameter prmDes = new SqlParameter("@RptDescription", SqlDbType.VarChar, 1000);
29        prmDes.Value = txtDesp.Text.ToString().Trim();
30        sqlCom.Parameters.Add(prmDes);
31        sqlCom.Parameters["@RptDescription"].Direction = ParameterDirection.Input;
32        try
33        {
34            sqlCom.ExecuteNonQuery();
35            ClientScript.RegisterStartupScript(this.GetType(), "closeWin_Save", "<script>alert('Save This Record Succeed!');window.close();</script>");
36        }
37        catch (SqlException sqlE)
38        {
39            ClientScript.RegisterStartupScript(this.GetType(), "Error_Msg", "<script>alert('Save This Record Failing:" + sqlE.Message + "');</script>");
40        }
41        finally
42        {
43          sqlCommStoreProcedue.Dispose();
44          sqlCom.Dispose();
45          sqlCon.Close();
46        }

转载于:https://www.cnblogs.com/lfzwenzhu/archive/2009/07/08/1519178.html