在我的应用程序中,我在一个datagridview中显示数据库表。现在我想修改和更改一些记录,并将这些更改保存到数据库中。我该怎么做?
在我的应用程序中,我在一个datagridview中显示数据库表。现在我想修改和更改一些记录,并将这些更改保存到数据库中。我该怎么做?
这里是一个使用BindingSource的例子:
string query = "SELECT * FROM dbo.bimar";
da = new SqlDataAdapter(query, connectionString);
SqlCommandBuilder cBuilder = new SqlCommandBuilder(da);
dt = new DataTable();
da.Fill(dt);
BindingSource bSource = new BindingSource();
bSource.DataSource = dt;
dataGridView1.DataSource = bSource;
当您在dataGridView1中更改数据时,请更新它:
private void button1_Click(object sender, EventArgs e)
{
da.Update(dt);
}
objDataAdapter.SelectCommand = new SqlCommand();
objDataAdapter.SelectCommand.Connection = objConnection;
objDataAdapter.SelectCommand.CommandText = "select code,name,family,fatherName,age from bimar";
objDataAdapter.SelectCommand.CommandType = CommandType.Text;
objConnection.Open();
objDataAdapter.Fill(objDataSet, "bimar");
objConnection.Close();
dataGridView1.AutoGenerateColumns = true;
dataGridView1.DataSource = objDataSet;
dataGridView1.DataMember = "bimar";