SQL 存储过程

string sql = 数据库连接字符串;SqlConnection mysql = new SqlConnection(sql); SqlCommand cmd = new SqlCommand("sp_InsertStudent ",mysql); SqlParameter[] paras = {new SqlParameter("@studentId "),studentid,.....}//给参数赋值cmd.Parameters.AddRange(paras);cmd.CommandType = CommandType.StoredProcedure; mysql.Open();int effectCount = cmd.ExecuteNonQuery();mysql.Close();

string str = "server='(local)';database='mydatabase';uid='sa';pwd='Sa'"; SqlConnection con = new SqlConnection(str); con.Open(); //打开连接 SqlCommand cmd = new SqlCommand("sp_InsertStudent", con); //使用存储过程 cmd.CommandType = CommandType.StoredProcedure; //设置Command对象的类型为执行一个存储过程SqlParameter spr; // 创建参数对象spr = cmd.Parameters.Add("@studentId",  SqlDbType.NChar,11); //增加参数sid spr = cmd.Parameters.Add("@studentName", SqlDbType.NChar,11); //增加参数snamespr = cmd.Parameters.Add("@classId",  SqlDbType.NChar,11); //增加参数cid cmd.Parameters["@studentId"].Value = studentid; //给参数赋值 cmd.Parameters["@studentName"].Value = studentname; //给参数赋值cmd.Parameters["@classId"].Value = classid; //给参数赋值 
这个很简单， 按照这个语句写ado就行了 调用这个函数时建一个SqlDataAdapter SqlCommand comm = new SqlCommand("select * from table where ...");SqlDataAdapter ad = new SqlDataAdapter(comm);public int MyExecuteSql(SqlDataAdapter sqlAd, ref DataTable returnTable)        {            try            {                this.openConn();                sqlAd.SelectCommand.Connection = this.conn;                                DataSet ds = new DataSet();                sqlAd.Fill(ds);                returnTable = ds.Tables[0];                if (ds.Tables[0].Rows.Count > 0)                {                    return 1;                }                else                {                    return 0;                }            }            catch (Exception ex)            {                throw ex;            }            finally            {                this.closeConn();            }            //return 0;        }