c#在dataGridView中增加一列并赋值

来源:互联网 发布:汕头峡山淘宝拍摄 编辑:程序博客网 时间:2024/05/17 08:24


                string selpeople = "select 姓名,工号,区域所属,所属部门,入住时间,退宿时间 from 员工信息表";
                pub.xsdgv(selpeople, dataGridView11);

                DataTable dt = (DataTable)dataGridView11.DataSource;
                dt.Columns.Add("住宿费用");
                for (int i = 0; i < dt.Rows.Count; i++)
                {
                    DateTime dtruzhu = Convert.ToDateTime(dt.Rows[i][5]);
                    DateTime dttuisu = Convert.ToDateTime(dt.Rows[i][6]);
                    double zhusufeiyong=0.02;
                    //计算住宿费用

                    dt.Rows[i]["住宿费用"] = zhusufeiyong;

                }
                dataGridView11.DataSource = dt;