How do I update a modified row of my datagridview to the db?

Question

0.00/5 (No votes)

See more:

How do I update a modified row of my datagridview to the db?
i had tried a lot...
but nothing happened....

i asked this question 2 days before....
can any one help me....

tried following code: but...

private void showButton_Click(object sender, EventArgs e)
{
con =  new OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=D:\\ETMS\\ETMS\\ETMS\\etms.accdb");
String query = "SELECT * FROM Categories";
da = new OleDbDataAdapter(query, con);
OleDbCommandBuilder cb = new OleDbCommandBuilder(da);
ds = new DataSet();
da.Fill(ds);
dataGridView1.DataSource = ds.Tables[0];
con.Close();
}
private void UpdateButton_Click(object sender, EventArgs e)
{
da.Update(ds);
}

if i run the code
i am getting the following error
"update requires a valid update command when pressed datarow collection with modified rows"
Please help me...
thank you

Posted 13-Jun-11 1:03am

Ragi Gopi

Updated 13-Jun-11 6:03am

thatraja

v4

Add a Solution

5 solutions

Solution 3

This may help you.,

private void showButton_Click(object sender, EventArgs e)
{
    con = new OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=D:\\ETMS\\ETMS\\ETMS\\etms.accdb");
    String query = "SELECT * FROM Categories";
    da = new OleDbDataAdapter(query, con); 
    OleDbCommandBuilder cb = new OleDbCommandBuilder(da);
    ds = new DataSet();
    da.Fill(ds);
    dataGridView1.DataSource = ds.Tables[0];
    con.Close();
}
private void UpdateButton_Click(object sender, EventArgs e)
{
    DataSet ds1 = ((DataSet)dataGridView1.DataSource).GetChanges();
    da.Update(ds1);
}

Posted 13-Jun-11 2:13am

parmar_punit

Comments

codesharper 13-Jun-11 8:15am

This is better idia to affect only changes into database but you must create insert and update command to affect the record in database.

Solution 1

This link might be of some help.

Posted 13-Jun-11 1:20am

RakeshMeena

Comments

Ragi Gopi 13-Jun-11 7:35am

following error is displayed....
"update requires a valid update command when pressed datarow collection with modified rows"

Ragi Gopi 13-Jun-11 7:36am

@RakeshMeena
i tried ur linq but again the same error is generated...

Solution 2

Hope this[^] will help you..

Posted 13-Jun-11 1:54am

version_2.0

Solution 5

please check you table and put a primary key if you don't have.
and if the error is still persist try to use the solution of Uday P.Singh :)
Happy Coding!!!!

Posted 13-Jun-11 20:21pm

Joemar Valete

Comments

Ragi Gopi 14-Jun-11 2:46am

@Joemar Valete
i tried solution of Uday P.Singh..
its works :)

Joemar Valete 14-Jun-11 2:51am

Good for you :)

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)

Uday P.Singh · Accepted Answer · 2011-06-13T07:14:00

you can do this way:

C#

private void showButton_Click(object sender, EventArgs e)
{
con =  new OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=D:\\ETMS\\ETMS\\ETMS\\etms.accdb");
String query = "SELECT * FROM Categories";
da = new OleDbDataAdapter(query, con);
OleDbCommandBuilder cb = new OleDbCommandBuilder(da);
dt=new DataTable();
da.Fill(dt);
dataGridView1.DataSource = dt;
con.Close();
}
private void UpdateButton_Click(object sender, EventArgs e)
{
da.Update(dt);
}

for further info refer to following links:

Edit Almost Anything in a DataGrid[^]

Auto Saving DataGridView Rows to a SQL Server Database[^]

hope this helps :)

[Edit] by Tadit
Corrected the second link's html.
As it was showing the whole html where new window icon is shown.
[/Edit]

How do I update a modified row of my datagridview to the db?

5 solutions

Solution 3

Solution 4

Solution 1

Solution 2

Solution 5

Add your solution here

Preview 0

Existing Members

...or Join us