Use class or one method to bind three cascading DDL

Mohamad Simo

I trying my best to make my web application faster as much as i can, so one of what i am looking is reducing the codes into each page. So i have three DDL as mention below they do the same job to bind the DDL's depending on cookie value. So how i can create a class and use it for to bind all DDL's or i dont know if it possible to bind three of those DDLs into one method as below method as they are doing the same job?

-StateHPDDL

-BizstateHPFilterDDL

-filterstathpjob

the code used for each DDL in page_load is as below

if (!IsPostBack)
{
if (cookie["Location"] == null)
{
DataTable filterstathpAdsDT = new DataTable();
using (SqlConnection filterstathpAdsCon = new SqlConnection(cs))
{
SqlCommand filterstathpAdsCMD = new SqlCommand("SELECT State FROM State WHERE Country = @Location", filterstathpAdsCon);
var Location = cookie.Value;
filterstathpAdsCMD.Parameters.AddWithValue("@Location", Location);
SqlDataAdapter filterstathpAdsAP = new SqlDataAdapter();
filterstathpAdsAP.SelectCommand = filterstathpAdsCMD;
filterstathpAdsAP.Fill(filterstathpAdsDT);
StateHPDDL.DataSource = filterstathpAdsDT;
StateHPDDL.DataTextField = "State";
StateHPDDL.DataBind();
}
StateHPDDL.Items.Insert(0, new ListItem("Select Province", ""));
}
}

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Mohamad Simo10y ago
My question did there is a way to combine and bind three cascading ddl which they do the same job into one method like the method below into page_load of StateHPDDL. if it possible the i can reduce the code into my page and that will make the page faster. So what i am asked is i dont know if it possible to bind the three DDLs that i mention above into one part so the below code part suppose to bind the three DDLs if it possible instead to have three code part as below of each ddl
if(!IsPostBack)
{
if(cookie["Location"]==null)
{
DataTablefilterstathpAdsDT=newDataTable();
using(SqlConnectionfilterstathpAdsCon=newSqlConnection(cs))
{
SqlCommandfilterstathpAdsCMD=newSqlCommand("SELECTStateFROMStateWHERECountry=@Location",filterstathpAdsCon);
varLocation=cookie.Value;
filterstathpAdsCMD.Parameters.AddWithValue("@Location",Location);
SqlDataAdapterfilterstathpAdsAP=newSqlDataAdapter();
filterstathpAdsAP.SelectCommand=filterstathpAdsCMD;
filterstathpAdsAP.Fill(filterstathpAdsDT);
StateHPDDL.DataSource=filterstathpAdsDT;
StateHPDDL.DataTextField="State";
StateHPDDL.DataBind();
}
StateHPDDL.Items.Insert(0,newListItem("SelectProvince",""));
}
}
0
Prakash Tripathi10y ago
Can you please provide more clarity in the requirement plz?
0