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(); } } } }
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)