把存储过程返回的数据集填充到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