Datagrid in winform

[Rohit Kukreti]

Hi All,

I'm working on winforms for the first time. I want a datagrid to display the data and be able to edit and update the same. It displays the data. But, I have not been able to make the Datagrid editable. Can anybody please gimme some quick tips for this or best gimme a link for how to edit the data in a winform datagrid?

[jhammer]

That depends on how you load the data into the DataGrid.
Whic class do you use as DataSource? Is it from a database?

[Rohit Kukreti]

The data is surely from a database and I load my database using a custom collection class I have created. Also, I need to know what do I need to make my grid eidtable (find the selected row or inline editing etc. as in ASP.Net).

[aniskhan]

Inserting/Updating/Deleting Records using DataGrid

dataset ds = new dataset(); 
OleDb.OleDbConnection con = new OleDb.OleDbConnection(yourconnectionstring); 
OleDb.OleDbDataAdapter da = new OleDb.OleDbDataAdapter("select * from yourtable", con); 
da.fill(ds); 
datagrid1.datasource = ds.tables(0);

Now you can add/delete/update the records in your datagrid. To save the changes you made back to the database
do something like (like behind a save button)

OleDb.OleDbCommandBuilder cm = new OleDb.OleDbCommandBuilder(da); 
da.update(ds);

[Rohit Kukreti]

Thats what I want Anis.... How do I add, modify and delete records from the dataagrid (Winform)

[aniskhan]

u bound the datagrid with the datatable
then make modifications in the datagrid.
when u are ready to set the change to the database as until now u have modified the datatable.
press update(button) it creates the commandBuilder for the dataAdapter and then updates the database.

[Rohit Kukreti]

can u post some code as an example

[aniskhan]

sample

[Rohit Kukreti]

Thanks