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..