SqlDataAdapter使用預存程序

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);