And in the display I two not display Id_autorization and when I want to click on the modifier
it does not work with this request Program.cmd.CommandText = "authorization
update
in Id_site = (select top 1 Id_site site from the site where Libelle_site = '" + comboBox2.Text + "'),
Id_user = (select top 1 utilisateur User_name = '"+ comboBox1. Text +"'),
Id_profil = (select top 1 Id_profil from profil where Libelle_profile = '"+ comboBox3.Text +"')
where Id_user = (select top 1 utilisateur User_name = @par1)"; Program.cmd.Parameters.AddWithValue("@par1", comboBox1.Text);Program.cmd.ExecuteNonQuery (); the same problem in delete Program.cmd.CommandText = "delete from autorisation where Id_user = (select top 1 utilisateur User_name = @par1)"; Program.cmd.Parameters.AddWithValue("@par1", comboBox1.Text);Program.cmd.Parameters.AddWithValue("@del", comboBox1.Text); Program.cmd.ExecuteNonQuery();In short how to do the deletion and modification without writing in the clause where Id_autorisation = ....And thanks in advance friends
Program.cmd.Parameters.AddWithValue("@par1", comboBox1.Text);
Program.cmd.ExecuteNonQuery ();
the same problem in delete
Program.cmd.CommandText = "delete from autorisation where Id_user = (select top 1 utilisateur User_name = @par1)"; Program.cmd.Parameters.AddWithValue("@par1", comboBox1.Text);Program.cmd.Parameters.AddWithValue("@del", comboBox1.Text); Program.cmd.ExecuteNonQuery();In short how to do the deletion and modification without writing in the clause where Id_autorisation = ....And thanks in advance friends
Id_user = (select top 1 utilisateur User_name = @par1)"; Program.cmd.Parameters.AddWithValue("@par1", comboBox1.Text);Program.cmd.Parameters.AddWithValue("@del", comboBox1.Text); Program.cmd.ExecuteNonQuery();In short how to do the deletion and modification without writing in the clause where Id_autorisation = ....And thanks in advance friends
Program.cmd.Parameters.AddWithValue("@del", comboBox1.Text);
Program.cmd.ExecuteNonQuery();
In short how to do the deletion and modification without writing in the clause where Id_autorisation = ....
And thanks in advance friends