(学习笔记)使用sqlcommand执行存储过程!

string strconn=ConfigurationSettings.AppSettings["dsn"];//连接数据库
             SqlConnection objconn=new SqlConnection(strconn);             
             objconn.Open();                                        //打开数据库

             SqlCommand strcomm=new SqlCommand("cate_insert",objconn);
             strcomm.CommandType=CommandType.StoredProcedure;       //调用存储过程

             SqlParameter cate_name1=strcomm.Parameters.Add("@cate_name",SqlDbType.Char,200);//调用并设置存储过程参数
             cate_name1.Value=cate_name.Text;    
            
             strcomm.ExecuteNonQuery();