how to update dataGrid in database

Question

In my C# project, i populated the values in DataGrid from DataTable. Now if i make changes in the values in the DataGrid i need to update them in the DataBase. I'm using MS access. Here is the code snippet of how i populate values in the DataGrid.

                    while (myReader.Read())
                {
                    frmBind.dr = frmBind.dtResults.NewRow();
                    frmBind.dr["ClassName"] = myReader.GetString(0);

                    frmBind.dr["MethodSignature"] = myReader.GetString(1);

                    frmBind.dr["ParameterValues"] = myReader.GetString(2);
                    frmBind.dr["ExpectedResults"] = myReader.GetString(3);


                    frmBind.dtResults.Rows.Add(frmBind.dr);

                }

                frmBind.dataGrid2.DataSource = frmBind.dtResults;

where, dtResults is DataTable, frmBind is a Class Object, dataGrid2 is the DataGrid, myReader.Read() is used to get the values from the DataBase.

RichardHowells · Accepted Answer · 2009-04-04 10:33:33Z

2

I suggest you drop the datareader.

Drag an SQLDataSource onto the page and configure it with your query. It will give you reading/updating without writing any code at all.

answered Apr 4, 2009 at 10:33

RichardHowells

9,3563 gold badges26 silver badges24 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Henk Holterman Over a year ago

No, the OP is using Access and (most likely) WinForms.

RichardHowells Over a year ago

My Apologies - Henk is correct. I saw DataGrid and thought GridView. Been doing too many WebForms recently.

Collectives™ on Stack Overflow

how to update dataGrid in database

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related