5eme jours de Préparation TDI2

barca102 a écrit:alkhoute awnouna flasp rah la mise a jour mataybghiche ydriha voila le code
rah le meme dyal khay hicham:
public static SqlDataAdapter da = new SqlDataAdapter();
public static SqlDataReader dr;
public static SqlConnection cn = new SqlConnection(@"Data
Source=.\\SQLEXPRESS;Initial Catalog=EfmAspCsharp;Integrated
Security=True");
public static SqlCommand cmd = new SqlCommand();
public static DataSet ds = new DataSet();
public static DataTable dt;

protected void Page_Load(object sender, EventArgs e)
{


try
{
cmd = new SqlCommand("select nom_marque From Marque", cn);



dr = cmd.ExecuteReader();
while (dr.Read())
{
dt.Rows.Add(dr[0]);
}
dr.Close();
cn.Close();

}
catch (Exception)
{
Response.Write("ok");


}
finally { Response.Write("jhjhjhjh"); }

}

protected void Button1_Click(object sender, EventArgs e)
{
//try
//{
// cmd = cn.CreateCommand();
// cmd.CommandText = "insert into vehicule(numero_serie
,immatriculation ,date_sortie,code_marque ) values (@numero_serie
,@immatriculation ,@date_sortie,@code_marque )";
// cmd.Parameters.Add("@numero_serie", SqlDbType.Int, 5, "numero_serie");
// cmd.Parameters.Add("@immatriculation", SqlDbType.VarChar, 5, "immatriculation");
// cmd.Parameters.Add("@date_sortie", SqlDbType.DateTime, 15, "date_sortie");
// cmd.Parameters.Add("@code_marque", SqlDbType.Int, 5, "code_marque");
// cn.Open();
// cmd.ExecuteNonQuery();
// cn.Close();
//
Page.ClientScript.RegisterClientScriptBlock(typeof(Page), "script",
string.Format("alert('ajout avec succes')"), true);
// Response.Write("ok");
//}
//catch (Exception)
//{
// Response.Write("rrrrrr");
//}
//finally
//{
// cn.Close();
//}
try{
cmd = new SqlCommand("select * from Marque where nom_marque=@nom_marque", cn);

cn.Open();
cmd.Parameters.AddWithValue("@nom_marque", DropDownList1.Text);
int m;
dr = cmd.ExecuteReader();
//while ((dr.Read()));
// {
// ;
// }
http://dr.Close();

cmd =new SqlCommand("insert into vehicule(numero_serie
,immatriculation ,date_sortie,code_marque ) values (@numero_serie
,@immatriculation ,@date_sortie,@code_marque)", cn);
cmd.Parameters.AddWithValue("@numero_serie", TextBox1.Text);
cmd.Parameters.AddWithValue("@immatriculation",TextBox2.Text );
cmd.Parameters.AddWithValue("@date_sortie", TextBox3.Text);
cmd.Parameters.AddWithValue("@code_marque", DropDownList1.Text);

cmd.ExecuteNonQuery();

cn.Close();

Response.Write("Ajout Bien effectuer");
}
catch{
Response.Write("Vehicule existe déja");
}

finally{Response.Write("erreur");

}
}

barca102 a écrit:kayaficher fload baada lmessage dyal catch wfinally wmli canclicker ala ajouter
kayaficher la meme chose lmessage dyal catch wfinally