Member Avatar for touseef4pk

Plz help me out to resolve a conflict. I have made untiring efforts to resolve but coudln't. I have showed my data in gridivew now in windows forms now i want that when i make chages on the gridview using it like an excel sheet. These changes should also be reflected back in database. I have used this code.

da = new SqlDataAdapter(); 
cb = new SqlCommandBuilder(da); 
myGridView.DataSource = ds.Tables["UserDetails"]; 
ds.AcceptChanges(); da.Update(ds, "UserDetails"); 
con.Close();

what's wrong? how can i edit specific cell values.

Edited by kvprajapati because: Added [code] tags. For easy readability, always wrap programming code within posts in [code] (code blocks).
  • 3 Contributors
  • 2 Replies
  • 89 Views
  • 2 Days Discussion Span
  • Latest Post Latest Post by kvprajapati
Member Avatar for kvprajapati

Prepare connection, adapter, and builder object.

cn=new SqlConnection("put_connection_string_here");
da = new SqlDataAdapter("select * from tablename",cn); 
cb = new SqlCommandBuilder(da);

Fetch data from the database.

DataSet ds=new DataSet();
da.Fill(ds,"UserDetails");

myGridView.DataSource = ds.Tables["UserDetails"];

To update data.

da.Update(ds, "UserDetails");
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.