1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44
| public void Connx_ajoutt(object sender, System.EventArgs e){
string code = "select code_comptable from rubrique ";
MaRequete cmd8 = new MaRequete();
SqlDataReader reader;
reader = cmd8.ExRequete(code);
int codereader;
if (reader.Read())
{
codereader = reader.GetInt32(0);
}
string mont = codece.Text;
int b = int.Parse(mont);
codereader = reader.GetInt32(0);
if (b.CompareTo(codereader)== 1)
{
Response.Redirect("erreur.aspx");
// Response.Redirect("erreur.aspx");
////Response.Write("tt");
}
else
{
string cod = " INSERT INTO RUBRIQUE(CODE_COMPTABLE,DESIGNATION, ID_RUBRIQUE_MERE)VALUES( " + b + " ,'" + rubrique.Text + "', null) ";
MaRequete cmd2 = new MaRequete();
cmd2.ExRequete_N_SELECT(cod);
cmd2.FermerReader();
Response.Redirect("confirmationrub.aspx");}} |
Partager