update changes into database

Question

0.00/5 (No votes)

See more:

Hi all,

Please help me in solving following query:

I want to update table at backend in database throughmakeing changes in datagridview.

What I want is, when User makes changes in datagridview and clicks save or update button, the changes which are made in datagridview should get reflect in table in databse.

For ex:

I am having Datagridview, and Save button on WinForm and table EmpDetails at backend in databse. I am filling Datagridview with table EmpDetails. After making changes in Datagridview when user clicked Save button, whichever changes made in datagridview should get reflect at backend in table EmpDetails.

I am using visual studio2008 with c# and MS Access as database.

Posted 16-Apr-12 0:11am

Member 8233601

Updated 16-Apr-12 0:14am

P.Salini

v2

Add a Solution

Comments

Member 8233601 16-Apr-12 6:15am

right now i m using ti code:

private void Teacher_Routine_Load(object sender, EventArgs e)
{
OleDbDataAdapter adpt = new OleDbDataAdapter("select * from ClassAdmin Order by Class_name", conn);
OleDbCommandBuilder cbld = new OleDbCommandBuilder(adpt);
conn.Open();

adpt.Fill(ds);
dataGridView1.DataSource = ds.Tables[0];
//conn.Close();

}

private void button1_Click(object sender, EventArgs e)
{
adpt.Update(ds);
}

Member 8233601 16-Apr-12 6:22am

I am getting this error:

Update requires a valid UpdateCommand when passed DataRow collection with modified rows.

Bala Selvanayagam 16-Apr-12 7:42am

Do you have a unique primary key on "ClassAdmin"

Member 8233601 16-Apr-12 8:05am

no

[no name] 16-Apr-12 6:54am

The error is pretty clear.... you need to write an UPDATE statement. What is the problem?

Member 8233601 16-Apr-12 8:05am

plz tell me complete procedure..

[no name] 16-Apr-12 9:07am

The complete procedure is : write an update statement to update your data in the database.

Member 8233601 17-Apr-12 1:12am

plz provide me proper code.

[no name] 17-Apr-12 6:49am

Uhm... no. I do not provide code to anonymous accounts and you have not demonstrated any willingness to try to do it yourself. Writing this code is your job not mine. Why on earth do need someone else to write an update statement for you?

Member 8233601 17-Apr-12 1:07am

plz provide me code i m in need...

1 solution

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)

Bala Selvanayagam · Accepted Answer · 2012-04-16T02:40:00

Hope you have a unique key in the table "ClassAdmin" & this should work and let me know any error msgs

public partial class Form1 : Form
   {

       OleDbDataAdapter adpt;
       DataSet ds = new DataSet();

       public Form1()
       {
           InitializeComponent();

           try
           {

               OleDbConnection conn = new OleDbConnection("Provider=Microsoft.JET.OLEDB.4.0;Data Source=C:\\test.mdb;");
               adpt = new OleDbDataAdapter("select * from ClassAdmin Order by Class_name", conn);

               conn.Open();
               adpt.Fill(ds);
               OleDbCommandBuilder cbld = new OleDbCommandBuilder(adpt);
               dataGridView1.DataSource = ds.Tables[0]; //conn.Close();
           }
           catch (Exception ex)
           {
               MessageBox.Show(ex.Message);
           }
       }


       private void button3_Click(object sender, EventArgs e)
       {
           try
           {
               adpt.Update(ds);
           }
           catch (Exception ex)
           {
               MessageBox.Show(ex.Message);
           }
       }
   }