this
you can use single datatable for all .
try this code
DataTable dt = new DataTable();
protected void Page_Load(object sender, EventArgs e)
{
}
1.
try
{
SqlDataAdapter da = new SqlDataAdapter("select * from manag where category ='Light' ", con);
dt=new datatable();
da.Fill(dt);
cbIlluminate.DataSource=dt;
cbIlluminate.DisplayMember="Choices";
con.Close();
}
Catch(System.Exception){}
2.
try
{
SqlDataAdapter da = new SqlDataAdapter("select * from manag where category ='Light' ", con);
dt=new datatable();
da.Fill(dt);
cbIlluminate.DataSource=dt;
cbIlluminate.DisplayMember="Choices";
con.Close();
}
Catch(System.Exception){}
3.
try
{
SqlDataAdapter da = new SqlDataAdapter("select * from manag where category ='Light' ", con);
dt=new datatable();
da.Fill(dt);
cbIlluminate.DataSource=dt;
cbIlluminate.DisplayMember="Choices";
con.Close();
}
Catch(System.Exception){}