protected void Page_Load(object sender, EventArgs e)
{
try
{
db.s = "select numFournisseur from fournisseur";
SqlDataAdapter cmd = new SqlDataAdapter(db.s, db.cnx);
DataTable dt = new DataTable();
cmd.Fill(dt);
DropDownlist1.DataSource = dt;
DropDownlist1.DataBind();
DropDownlist1.DataTextField = "numFournisseur";
DropDownlist1.DataBind();
db.s = "select numMarche from marche";
SqlDataAdapter c = new SqlDataAdapter(db.s, db.cnx);
DataTable d = new DataTable();
c.Fill(d);
DropDownlist2.DataSource = d;
DropDownlist2.DataBind();
DropDownlist2.DataTextField = "numMarche";
DropDownlist2.DataBind();
db.s = "select nom from fournisseur";
SqlDataAdapter ss = new SqlDataAdapter(db.s, db.cnx);
DataTable ee = new DataTable();
ss.Fill(ee);
DropDownlist3.DataSource = ee;
DropDownlist3.DataBind();
DropDownlist3.DataTextField = "nom";
DropDownlist3.DataBind();
} catch { }
}
protected void Page_Load(object sender, EventArgs e)
{
try {
db.s = "select numDeplacement from Deplacement";
SqlDataAdapter cmd = new SqlDataAdapter(db.s, db.cnx);
DataTable dt = new DataTable();
cmd.Fill(dt);
DropDownlist1.DataSource = dt;
DropDownlist1.DataBind();
DropDownlist1.DataTextField = "numDeplacement";
DropDownlist1.DataBind();
db.s = "select numMarche from marche";
SqlDataAdapter c = new SqlDataAdapter(db.s, db.cnx);
DataTable d = new DataTable();
c.Fill(d);
DropDownlist2.DataSource = d;
DropDownlist2.DataBind();
DropDownlist2.DataTextField = "numMarche";
DropDownlist2.DataBind();
} catch { }
}