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