表中两个字段stockPrice(¥money) stockCount (bigint) 目的一 我想在Datagrid 上面显示出来的时候 换成 $(美元)显示 ,并把 stockPrice 与stockCount 的乘积作为一列也显示出来 按照我的要求下面代码该怎么改? string StrSqlText;
DataTable objDataTableName = new DataTable();
IDSBase objConntext = new IDSBase();
StrSqlText = "select stockNowPrice, stockCount , sum(stockNowPrice * stockCount) from stockRecode
objDataTableName =objConntext.FstrDataTable (StrSqlText );
DataGrid1.DataSource = objDataTableName;
DataGrid1.DataBind();
DataTable objDataTableName = new DataTable();
IDSBase objConntext = new IDSBase();
StrSqlText = "select stockNowPrice, stockCount , sum(stockNowPrice * stockCount) from stockRecode
objDataTableName =objConntext.FstrDataTable (StrSqlText );
DataGrid1.DataSource = objDataTableName;
DataGrid1.DataBind();
StrSqlText = "select stockNowPrice, stockCount , stockNowPrice * stockCount as subTotal from stockRecode ";
然后添加一个绑定列,用来显示subTotal字段就可以了~~