using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
namespace DataRowColumn_ex
{
public partial class Form1 : Form
{
public Form1()
{
InitializeComponent();
}
private void btn_CreateDataTable_Click(object sender, EventArgs e)
{
dataGridView1.DataSource = MakeTable();
dataGridView1.AutoResizeColumns();
}
public DataTable MakeTable()
{
DataTable table = new DataTable("Product");
//建立三個DataColumn並設定相關欄位屬性
DataColumn column1 = new DataColumn("ProductID");
column1.DataType = System.Type.GetType("System.String");
column1.AllowDBNull = false;
column1.Caption = "產品編號";
column1.DefaultValue = "Car001";
DataColumn column2 = new DataColumn("ProductName");
column2.DataType = System.Type.GetType("System.String");
column2.AllowDBNull = true;
column2.Caption = "產品名稱";
column2.DefaultValue = "日蝕GST";
DataColumn column3 = new DataColumn("Price");
column3.DataType = System.Type.GetType("System.Decimal");
column3.AllowDBNull = true;
column3.Caption = "價格";
column3.DefaultValue = 0;
//將欄位加入表格中
table.Columns.Add(column1);
table.Columns.Add(column2);
table.Columns.Add(column3);
//建立二個DataRow並給定其對應欄位內容值
DataRow row;
row = table.NewRow();
row["ProductID"] = "Car001";
row["ProductName"] = "Mitsubishi Eclipse GST";
row["Price"] = 1200000;
table.Rows.Add(row);
row = table.NewRow();
row["ProductID"] = "Car002";
row["ProductName"] = "Tigra";
row["Price"] = 800000;
table.Rows.Add(row);
return table;
}
}
}
DataRow表示DataTable中的資料列。可以用來新增DataTable中資料列的資料
DataColumn用來定義欄位的名稱、型別和預設值
