(学习笔记)使用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();

转载于:https://www.cnblogs.com/penboy/archive/2005/04/17/139438.html