Question

datagrid如何实现两列相加

Answer 1

//实现这种的，很多方法，我的这种方法是在绑定数据源之前进行相加

private void GetData()
{
DataTable dt = new DataTable();
using (SqlConnection conn = new SqlConnection("Server=.;database=test;uid=sa;pwd=123"))
{
SqlDataAdapter sda = new SqlDataAdapter("Select * from 两列相加", conn);
sda.Fill(dt);
}
dt.Columns.Add("sum");
foreach (DataRow dr in dt.Rows)
{
dr["sum"] = Convert.ToInt32(dr["leftNum"]) + Convert.ToInt32(dr["rightNum"]);
}
dataGridView1.DataSource = dt;

}