Click here to Skip to main content
15,886,362 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
i have datagridview and i want to update values after changing cell value
like from checked to un checked.

aut — ImgBB[^]

What I have tried:

public void updateaccess()

       {
           foreach (DataGridViewRow row in dataGridView2.Rows)
           {
               string constring = @"Data Source = MOHAMEDTHRWAT20\SQLEXPRESS; Initial Catalog = SharpControl; Integrated Security = True";
               using (SqlConnection con = new SqlConnection(constring))
               {
                   using (SqlCommand cmd = new SqlCommand("UPDATE [dbo].[UserPr] SET [CanShow]=@CanShow,[CanOpen]=@CanOpen,[CanAdd]=@CanAdd,[CanEdit]=@CanEdit,[CanDelete]=@CanDelete,[CanPrint]=@CanPrint WHERE UseID='" + TXT_ID.Text + "'", con))
                   {
                       cmd.Parameters.AddWithValue("@UseID", row.Cells["UseID"].Value);
                       cmd.Parameters.AddWithValue("@CanShow", Convert.ToBoolean(row.Cells["CanShow"].Value));
                       cmd.Parameters.AddWithValue("@CanOpen", Convert.ToBoolean(row.Cells["CanOpen"].Value));
                       cmd.Parameters.AddWithValue("@CanAdd", Convert.ToBoolean(row.Cells["CanAdd"].Value));
                       cmd.Parameters.AddWithValue("@CanEdit", Convert.ToBoolean(row.Cells["CanEdit"].Value));
                       cmd.Parameters.AddWithValue("@CanDelete", Convert.ToBoolean(row.Cells["CanDelete"].Value));
                       cmd.Parameters.AddWithValue("@CanPrint", Convert.ToBoolean(row.Cells["CanPrint"].Value));
                       con.Open();
                       cmd.ExecuteNonQuery();
                       MessageBox.Show("Record Updated Successfully");
                       SEARRCH_access();
                       con.Close();
                   }
               }
           }
       }
Posted
Comments
Member 15627495 17-Sep-22 1:50am    
look at all the 'column' type existing for datagridview. ( button / checkbox / textbox )

https://learn.microsoft.com/en-us/dotnet/api/system.windows.forms.datagridviewtextboxcolumn?view=windowsdesktop-6.0
[no name] 17-Sep-22 15:04pm    
Working with the data grid instead of an actual (backing) "data collection" is like eating with oven mitts on.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900