使用SqlDataAdapter在存储过程中获取记录集填充DataSet

 string sql = "UP_GetIndexPageAllDataList";      //存储过程名称   
 SqlCommand selectCMD = new SqlCommand();
 selectCMD.CommandTimeout = 300000;
 selectCMD.CommandText = sql;
 selectCMD.Connection = CS;
 selectCMD.CommandType = CommandType.StoredProcedure;

 SqlDataAdapter myDa = new SqlDataAdapter();
 myDa .SelectCommand = selectCMD;      //主要是这句   
 DataSet myDataSet = new DataSet();
 myDa .Fill(myDataSet, "Results");