namespace UpdateDataWindowsFormDataGridView { public partial class Form1 : Form { private SqlDataAdapter da; private DataTable dt;
public Form1()
{
InitializeComponent();
// Configure display characteristics of the data grid view
dataGridView.Anchor = AnchorStyles.Left | AnchorStyles.Right |
AnchorStyles.Top | AnchorStyles.Bottom;
this.Width = 500;
this.Load += new EventHandler(Form1_Load);
}
void Form1_Load(object sender, EventArgs e)
{
// Set the data source of the data grid view
dataGridView.DataSource = LoadData();
}
private DataTable LoadData()
{
string sqlConnectString = @"my connetion";
string sqlSelect = "SELECT Id, IntField, StringField FROM DataGridView";
// Create a data adapter and command builder
da = new SqlDataAdapter(sqlSelect, sqlConnectString);
SqlCommandBuilder cb = new SqlCommandBuilder(da);
// Load a DataTable with schema and data from table DataGridView
dt = new DataTable();
da.FillSchema(dt, SchemaType.Source);
da.Fill(dt);
return dt;
}
private void saveButton_Click(object sender, EventArgs e)
{
da.Update(dt);
MessageBox.Show("Changes saved.", "DataGridView",
MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
}
This is not my code but I just did exactly like this but on a extra note I have added a button which selects the value in the gridview…nw I want a button for just updating the gridview… wen I use this code the database remains unchanged(nothing happens)…. For the second button I have added the SQL dataadaptor and datatable publically hw t is in the prog but with a different object instance(name)..
This code is workin if I create a dummy form with just one gridview and a button, but not wen 2 buttons (one for select and 1 for update ).. is there any other way to do this..