1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21
| SqlCommand cmd = new SqlCommand(dbo.usp_admin_exist, cn);
cmd.CommandType = CommandType.StoredProcedure;
SqlParameter Nom_Admin = new SqlParameter("@_Nom_Admin", SqlDbType.VarChar);
Nom_Admin.Size = 32;
cmd.Parameters(Nom_Admin).Value = cb.Text
Nom_Admin.Direction = ParameterDirection.Input;
cmd.Parameters.Add(Nom_Admin);
SqlParameter Pwd_Admin = new SqlParameter("@_Pwd_Admin",SqlDbType.VarChar);
Pwd_Admin.Size = 32;
Pwd_Admin.Direction = ParameterDirection.Input;
cmd.Parameters(@Nom_Admin).Value = ???
SqlParameter exists = new SqlParameter("@_exists",SqlDbType.SqlBoolean);
exists.Direction = ParameterDirection.Output;
cmd.Parameters.Add(exists);
cn.Open();
cmd.ExecuteNonQuery();
cn.Close(); |
Partager