学步园

using System;<br /> using System.Collections.Generic;<br /> using System.Linq;<br /> using System.Text;</p> <p>using System.Data;</p> <p>namespace testDataTable<br /> {<br /> class Program<br /> {<br /> static void Main(string[] args)<br /> {<br /> DataTable dt = new DataTable();<br /> dt.Columns.Add("id", typeof(int));<br /> dt.Columns.Add("Role", typeof(string));</p> <p> dt.PrimaryKey = new DataColumn[] { dt.Columns["id"] };//添加主键</p> <p> dt.Rows.Add(new object[] { 1, "超级管理员" });<br /> dt.Rows.Add(new object[] { 2, "管理员" });<br /> dt.Rows.Add(new object[] { 3, "普通用户" });</p> <p> DataRow[] currentRows = dt.Select(null, null, DataViewRowState.CurrentRows);</p> <p> if (currentRows.Length < 1)<br /> Console.WriteLine("No Current Rows Found");<br /> else<br /> {<br /> foreach (DataColumn column in dt.Columns)<br /> Console.Write("/t{0}", column.ColumnName);</p> <p> //Console.WriteLine("/tRowState");</p> <p> foreach (DataRow row in currentRows)<br /> {<br /> Console.WriteLine("/t");<br /> foreach (DataColumn column in dt.Columns)<br /> Console.Write("/t{0}", row[column]);</p> <p> Console.WriteLine("/t");<br /> //Console.WriteLine("/t" + row.RowState);</p> <p> }<br /> }<br /> Console.ReadLine();<br /> }</p> <p> }<br /> }<br />

显示结果

using System;<br /> using System.Collections.Generic;<br /> using System.Linq;<br /> using System.Text;</p> <p>using System.Data;</p> <p>namespace baobiao<br /> {<br /> class Program<br /> {<br /> static void Main(string[] args)<br /> {<br /> DataTable dt = new DataTable();<br /> dt.Columns.Add("id", typeof(int));<br /> dt.Columns.Add("Role", typeof(string));<br /> dt.Columns.Add("Remark", typeof(string));</p> <p> dt.PrimaryKey = new DataColumn[] { dt.Columns["id"] };//添加主键 </p> <p> dt.Rows.Add(new object[] { 1, "超级管理员", "无" });<br /> dt.Rows.Add(new object[] { 2, "管理员", "asa" });<br /> dt.Rows.Add(new object[] { 3, "普通用户", "1212" });<br /> dt.Rows.Add(new object[] { 4, "权限", "211s" });</p> <p> DataRow[] currentRows = dt.Select(null, null, DataViewRowState.CurrentRows);</p> <p> if (currentRows.Length < 1)<br /> Console.WriteLine("No Current Rows Found");<br /> else<br /> {<br /> int column1 = 0;</p> <p> foreach (DataColumn column in dt.Columns)<br /> {<br /> Console.WriteLine("/t");<br /> Console.Write("/t{0}", column.ColumnName);<br /> foreach (DataRow row in dt.Rows)<br /> {<br /> //一个萝卜放一个坑<br /> Console.Write("/t{0}", row[column1]);</p> <p> }<br /> column1++;<br /> Console.WriteLine("/t");<br /> }</p> <p> }</p> <p> //下面foreach 用法<br /> //int[] fibarray = new int[] { 0, 1, 2, 3, 5, 8, 13 };<br /> //foreach (int i in fibarray)<br /> //{<br /> // System.Console.WriteLine(i);<br /> //}</p> <p> //</p> <p> //int[,] numbers2D = new int[3, 2] { { 9, 99 }, { 3, 33 }, { 5, 55 } };<br /> //foreach (int i in numbers2D)<br /> //{<br /> // System.Console.Write("{0} ", i);<br /> //}</p> <p> Console.ReadLine(); </p> <p> }<br /> }<br /> }<br />

输出结果：