1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21
|
protected void initializeSDS()
{
string strConnection = HttpContext.Current.Session["connexion"].ToString();
sdsConsultant.ConnectionString = strConnection;
//SELECT
sdsConsultant.ID = "monID";
sdsConsultant.SelectCommand = maRequete;
QueryStringParameter id = new QueryStringParameter("YEAR", DropDownListAnnee.SelectedValue.ToString());
sdsConsultant.SelectParameters.Add(id);
QueryStringParameter id2 = new QueryStringParameter("COD_USER", DropDownListActeur.SelectedValue.ToString());
sdsConsultant.SelectParameters.Add(id2);
Page.Controls.Add(sdsConsultant);
sdsConsultant.DataBind();
GridView2.DataSourceID = sdsConsultant.ID;
GridView2.DataBind();
sdsConsultant.Dispose();
//Page.DataBind();
} |
Partager