创建DataTable的表达式Column

显示:

创建DataTable的表达式Column

        private void DataTableTest1_Load(object sender, EventArgs e)
{
string sql = "select *,单价*数量*(1-折扣) as 总价 from dbo.订单明细";
DataColumn c = new DataColumn("单价提示", typeof(System.Boolean), "iif(单价>10,true,false)");
DataTable tbl = Rabbit.DBUtility.DBHelperSql.Query(sql).Tables[0];
tbl.Columns.Add(c);
dataGridView1.DataSource = tbl;
}



转载于:https://www.cnblogs.com/2008freestyle/archive/2012/03/25/2416827.html