更新数据表某一行的字段值

public static void UpdateFieldValue(string tableName,int rowIndex,Dictionary<string,object> dic_column_value)
{
SqlConnection conn = ConnectDB();
string sql = "select * from " + tableName;
SqlDataAdapter da = new SqlDataAdapter(sql, conn);
SqlCommandBuilder scb = new SqlCommandBuilder(da);
da.UpdateCommand = scb.GetUpdateCommand();
DataSet dataset = new DataSet();
da.Fill(dataset,tableName);

//更新字段值
foreach(KeyValuePair<string,object> kvp in dic_column_value)
{
dataset.Tables[0].Rows[rowIndex][kvp.Key] = kvp.Value;
}

da.Update(dataset,tableName);
conn.Close();
}