c# datagridview datatable根据条件给 某行 某字段 赋值(数据库不变)
要求:所有符合name值为m1 , 则age赋值0,detail赋值空
实现效果
实现代码
/// <summary>
/// 查询
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void button4_Click(object sender, EventArgs e)
{
dataGridView1.AutoGenerateColumns = false;
var data = new SourceTable();
DataTable data1 = new SourceTable();
data = DBUtilits.DB.From<Table_1>().ToTable();
//当Table_1表中name值为m1 ,则age赋值0,detail赋值空
foreach (DataRow dr in data.Rows)
{
if ("m1".Equals(dr["name"].ToString()))
{
dr["age"] = 0;
dr["detail"] = "";
}
}
this.dataGridView1.DataSource = data;
MessageBox.Show("查询成功!");
}