直接上例子吧
代码
1 DataTable dt = dgvShowAll.DataSource as DataTable;
2 dt.Columns.Add(new DataColumn("doctype", typeof(string)));
3 dt.Columns["doctype"].Expression = "IIF(check_type=1,'采购入库',IIF(check_type=2,'盘点入库',IIF(check_type=3,'移仓入库',IIF(check_type=4,'销售退回','其它入库'))))";
求这种写法的case when版。。还是我这是唯一的解决办法?