A:
public static DataSet ImageMessage(string mvName)
{
SqlConnection myCon = CreateConn.conn();
string MvName = "美女";
//string strSQL = "select * from FImage where Mv_Id=(select Mv_Id from FMv where Mv_Name='" + mvName + "')";
//SqlDataAdapter sda = new SqlDataAdapter(strSQL, myCon);
//DataSet ds = new DataSet();
//sda.Fill(ds, "ffc");
//return ds;
SqlDataAdapter sda = new SqlDataAdapter("ImageMessage", myCon);//ImageMessage为存储过程名
sda.SelectCommand.CommandType = CommandType.StoredProcedure;
SqlParameter spt = new SqlParameter("@mvName", SqlDbType.VarChar, 20);
spt.Direction = ParameterDirection.Input;
spt.Value = mvName;
sda.SelectCommand.Parameters.Add(spt);
DataSet ds = new DataSet();
sda.Fill(ds, "ffc");
return ds;
}
B: SqlDataAdapter可以使用存储过程,并使用参数
SqlDataAdapter objAdapter=new SqlDataAdapter("TreeView_Select",objConn);
objAdapter.SelectCommand.CommandType=CommandType.StoredProcedure;
objAdapter.SelectCommand.Parameters.Add("@ParentID",SqlDbType.Char,36);
objAdapter.SelectCommand.Parameters["@ParentID"].Value=ParentID;
objAdapter.SelectCommand.Parameters.Add("@UserID",SqlDbType.Char,36);
objAdapter.SelectCommand.Parameters["@UserID"].Value=UserID;
objAdapter.SelectCommand.Parameters.Add("@DepartID",SqlDbType.Char,36);
objAdapter.SelectCommand.Parameters["@DepartID"].Value=DepartID;
objAdapter.Fill(objDt);
本文来自CSDN博客,转载请标明出处:http://blog.csdn.net/Do_Not_Know/archive/2008/12/14/3512685.aspx