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
|
protected void DDLnumpc_SelectedIndexChanged(object sender, EventArgs e)
{
SqlConnection cn = new SqlConnection();
DataSet dtst;
SqlDataAdapter adp = new SqlDataAdapter();
cn.ConnectionString = "Data Source=amine;Initial Catalog=bdSPR;Integrated Security=True";
cn.Open();
SqlCommand com = new SqlCommand("select NumP,NatP,RibRip,NumCcmpt,LibP,dateP,NumT,numfact,mntp,ModP,NumVt,NumCh,NumSt from PieceComptable where NumP='"+DDLnumpc.SelectedValue+"'", cn);
adp.SelectCommand=com;
if(Session[Ds]!= null)
{
dtst = Session[Ds] as DataSet;
adp.Fill(dtst,"Table[1]");
//Merger les résultat de deux DataTable
dtst.Tables[0].Merge(dtst.Table[1]);
}
else
{
dtst = new DataSet();
adp.Fill(dtst,"Table[0]");
}
Grd.DataSource = dtst.Tables[0];
Grd.DataBind();
//Sauvergarder le nouveau dataset
Session[Ds]=dtst;
} |
Partager