how to Update gridview value in windows application?

Question

3.00/5 (1 vote)

See more:

HI all, i am new to c# , pls guide me.

i have fetch the data in gridview as per below code ,
now i have to edit and update value in gridview and save into database.
how can i achive???
thx in advance allll

C#

private void findlaksajob_KeyPress(object sender, KeyPressEventArgs e)
        {
            if (e.KeyChar == (char)13)
            {
                string sql = "SELECT [Jobcard],[Planqty],[Mouldqty],[Operator],[Supervisor],[Profilename],[Process],[Date],[Remark],[Approvedby],[id],[Division],[Od] FROM [SAPProduction].[ProductionData] WHERE JobCard ='" + findlaksajob.Text.ToString() + "'";
                SqlDataAdapter da = new SqlDataAdapter(sql, objConn1);
                DataSet ds = new DataSet();
                objConn1.Open();
                da.Fill(ds, "ProductionData");
                dataGridView2.DataSource = ds;
                dataGridView2.DataMember = "ProductionData";
                objConn1.Close();
                e.Handled = true;
            }

        }

Posted 30-Nov-12 22:24pm

Master Vinu

Updated 30-Nov-12 22:27pm

v4

Add a Solution

6 solutions

Solution 1

Same way, go for updating and inserting into database.. :)
Hey go with this, awesome article:
http://www.c-sharpcorner.com/UploadFile/rohatash/insert-edit-update-and-delete-data-with-datagridview-in-wi/[^]

Posted 30-Nov-12 22:28pm

Krunal Rohit

Updated 30-Nov-12 22:44pm

v2

Comments

Master Vinu 1-Dec-12 4:32am

krunal, but i have to edit it after fetching data in gridview and update it..
pls advice how to code it

[no name] 1-Dec-12 4:44am

I have just updated solution, have a look at that :)

Master Vinu 1-Dec-12 5:08am

@Krunal R :
http://localhost:2268/Service1.svc error while using this url in add reference services

[no name] 1-Dec-12 5:14am

Lol, You have used that service, thats fine, but why didn't you change the references of it ?

[no name] 1-Dec-12 5:14am

To consume this service, you need to add service reference in your app..

Master Vinu 1-Dec-12 5:17am

ya while add this url in my application i got error that its link is not valid

[no name] 1-Dec-12 5:21am

Could you please mail me your code ?

Master Vinu 1-Dec-12 5:24am

i have already posted it sir

[no name] 1-Dec-12 5:26am

entire project..

Solution 3

Hi Dear,

Please see this code.
Here Use Two function
(1) FxInsert
(2) FxUpdate

FxInsert : Description how to insert data in SQL server Database.
FxUpdate : Description how to Update data in SQL server Database.

Function : FxInsert

C#

private void FxInsert()
        {
            for (int i = 0; i < dataGridView2.RowCount - 1; i++)
            {
                string sql = "INSERT INTO [SAPProduction].[ProductionData] ( [Jobcard],[Planqty],[Mouldqty],[Operator],[Supervisor],[Profilename],[Process],[Date],[Remark],[Approvedby],[id],[Division],[Od]) " +
               " 

VALUES('" + dataGridView2.Rows[i].Cells[" Jobcard]"].Value.ToString() + "' " +
" '" + dataGridView2.Rows[i].Cells["[Planqty]"].ToString() + "' " +
" '" + dataGridView2.Rows[i].Cells["[Mouldqty]"].ToString() + "' " +
"'" + dataGridView2.Rows[i].Cells["[Operator]"].ToString() + "'  " +
"'" + dataGridView2.Rows[i].Cells["[Supervisor]"].ToString() + "' " +
" '" + dataGridView2.Rows[i].Cells["[Profilename]"].ToString() + "'" +
" '" + dataGridView2.Rows[i].Cells["[Process]"].ToString() + "'" +
" '" + dataGridView2.Rows[i].Cells["[Date]"].ToString() + "' " +
"  '" + dataGridView2.Rows[i].Cells["[Remark]"].ToString() + "' " +
" '" + dataGridView2.Rows[i].Cells["[Approvedby]"].ToString() + "' " +
" '" + dataGridView2.Rows[i].Cells["[id]"].ToString() + "' " +
" '" + dataGridView2.Rows[i].Cells["[Division]"].ToString() + "' " +
" '" + dataGridView2.Rows[i].Cells["[Od]"].ToString() + "' ) ";

               SqlCommand cmd = new SqlCommand(sql, objConn1);
               objConn1.Open();
               cmd.ExecuteNonQuery();
               objConn1.Close();
            }
        }

--------------------------------------------------------------

Function : FxUpdate

C#

private void FxUpdate()
       {
           for (int i = 0; i < dataGridView2.RowCount - 1; i++)
           {
               string sql = "UPDATE [SAPProduction].[ProductionData] SET " +

              " [Jobcard]= '" + dataGridView2.Rows[i].Cells["[Jobcard]"].Value.ToString() + "' , " +
              " [Planqty]= '" + dataGridView2.Rows[i].Cells["[Planqty]"].ToString() + "',  " +
              " [Mouldqty] = '" + dataGridView2.Rows[i].Cells["[Mouldqty]"].ToString() + "', " +
              " [Operator] =  '" + dataGridView2.Rows[i].Cells["[Operator]"].ToString() + "', " +
              " [Supervisor] = '" + dataGridView2.Rows[i].Cells["[Supervisor]"].ToString() + "' , " +
              " [Profilename] ='" + dataGridView2.Rows[i].Cells["[Profilename]"].ToString() + "' , " +
              " [Process]='" + dataGridView2.Rows[i].Cells["[Process]"].ToString() + "' , " +
              " [Date]='" + dataGridView2.Rows[i].Cells["[Date]"].ToString() + "' , " +
              " [Remark]='" + dataGridView2.Rows[i].Cells["[Remark]"].ToString() + "' , " +
              " [Approvedby]='" + dataGridView2.Rows[i].Cells["[Approvedby]"].ToString() + "' , " +
              " [id]='" + dataGridView2.Rows[i].Cells["[id]"].ToString() + "' , " +
              " [Division]='" + dataGridView2.Rows[i].Cells["[Division]"].ToString() + "' ";
               SqlCommand cmd = new SqlCommand(sql, objConn1);
               objConn1.Open();
               cmd.ExecuteNonQuery();
               objConn1.Close();
           }
       }

Posted 1-Dec-12 0:33am

azizulhoque.bd

Updated 1-Dec-12 0:34am

v2

Comments

Master Vinu 1-Dec-12 7:11am

dear aziz , thx for your code but gives error jobcard column not found but its exsist and column id is primary we have to update it on id

Master Vinu 1-Dec-12 7:27am

i have tried this but not working
private void Update_Click(object sender, EventArgs e)

{
for (int i = 0; i < dataGridView2.RowCount - 1; i++)
{
string sql = "UPDATE [SAPProduction].[ProductionData] SET " +

" Jobcard= '" + dataGridView2.Rows[i].Cells["Jobcard"].ToString() + "' , " +
" Planqty= '" + dataGridView2.Rows[i].Cells["Planqty"].ToString() + "', " +
" Mouldqty = '" + dataGridView2.Rows[i].Cells["Mouldqty"].ToString() + "', " +
" Operator = '" + dataGridView2.Rows[i].Cells["Operator"].ToString() + "', " +
" Supervisor = '" + dataGridView2.Rows[i].Cells["Supervisor"].ToString() + "' , " +
" Profilename ='" + dataGridView2.Rows[i].Cells["Profilename"].ToString() + "' , " +
" Process='" + dataGridView2.Rows[i].Cells["Process"].ToString() + "' , " +
" Date='" + dataGridView2.Rows[i].Cells["Date"].ToString() + "' , " +
" Remark='" + dataGridView2.Rows[i].Cells["Remark"].ToString() + "' , " +
" Approvedby='" + dataGridView2.Rows[i].Cells["Approvedby"].ToString() + "' , " +
" id='" + dataGridView2.Rows[i].Cells["id"].ToString() + "' , " + " Division='" + dataGridView2.Rows[i].Cells["Division"].ToString() + "' , " + " Od='" + dataGridView2.Rows[i].Cells["Od"].ToString() + "'";

SqlCommand cmd = new SqlCommand(sql, objConn1);
objConn1.Open();
cmd.ExecuteNonQuery();
objConn1.Close();
}

Solution 2

http://etgconsultancy.com/AspNetControls/Edit-gridview-save-dataset-to-database.aspx[^]
http://www.c-sharpcorner.com/Blogs/8387/[^]
http://www.dotnetfunda.com/forums/thread8059-gridview-edit-data-and-save-the-data-in-database-usig-csharp.aspx[^]

Posted 1-Dec-12 0:20am

ridoy

Solution 4

Hi dear,

Check this code.

C#

private void Update_Click(object sender, EventArgs e) 
{
 string sql = "UPDATE [SAPProduction].[ProductionData] SET " +                  
                    " Planqty= '" + dataGridView2.Rows[i].Cells["Planqty"].ToString() + "', " + 
                    " Mouldqty = '" + dataGridView2.Rows[i].Cells["Mouldqty"].ToString() + "', " + 
                    " Operator = '" + dataGridView2.Rows[i].Cells["Operator"].ToString() + "', " + 
                    " Supervisor = '" + dataGridView2.Rows[i].Cells["Supervisor"].ToString() + "' , " + 
                    " Profilename ='" + dataGridView2.Rows[i].Cells["Profilename"].ToString() + "' , " + 
                    " Process='" + dataGridView2.Rows[i].Cells["Process"].ToString() + "' , " + 
                    " Date='" + dataGridView2.Rows[i].Cells["Date"].ToString() + "' , " + 
                    " Remark='" + dataGridView2.Rows[i].Cells["Remark"].ToString() + "' , " + 
                    " Approvedby='" + dataGridView2.Rows[i].Cells["Approvedby"].ToString() + "' , " + 
                    " id='" + dataGridView2.Rows[i].Cells["id"].ToString() + "' , " + 
                    " Division='" + dataGridView2.Rows[i].Cells["Division"].ToString() + "' , " + 
                    " Od='" + dataGridView2.Rows[i].Cells["Od"].ToString() + "' "+
                    " Where Jobcard = '" + dataGridView2.CurrentRow.Cells["Jobcard"].Value.ToString() + "' "; // Jobcard = your desire Rows Jobcard Id

                SqlCommand cmd = new SqlCommand(sql, objConn1); 
                objConn1.Open(); 
                cmd.ExecuteNonQuery(); 
                objConn1.Close();
}

Posted 1-Dec-12 1:50am

azizulhoque.bd

Updated 1-Dec-12 2:04am

v2

Comments

Master Vinu 3-Dec-12 2:59am

need code for delete row through datagrid

Solution 5

Only u add a button and type update on it's text property
updatebtn_click event

da.update(ds);
messagebox.show("Update successfully");

where da=SqlDataAdapter and ds=DataSet

Thanks & regard
Sham:)

Posted 1-Dec-12 2:11am

Shambhoo kumar

Updated 1-Dec-12 2:12am

v2

Comments

Master Vinu 3-Dec-12 1:53am

shamboo pls do the changes in code

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)

azizulhoque.bd · Accepted Answer · 2012-12-02T21:33:00

Hi dear,

C#

private void FxDelete()
{
    string sql = "DELETE FROM [SAPProduction].[ProductionData] WHERE  [id] = '" + dataGridView2.Rows[i].Cells["[id]"].Value.ToString() + "' ";
    SqlCommand cmd = new SqlCommand(sql, objConn1);
    objConn1.Open();
    cmd.ExecuteNonQuery();
    objConn1.Close();
}

If you like this solution plz vote.