How to save datagridview current row to database

Question

0.00/5 (No votes)

See more:

Hi,

I want save the data of the datagridview with a button. But I should change line in the grid before saving to put the data in the database. What I want is save the data of the current line without changing the line.

VB

                   daAdapter = New OleDb.OleDbDataAdapter("Select * from COMPAGNIES order by NOM_COMPAGNIE " & Trie, dbcn)
                   daAdapter.Fill(dtTransac)
                   dvTransac = New DataView(dtTransac)

dgvEdit.DataSource = dvTransac

VB

Public Overrides Function FormSauve() As Boolean
                Dim cmdbuilder As New OleDb.OleDbCommandBuilder(daAdapter)
                daAdapter.Update(dtTransac)
End sub

...
Sorry I think I didn’t explain my problem correctly. Currently, if I change any data in the grid without changing lines, the data will not be saved in the DB when I call the FormSauve sub. I should change the line in the grid and call the FormSauve sub to save the data in the DB.

What I want is to be able to save the data in the DB in the FormSauve sub without having to change the line.

Thanks,

Posted 5-Jan-12 4:07am

Brutt

Updated 9-Jan-12 8:04am

v2

Add a Solution

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Oscar Arros González · Answer 1 · 2012-01-07T18:39:00

Solution 1

you need to get the dirty data of the cells, and this use to update the data.
also you can use the cellvalidating event or similar to get the formatted data of the e element like this:

private sub datagridview1_cellvalidating(byval e as......)

in this event you can get the data with this:

e.formattedvalue

at this moment you can get the data.

and then, you can retrieve the data to other dataset or something and updata to db.

i hope you this is useful to you.

regards.

Posted 7-Jan-12 18:39pm

Oscar Arros González

Updated 9-Jan-12 6:45am

v2

Comments

Brutt 9-Jan-12 11:04am

Sorry I think I didn’t explain my problem correctly. Currently, if I change any data in the grid without changing lines, the data will not be saved in the DB when I call the FormSauve sub. I should change the line in the grid and call the FormSauve sub to save the data in the DB.

What I want is to be able to save the data in the DB in the FormSauve sub without having to change the line.

Thanks,

Spopy · Answer 2 · 2012-01-16T02:10:00

Solution 2

you must tell at the component that you have binding the dataview to update the binding.
In case you haved use the Infragistics grid you can use the grid.activerow.update command.

Posted 16-Jan-12 2:10am

Spopy