学步园

using System;<br /> using System.Collections.Generic;<br /> using System.Linq;<br /> using System.Text;<br /> using System.Data;<br /> using System.Data.SqlClient;<br /> using System.Threading;</p> <p>namespace CAlianxe1<br /> {<br /> class Program<br /> {<br /> static void Main(string[] args)<br /> {<br /> #region 创建内存中的Table<br /> //Columns对象有两个方法用来添加对应的列<br /> //1：Add,用来添加单个的column实例<br /> //2：AddRange,用来添加一个对象数组<br /> Console.WriteLine(typeof(int));<br /> DataTable dt = new DataTable("shuji");<br /> dt.Columns.Add(new DataColumn("书名", typeof(string)));<br /> dt.Columns.Add(new DataColumn("书号", typeof(int)));<br /> DataColumn[] dc = new DataColumn[2];<br /> dc[0] = new DataColumn("价格", typeof(decimal));<br /> dc[1] = new DataColumn("出版社", typeof(string));<br /> dt.Columns.AddRange(dc);<br /> DataRow dr = dt.NewRow();<br /> dr["书名"] = "c# 编程指南";<br /> dr["书号"] = 111111;<br /> dr["价格"] = 98.392398393;<br /> dr["出版社"] = "清华大学出版社";<br /> dt.Rows.Add(dr);<br /> dt.Rows.Add(new object[] { "C++编程指南", 222222, 29.392398393, "人民教育出版社" });<br /> DisplayResult(dt);<br /> DataSet ds = new DataSet();<br /> ds.Tables.Add(dt);<br /> ds.Tables.Remove(dt);//移除某一个热顶的表<br /> ds.Tables.RemoveAt(0);//移除指定位置的表<br /> #endregion</p> <p> Thread.Sleep(50000);<br /> }<br /> static void DisplayResult(DataTable dt)<br /> {<br /> for (int i = 0; i < dt.Columns.Count; i++)<br /> {<br /> Console.Write(dt.Columns[i].ColumnName.PadRight(16));<br /> }<br /> Console.WriteLine();<br /> for (int i = 0; i < dt.Rows.Count; i++)<br /> {<br /> foreach (DataColumn d in dt.Columns)<br /> {<br /> Console.Write("{0}", dt.Rows[i][d].ToString().PadRight(16));<br /> }<br /> Console.WriteLine();<br /> for (int j = 0; j < dt.Columns.Count; j++)<br /> {<br /> Console.Write("{0}", dt.Rows[i][j].ToString().PadRight(16));<br /> }<br /> Console.WriteLine();<br /> }<br /> }<br /> }<br /> }<br />