C# DataTable(資料物件) 純手工建立 [C# datatable new row]
C# DataTable(資料物件) 純手工建立 [C# datatable new row]
資料來源: https://goodlucky.pixnet.net/blog/post/47820264-%5Bc%23%5D-datatable-%E6%96%B0%E5%A2%9E%E8%B3%87%E6%96%99%E5%88%97
https://goodlucky.pixnet.net/blog/post/47820276-%5Bc#%5D%20%E8%87%AA%E8%A1%8C%E5%AE%9A%E7%BE%A9DataTable%E7%9A%84%E6%AC%84%E4%BD%8D%E5%8F%8A%E5%9E%8B%E6%85%8B
https://vimsky.com/zh-tw/examples/detail/csharp-method-system.data.datatable.newrow.html
範例01.
DataTable dtTable = new DataTable(); DataRow row; // 建立欄位 dtTable.Columns.Add("JOB_ID", typeof(int)); dtTable.Columns.Add("JOB_TITLE", typeof(string)); // 新增資料到DataTable for (int i = 0; i < 10; i++) { row = dtTable.NewRow(); row["JOB_ID"] = i; row["JOB_TITLE"] = "title " + i.ToString(); dtTable.Rows.Add(row); } GridView1.DataSource = dtTable; GridView1.DataBind();
範例02.
private void MakeDataTableAndDisplay() { // Create new DataTable and DataSource objects. DataTable table = new DataTable(); // Declare DataColumn and DataRow variables. DataColumn column; DataRow row; DataView view; // Create new DataColumn, set DataType, ColumnName and add to DataTable. column = new DataColumn(); column.DataType = System.Type.GetType("System.Int32"); column.ColumnName = "id"; table.Columns.Add(column); // Create second column. column = new DataColumn(); column.DataType = Type.GetType("System.String"); column.ColumnName = "item"; table.Columns.Add(column); // Create new DataRow objects and add to DataTable. for(int i = 0; i < 10; i++) { row = table.NewRow(); row["id"] = i; row["item"] = "item " + i.ToString(); table.Rows.Add(row); } // Create a DataView using the DataTable. view = new DataView(table); // Set a DataGrid control's DataSource to the DataView. dataGrid1.DataSource = view; }
範例03.(欄位型態指定)
DataTable table = new DataTable(); table.Columns.Add("Weight", typeof(int)); table.Columns.Add("Name", typeof(string)); table.Columns.Add("Breed", typeof(string)); table.Columns.Add("Date", typeof(DateTime));