如何在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);2223                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        try33        {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        finally42        {43          sqlCommStoreProcedue.Dispose();44          sqlCom.Dispose();45          sqlCon.Close();46        }

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

相关资源：C#创建存储过程代码.doc