C#涓璂ataTable鎬庝箞浣跨敤
鍦–#涓紝DataTable鏄竴涓被锛岀敤浜庡湪鍐呭瓨涓瓨鍌ㄥ拰鎿嶄綔鏁版嵁銆傝浣跨敤DataTable锛岄渶瑕佸厛鍒涘缓涓€涓狣ataTable瀵硅薄锛岀劧鍚庡彲浠ユ坊鍔犲垪銆佹坊鍔犺銆佷慨鏀规暟鎹瓑鎿嶄綔銆?/p>
浠ヤ笅鏄竴浜涘父鐢ㄧ殑DataTable鎿嶄綔锛?/p>
- 鍒涘缓DataTable瀵硅薄锛?/li>
DataTable dt = new DataTable("MyTable");
- 娣诲姞鍒楋細
dt.Columns.Add("Column1", typeof(int));
dt.Columns.Add("Column2", typeof(string));
- 娣诲姞琛岋細
DataRow row = dt.NewRow();
row["Column1"] = 1;
row["Column2"] = "Value";
dt.Rows.Add(row);
- 淇敼鏁版嵁锛?/li>
dt.Rows[0]["Column1"] = 2;
- 閬嶅巻鏁版嵁锛?/li>
foreach (DataRow row in dt.Rows)
{
foreach (DataColumn col in dt.Columns)
{
Console.WriteLine(row[col]);
}
}
- 鏌ヨ鏁版嵁锛?/li>
DataRow[] result = dt.Select("Column1 = 2");
foreach (DataRow row in result)
{
Console.WriteLine(row["Column2"]);
}
- 鍒犻櫎琛岋細
dt.Rows[0].Delete();
dt.AcceptChanges(); // 鎻愪氦鏇存敼
- 娓呯┖鏁版嵁琛細
dt.Clear();
璇锋敞鎰忥紝浠ヤ笂鍙槸涓€浜涘熀鏈殑鎿嶄綔锛孌ataTable杩樻湁鏇村鐨勫姛鑳斤紝濡傛帓搴忋€佽繃婊ゃ€佸叧鑱旂瓑锛屽彲浠ユ牴鎹叿浣撶殑闇€姹傝繘琛岃繘涓€姝ュ涔犲拰浣跨敤銆?/p>