DataSet LOAD方法

//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();
            }
        }

转载于:https://www.cnblogs.com/reommmm/archive/2008/04/01/1132834.html