• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 241
  • Last Modified:

database update frm datagrid

hello all

 following is my sample code
 
OleDbConnection conn = new OleDbConnection ("Provider= Microsoft.Jet.OlEDB.4.0;
Data Source = c:\\book.mdb;");

OleDbCommand  command = new OleDbCommand ("SELECT * FROM addressbook",conn);

OleDbDataAdapter adapter = new OleDbDataAdapter(command);

DataSet ds = new DataSet();

adapter.fill(ds,"addressbook");

dgrid.SetDataBinding ( dset, “addressbook” );


now its displaying the entire table (addressbook ) my datagrid (dgrid)

if i want to update the tablenow -  how to do ?

pls help
0
karthikeya
Asked:
karthikeya
2 Solutions
 
TonylmillerCommented:
One easy way is just to edit the data in the data grid, either through code or let the user do it.  The dataset will be updated automatically and you can pass it back to the database to update the table.

Good luck!

Tony
0
 
TheAvengerCommented:
You should call adapter.Update (ds, "addressbook");

Note that there is a small problem with the DataGrid and you may have to call dgrid.EndEdit() before you update the table, otherwise some changes will be lost.
0
 
JazzleCommented:
did you ever sort this?
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now