[C#]
private void CalcColumns(){
DataColumn cPrice;
DataColumn cTax;
DataColumn cTotal;
DataTable myTable = new DataTable ();
// Create the first column.
cPrice = new DataColumn();
cPrice.DataType = System.Type.GetType("System.Decimal");
cPrice.ColumnName = "price";
cPrice.DefaultValue = 50;
// Create the second, calculated, column.
cTax = new DataColumn();
cTax.DataType = System.Type.GetType("System.Decimal");
cTax.ColumnName = "tax";
cTax.Expression = "price * 0.0862";
// Create third column.
cTotal = new DataColumn();
cTotal.DataType = System.Type.GetType("System.Decimal");
cTotal.ColumnName = "total";
cTotal.Expression = "price + tax";
// Add columns to DataTable.
myTable.Columns.Add(cPrice);
myTable.Columns.Add(cTax);
myTable.Columns.Add(cTotal);
DataRow myRow;
myRow = myTable.NewRow();
myTable.Rows.Add(myRow);
DataView myView = new DataView(myTable);
dataGrid1.DataSource = myView;
}
公式
最新推荐文章于 2024-09-14 17:02:52 发布