using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data;
方法1
DataTable dt = new DataTable("fruit");
dt.Columns.Add("ID", Type.GetType("System.Int32"));
dt.Columns[0].AutoIncrement = true;
dt.Columns[0].AutoIncrementSeed = 1;
dt.Columns[0].AutoIncrementStep = 1;
dt.Columns.Add("水果", Type.GetType("System.String"));
dt.Columns.Add("重量", Type.GetType("System.Double"));
dt.Columns.Add("单价", Type.GetType("System.Decimal"));
dt.Rows.Add(new object[] { null, "香蕉", 5, 2.5 });
dt.Rows.Add(new object[] { null, "苹果", 3, 3.5 });
dt.Rows.Add(new object[] { null, "李子", 1, 2.8 });
dt.Rows.Add(new object[] { null, "橙子", 2, 5.0 });
dt.Rows.Add(new object[] { null, "西瓜", 10, 1.2 });
Console.WriteLine("ID" + "\t水果" + "\t重量" + "\t单价");
for (int i = 0; i < dt.Rows.Count; i++)
{
DataRow r = dt.Rows[i];
Console.WriteLine(r["ID"] + "\t" + r["水果"] + "\t" + r["重量"].ToString() + "\t" + r["单价"].ToString());
}
Console.ReadKey();
方法2
DataTable dt = new DataTable("fruit");
DataColumn dc = null;
dc = dt.Columns.Add("ID", Type.GetType("System.Int32"));
dc.AutoIncrement = true;
dc.AutoIncrementSeed = 1;
dc.AutoIncrementStep = 1;
dc = dt.Columns.Add("水果", Type.GetType("System.String"));
dc.AllowDBNull = false;
dc = dt.Columns.Add("重量", Type.GetType("System.Double"));
dc = dt.Columns.Add("单价", Type.GetType("System.Decimal"));
DataRow newRow;
newRow = dt.NewRow();
newRow["水果"] = "香蕉";
newRow["重量"] = 2;
newRow["单价"] = 1.5;
dt.Rows.Add(newRow);
newRow = dt.NewRow();
newRow["水果"] = "苹果";
newRow["重量"] = 3.5;
newRow["单价"] = 2.0;
dt.Rows.Add(newRow);
Console.WriteLine("ID" + "\t水果" + "\t重量" + "\t单价");
for (int i = 0; i < dt.Rows.Count; i++)
{
DataRow r = dt.Rows[i];
Console.WriteLine(r["ID"] + "\t" + r["水果"] + "\t" + r["重量"].ToString() + "\t" + r["单价"].ToString());
}
Console.ReadKey();
方法3
DataTable table = new DataTable();
DataColumn priceColumn = new DataColumn();
priceColumn.DataType = System.Type.GetType("System.Decimal");
priceColumn.ColumnName = "price";
priceColumn.DefaultValue = 50;
DataColumn taxColumn = new DataColumn();
taxColumn.DataType = System.Type.GetType("System.Decimal");
taxColumn.ColumnName = "tax";
taxColumn.Expression = "price * 0.045";
DataColumn totalColumn = new DataColumn();
totalColumn.DataType = System.Type.GetType("System.Decimal");
totalColumn.ColumnName = "total";
totalColumn.Expression = "price + tax";
table.Columns.Add(priceColumn);
table.Columns.Add(taxColumn);
table.Columns.Add(totalColumn);
DataRow row1 = table.NewRow();
table.Rows.Add(row1);
DataRow row2 = table.NewRow();
row2["price"] = 30;
table.Rows.Add(row2);
Console.WriteLine("price" + "\ttax" + "\ttotal");
for (int i = 0; i < table.Rows.Count; i++)
{
DataRow r = table.Rows[i];
Console.WriteLine(r["price"] + "\t" + r["tax"].ToString() + "\t" + r["total"].ToString());
}
Console.ReadKey();