dataTable中的数据问题 我需要用C#对datatable里的数据进行操作,就是DATATable中的第三列的值等于第一列与第二列的乘积;有哪位大虾知道怎么实现的告诉下。 我菜鸟一个 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 DATATABLE 的COMPUTE方法可以实现 先给datatable添加一列(第三列),然后遍历每一行记录,让dr[2]=dr.items[0]*dr.items[1] private void button1_Click(object sender, EventArgs e){ DataTable dt = new DataTable(); //列1 DataColumn dc1 = new DataColumn(); dc1.DataType = System.Type.GetType("System.Double"); dc1.AllowDBNull = false; dc1.Caption = "col1"; dc1.ColumnName = "col1"; dc1.DefaultValue = 0; dt.Columns.Add(dc1); //列2 DataColumn dc2 = new DataColumn(); dc2.DataType = System.Type.GetType("System.Double"); dc2.AllowDBNull = false; dc2.Caption = "col2"; dc2.ColumnName = "col2"; dc2.DefaultValue = 0; dt.Columns.Add(dc2); //计算列 DataColumn dc3 = new DataColumn(); dc3.DataType = System.Type.GetType("System.Double"); dc3.Caption = "积"; dc3.ColumnName = "两个列的乘积"; dc3.Expression = "col1*col2"; dt.Columns.Add(dc3); dataGridView1.DataSource = dt;} DataTable tbl = new DataTable("Order Details");tbl.Columns.Add("OrderID", typeof(int));tbl.Columns.Add("Quantity", typeof(int));tbl.Columns.Add("UnitPrice", typeof(Decimal));DataColumn col = new DataColumn("Total", typeof(Decimal));col.Expression = "Quantity * UnitPrice"tbl.Columns.Add(col); C#中如何利用Speech SDK 5.1开发语音识别程序 如何取字符串 winforms: datagirdview问题 安装VS2005后,sqlserver怎么都用不了 超简单问题,刚刚发错在ASP区了,试下就给 duwamish7这种n层如何配置在多台服务器上呢? Remoting的问题!~大家帮忙看看!谢谢了!~ 关于多线程的问题 WPF MVVM 如何获取树节点点击事件 这个定义能否简化 播放列表不能保存到XML 十六进制转化为二进制
{
DataTable dt = new DataTable();
//列1
DataColumn dc1 = new DataColumn();
dc1.DataType = System.Type.GetType("System.Double");
dc1.AllowDBNull = false;
dc1.Caption = "col1";
dc1.ColumnName = "col1";
dc1.DefaultValue = 0;
dt.Columns.Add(dc1);
//列2
DataColumn dc2 = new DataColumn();
dc2.DataType = System.Type.GetType("System.Double");
dc2.AllowDBNull = false;
dc2.Caption = "col2";
dc2.ColumnName = "col2";
dc2.DefaultValue = 0;
dt.Columns.Add(dc2);
//计算列
DataColumn dc3 = new DataColumn();
dc3.DataType = System.Type.GetType("System.Double");
dc3.Caption = "积";
dc3.ColumnName = "两个列的乘积";
dc3.Expression = "col1*col2";
dt.Columns.Add(dc3); dataGridView1.DataSource = dt;
}
tbl.Columns.Add("OrderID", typeof(int));
tbl.Columns.Add("Quantity", typeof(int));
tbl.Columns.Add("UnitPrice", typeof(Decimal));
DataColumn col = new DataColumn("Total", typeof(Decimal));
col.Expression = "Quantity * UnitPrice"
tbl.Columns.Add(col);