更新c＃窗口中的gridview值 [英] Update gridview value in c# windows

问题描述

我有1个网格和记录是

id name

1 vishnu

2 ram



现在我的要求是当我在gridview中获取数据时，然后我选择一行并从id中选择值1并更新为5 ..并且在点击按钮值之后应该在数据库中更新。

怎么办请帮助





提前付款





代码用于填写gridview：

i have 1 gridiew and records are
id name
1 vishnu
2 ram

now my requirement is when i get data in gridview, then i select a row and select value 1 from id and update to 5.. and after click on button value should be updated in database.
how to do pls help


thanks in advance


code is for fill the gridview:

string sql1 = "SELECT [Jobcard],[Planqty],[Mouldqty],[Operator],[Supervisor],[Profilename],[Process],[Date],[Remark],[Approvedby],[id],[Division] FROM [SAPProduction].[ProductionData] WHERE JobCard ='" + findjobsap.Text.ToString() + "'";
                    SqlDataAdapter da = new SqlDataAdapter(sql1, objConn1);
                    DataSet ds = new DataSet();
                    //objConn1.Open();
                    da.Fill(ds, "ProductionData");
                    dataGridView2.DataSource = ds;
                    dataGridView2.DataMember = "ProductionData";
                    objConn1.Close();
                    e.Handled = true;

推荐答案

查看此article

数据库更新使用DataGridView的简单步骤 [ ^ ]

See this article
DataBase Updation With DataGridView in simple steps[^]

这篇关于更新c＃窗口中的gridview值的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！