把存储过程返回的数据集填充到DATASET

使用存储过程返回一个数据集，SqlCommand -〉SqlDataAdapter -〉DataSet
string strcon = ConfigurationManager.ConnectionStrings["connstr"].ToString();
        SqlConnection objcon = new SqlConnection(strcon);
        objcon.Open();
        SqlCommand objcmd = new SqlCommand("sp_funpage", objcon);
        objcmd.CommandType = CommandType.StoredProcedure;
        objcmd.Parameters.Add("@TableName", SqlDbType.NVarChar, 100).Value = "viewNews";
        objcmd.Parameters.Add("@StrGetFields", SqlDbType.NVarChar, 200).Value = "news_id,news_title,news_addtime,news_check,web_url,newsclass_name";
        objcmd.Parameters.Add("@IndexFields", SqlDbType.NVarChar, 50).Value = "news_id";
        objcmd.Parameters.Add("@PageSize", SqlDbType.Int).Value = PAGESIZE;
        objcmd.Parameters.Add("@CurrentPage", SqlDbType.Int).Value = page;
        objcmd.Parameters.Add("@StrOrder", SqlDbType.NVarChar,20).Value = "news_id desc";
        objcmd.Parameters.Add("@StrWhere", SqlDbType.NVarChar, 500).Value = strwhere;
        objcmd.Parameters.Add("@rowcounts", SqlDbType.Int).Direction = ParameterDirection.Output;
        objcmd.ExecuteNonQuery();
        SqlDataAdapter DA = new SqlDataAdapter(objcmd);
        DataSet DS = new DataSet();
        DA.Fill(DS);

 

 

 

 

http://hi.baidu.com/zjali/blog/item/4817d0c2aecd14180ff4773f.html