Question

如何查询DataTable中某列的值

Answer 1

DataTable dt = new DataTable();
dt.Columns.Add("Price");
dt.Columns.Add("Value");
dt.Columns.Add("Temp");
dt.Columns["Temp"].DataType = typeof(decimal);
dt.Columns["Value"].DataType = typeof(decimal);
dt.Columns["Price"].DataType = typeof(decimal);
dt.Columns["Temp"].Expression = "iif(Price>0,Value,-Value)";
DataRow dr = dt.NewRow();
dr["Price"] = 12;
dr["Value"] = 22;
dt.Rows.Add(dr);
DataRow dr1 = dt.NewRow();
dr1["Price"] = -12;
dr1["Value"] = 22;
dt.Rows.Add(dr1);