//DataSet LOAD方法
DataSet ds = new DataSet();
using (SqlConnection con = new SqlConnection("data source=(local);initial catalog=ThreeLayer;persist security info=False;user id=sa;password=11111;workstation id=AIDE-7CE47A35A7;packet size=4096"))
{
con.Open();
using (SqlCommand com = con.CreateCommand())
{
com.CommandText = "p";
com.CommandType = CommandType.StoredProcedure;
using (SqlDataReader dr = com.ExecuteReader())
{
ds.Load(dr, LoadOption.PreserveChanges, new String[] { "limit", "Message" });
}
}
}
foreach (DataTable dt in ds.Tables)
{
Console.Write("{0}", dt.TableName);
Console.WriteLine();
foreach (DataRow dr in dt.Rows)
{
Console.Write("{0} - {1}",dr[0],dr[1]);
Console.WriteLine();
}
}