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); //增加参数sname
spr = 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;
        }