update database using datagridview in c# windows form

Question

5.00/5 (2 votes)

See more:

i am using below code for updating database value, but it is not working

please help

I am new to c#

private void button1_Click(object sender, EventArgs e)
{
  if (objConn1.State != ConnectionState.Open)
  {
    objConn1.Open();
  }

  for (int i = 0; i < dataGridView1.SelectedRows.Count; i++)
  {
    DialogResult result;
    result = MessageBox.Show("Are You sure want to update?", "Conformation", MessageBoxButtons.YesNo);
    if (result == System.Windows.Forms.DialogResult.Yes)
    {
      //string sql = "update   [SAPProduction].[ProductionData] set Rejection  " + " Where id = '" + dataGridView2.CurrentRow.Cells["id"].Value.ToString() + "'  ";
      // Jobcard = your desire Rows Jobcard Id
      SqlCommand command = new SqlCommand("UPDATE ProductionData_BK SET Rejection = @Reject Where id = '" + dataGridView1.CurrentRow.Cells["id"].Value.ToString() + "'  ", objConn1);

      command.Parameters.AddWithValue("@Reject",dataGridView1.SelectedCells[13].ToString());

      //objConn1.Open();
      command.ExecuteNonQuery();
      objConn1.Close();
    }
  }
}

[edit]spelling and indexation[/edit]

Posted 24-Jun-13 23:31pm

Master Vinu

Updated 24-Jun-13 23:52pm

v5

Add a Solution

5 solutions

Solution 3

hi visit this link
http://social.msdn.microsoft.com/Forums/windows/en-US/48f171c1-c4ff-47b4-954d-0a93fdc4085c/updating-database-from-datagridview-in-c[^]

Posted 25-Jun-13 0:06am

samadhan_kshirsagar

Comments

Syed Faheem Abbas 10-Jun-15 9:04am

hate msdn

CHill60 10-Jun-15 9:20am

You might hate it, but nothing beats RTFM

Solution 4

//replace this c# code to the right place...
// you can use the debugger to see were exactly the problem is...

string query = "UPDATE ProductionData_BK " +
"SET Rejection=@Reject; " +
"Where id = 'dataGridView1.CurrentRow.Cells['id'].Value.ToString()', objConn1"

SqlCommand insertCommand = new SqlCommand(query, objConn1);

Posted 25-Jun-13 0:18am

Mulla Rameez

Updated 25-Jun-13 0:23am

v2

Solution 5

private void button1_Click(object sender, EventArgs e)
{
if (objConn1.State != ConnectionState.Open)
{
objConn1.Open();
}

for (int i = 0; i < dataGridView1.SelectedRows.Count; i++)
{
DialogResult result;
result = MessageBox.Show("Are You sure want to Delete?", "Conformation", MessageBoxButtons.YesNo);
if (result == System.Windows.Forms.DialogResult.Yes)
{
//string sql = "update [SAPProduction].[ProductionData] set Rejection " + " Where id = '" + dataGridView2.CurrentRow.Cells["id"].Value.ToString() + "' ";
// Jobcard = your desire Rows Jobcard Id
SqlCommand command = new SqlCommand("UPDATE SAPProduction.ProductionData_BK SET Rejection = @Reject Where id = '" + dataGridView1.CurrentRow.Cells["id"].Value.ToString() + "' ", objConn1);

command.Parameters.AddWithValue("@Reject", dataGridView1.CurrentRow.Cells["Rejection"].Value.ToString());
command.ExecuteNonQuery();
MessageBox.Show("Row Updated...");

objConn1.Close();

}
}
}

Posted 25-Jun-13 0:30am

Master Vinu

Solution 1

First issue I see is that it will set All entries to be set to rejection is that query is run.

You are missing the "Where" clause of the SQL statement.

However, other than that are you getting any errors.. then phrase "not working" does not tell us much. What exactly is not working?

Posted 24-Jun-13 23:38pm

Pheonyx

Comments

Master Vinu 25-Jun-13 5:51am

thx pheonyx..... i have update the query, but when i was try to update the cell value its neither update nor give any error

Pheonyx 25-Jun-13 5:54am

Okay, so my next question is why did you decide not to use a parameter for passing the Id to the query like you did with the @Reject parameter?

After that, When you are stepping through are the correct values being retrieved for "id" and for "@Reject" ?

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)

Master Vinu · Accepted Answer · 2013-06-25T00:02:00

private void button1_Click(object sender, EventArgs e)
       {
           if (objConn1.State != ConnectionState.Open)
           {
               objConn1.Open();
           }

           for (int i = 0; i < dataGridView1.SelectedRows.Count; i++)
           {
               DialogResult result;
               result = MessageBox.Show("Are You sure want to Delete?", "Conformation", MessageBoxButtons.YesNo);
               if (result == System.Windows.Forms.DialogResult.Yes)
               {
                   //string sql = "update   [SAPProduction].[ProductionData] set Rejection  " + " Where id = '" + dataGridView2.CurrentRow.Cells["id"].Value.ToString() + "'  ";
                   // Jobcard = your desire Rows Jobcard Id
                   SqlCommand command = new SqlCommand("UPDATE SAPProduction.ProductionData_BK SET Rejection = @Reject Where id = '" + dataGridView1.CurrentRow.Cells["id"].Value.ToString() + "'  ", objConn1);


                   command.Parameters.AddWithValue("@Reject", dataGridView1.CurrentRow.Cells["Rejection"].Value.ToString());



                               //objConn1.Open();
                   command.ExecuteNonQuery();
                   objConn1.Close();

               }
           }
       }