datagrid 绑定LIST

 List<dataItem> mx = new List<dataItem>();
            string bh = dgv.Rows[dgv.CurrentCell.RowIndex].Cells[6].Value.ToString();
            DateTime ks=DateTime .Now .Date ;
            DateTime js=ks.AddDays (1);
            DataTable dt = new cbsj().selectgk(bh, ks, js);
            for (int i = 0; i < dt.Rows.Count; i++)
            {
                if (double.Parse(dt.Rows[i]["ygl"].ToString()) > -1)

                    mx.Add(new dataItem(int.Parse(dt.Rows[i][0].ToString()), dt.Rows[i][1].ToString(), dt.Rows[i][2].ToString(), DateTime.Parse(dt.Rows[i][3].ToString()), float.Parse(dt.Rows[i][4].ToString()), float.Parse(dt.Rows[i][5].ToString()), float.Parse(dt.Rows[i][6].ToString()), float.Parse(dt.Rows[i][7].ToString()), float.Parse(dt.Rows[i][8].ToString()), float.Parse(dt.Rows[i][9].ToString()), float.Parse(dt.Rows[i][10].ToString()), float.Parse(dt.Rows[i][11].ToString()), float.Parse(dt.Rows[i][12].ToString()), float.Parse(dt.Rows[i][13].ToString()), float.Parse(dt.Rows[i][14].ToString()), float.Parse(dt.Rows[i][15].ToString()), float.Parse(dt.Rows[i][16].ToString()), float.Parse(dt.Rows[i][17].ToString()), float.Parse(dt.Rows[i][18].ToString()), float.Parse(dt.Rows[i][19].ToString()), float.Parse(dt.Rows[i][20].ToString()), float.Parse(dt.Rows[i][21].ToString()), float.Parse(dt.Rows[i][22].ToString()), float.Parse(dt.Rows[i][23].ToString()), float.Parse(dt.Rows[i][24].ToString()), float.Parse(dt.Rows[i][25].ToString()), float.Parse(dt.Rows[i][26].ToString()), float.Parse(dt.Rows[i][27].ToString()), float.Parse(dt.Rows[i][28].ToString()), float.Parse(dt.Rows[i][29].ToString()), float.Parse(dt.Rows[i][30].ToString()), float.Parse(dt.Rows[i][31].ToString()), float.Parse(dt.Rows[i][32].ToString()), float.Parse(dt.Rows[i][33].ToString()), float.Parse(dt.Rows[i][34].ToString()), float.Parse(dt.Rows[i][35].ToString()), float.Parse(dt.Rows[i][36].ToString()), float.Parse(dt.Rows[i][37].ToString()), float.Parse(dt.Rows[i][38].ToString()), float.Parse(dt.Rows[i][39].ToString()), float.Parse(dt.Rows[i][40].ToString()), float.Parse(dt.Rows[i][41].ToString()), int.Parse(dt.Rows[i][42].ToString())));
            }
            mx_dgv.DataSource = mx;
            mx_dgv.AutoGenerateColumns = false;
            mx_dgv.AllowUserToAddRows = false;
            mx_dgv.Columns["Id"].HeaderText = "抄表序号";
            mx_dgv.Columns["Id"].DisplayIndex = 0;
            mx_dgv.Columns["Cbbh"].HeaderText = "批次";
            mx_dgv.Columns["Cbbh"].DisplayIndex = 1;
            mx_dgv.Columns["Cbsj"].DisplayIndex = 2;
            mx_dgv.Columns["Zxygz"].DisplayIndex = 3;
            mx_dgv.Columns["Zxygj"].DisplayIndex = 4;
            mx_dgv.Columns["Zxygp"].DisplayIndex = 5;
            mx_dgv.Columns["Zxygf"].DisplayIndex = 6;
            mx_dgv.Columns["Zxygg"].DisplayIndex = 7;
            mx_dgv.Columns["Fxygz"].DisplayIndex = 8;
            mx_dgv.Columns["Fxygj"].DisplayIndex = 9;
            mx_dgv.Columns["Fxygp"].DisplayIndex = 10;
            mx_dgv.Columns["Fxygf"].DisplayIndex = 11;
            mx_dgv.Columns["Fxygg"].DisplayIndex = 12;
            mx_dgv.Columns["Ady"].DisplayIndex = 13;
            mx_dgv.Columns["Bdy"].DisplayIndex = 14;
            mx_dgv.Columns["Cdy"].DisplayIndex = 15;
            mx_dgv.Columns["Adl"].DisplayIndex = 16;
            mx_dgv.Columns["Bdl"].DisplayIndex = 17;
            mx_dgv.Columns["Cdl"].DisplayIndex = 18;
            mx_dgv.Columns["Glys"].DisplayIndex = 19;
            mx_dgv.Columns["Ays"].DisplayIndex = 20;
            mx_dgv.Columns["Bys"].DisplayIndex = 21;
            mx_dgv.Columns["Cys"].DisplayIndex = 22;
            mx_dgv.Columns["Ygl"].DisplayIndex = 23;
            mx_dgv.Columns["Ygla"].DisplayIndex = 24;
            mx_dgv.Columns["Yglb"].DisplayIndex = 25;
            mx_dgv.Columns["Yglc"].DisplayIndex = 26;
            mx_dgv.Columns["Wgl"].DisplayIndex = 27;
            mx_dgv.Columns["Wgla"].DisplayIndex = 28;
            mx_dgv.Columns["Wglb"].DisplayIndex = 29;
            mx_dgv.Columns["Wglc"].DisplayIndex = 30;
            mx_dgv.Columns["Zyg"].DisplayIndex = 31;
            mx_dgv.Columns["Fyg"].DisplayIndex = 32;
            mx_dgv.Columns["Zwg"].DisplayIndex = 33;
            mx_dgv.Columns["Fwg"].DisplayIndex = 34;
            mx_dgv.Columns["Xx1"].DisplayIndex = 35;
            mx_dgv.Columns["Xx2"].DisplayIndex = 36;
            mx_dgv.Columns["Xx3"].DisplayIndex = 37;
            mx_dgv.Columns["Xx4"].DisplayIndex = 38;
            mx_dgv.Columns["Zw"].DisplayIndex = 39;
            mx_dgv.Columns["Fw"].DisplayIndex = 40;
            mx_dgv.Columns["State"].DisplayIndex = 41;
            mx_dgv.Columns["Bh485"].HeaderText = "485表号";
            mx_dgv.Columns["Cbsj"].HeaderText = "抄表时间";
            mx_dgv.Columns["Zxygz"].HeaderText = "正向有功总";
            mx_dgv.Columns["Zxygj"].HeaderText = "正向有功总尖";
            mx_dgv.Columns["Zxygp"].HeaderText = "正向有功总平";
            mx_dgv.Columns["Zxygf"].HeaderText = "正向有功总峰";
            mx_dgv.Columns["Zxygg"].HeaderText = "正向有功总谷";
            mx_dgv.Columns["Fxygz"].HeaderText = "反向有功总";
            mx_dgv.Columns["Fxygj"].HeaderText = "反向有功总尖";
            mx_dgv.Columns["Fxygp"].HeaderText = "反向有功总平";
            mx_dgv.Columns["Fxygf"].HeaderText = "反向有功总峰";
            mx_dgv.Columns["Fxygg"].HeaderText = "反向有功总谷";
            mx_dgv.Columns["Ady"].HeaderText = "A电压";
            mx_dgv.Columns["Bdy"].HeaderText = "B电压";
            mx_dgv.Columns["Cdy"].HeaderText = "C电压";
            mx_dgv.Columns["Adl"].HeaderText = "A电流";
            mx_dgv.Columns["Bdl"].HeaderText = "B电流";
            mx_dgv.Columns["Cdl"].HeaderText = "C电流";
            mx_dgv.Columns["Glys"].HeaderText = "功率因数";
            mx_dgv.Columns["Ays"].HeaderText = "A功率因数";
            mx_dgv.Columns["Bys"].HeaderText = "B功率因数";
            mx_dgv.Columns["CYS"].HeaderText = "C功率因数";
            mx_dgv.Columns["Ygl"].HeaderText = "有功功率";
            mx_dgv.Columns["Ygla"].HeaderText = "A有功功率";
            mx_dgv.Columns["Yglb"].HeaderText = "B有功功率";
            mx_dgv.Columns["Yglc"].HeaderText = "C有功功率";
            mx_dgv.Columns["Wgl"].HeaderText = "无功率";
            mx_dgv.Columns["Wgla"].HeaderText = "A无功功率";
            mx_dgv.Columns["Wglb"].HeaderText = "B无功功率";
            mx_dgv.Columns["Wglc"].HeaderText = "C无功功率";
            mx_dgv.Columns["Zyg"].HeaderText = "正向有功总";
            mx_dgv.Columns["Fyg"].HeaderText = "反向有功总";
            mx_dgv.Columns["Zwg"].HeaderText = "正向无功总";
            mx_dgv.Columns["Fwg"].HeaderText = "反向无功总";
            mx_dgv.Columns["Xx1"].HeaderText = "一象限功";
            mx_dgv.Columns["Xx2"].HeaderText = "二象限功";
            mx_dgv.Columns["Xx3"].HeaderText = "三象限功";
            mx_dgv.Columns["Xx4"].HeaderText = "四象限功";
            mx_dgv.Columns["Zw"].HeaderText = "正向无功";
            mx_dgv.Columns["Fw"].HeaderText = "反向无功";
            mx_dgv.Columns["State"].HeaderText = "状态";

转载于:https://www.cnblogs.com/hehuaflower/archive/2009/02/26/1398596.html

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值