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

______________________________________________________________________________________________
答5：
CREATE   PROCEDURE [dbo].[TreeView_Select]
@ParentID char(36),
@UserID char(36),
@DepartID char(36)
AS
if @ParentID<>''
 select id,text,url from treeview where parentid=@Parentid and ((departid is null and userid is null) or PATINDEX('%'+@DepartID+'%',departid)<>0 or PATINDEX('%'+@UserID+'%',userid)<>0) order by posion
else
 select id,text,url from treeview where parentid is null and ((departid is null and userid is null) or PATINDEX('%'+@DepartID+'%',departid)<>0 or PATINDEX('%'+@UserID+'%',userid)<>0) order by posion
GO