SqlConnection sqlconn=new SqlConnection("Server=(local);Database= ;User Id=sa;password=;");
sqlconn.Open();
SqlDataAdapter sda1=new SqlDataAdapter("select * from ",sqlconn);
DataSet ds1=new DataSet();
sda1.Fill(ds1);
olddepname.DataSource=ds1.Tables[0].DefaultView;
olddepname.DataTextField=" ";
olddepname.DataValueField =" ";
olddepname.DataBind();
sqlconn.Open();
SqlDataAdapter sda1=new SqlDataAdapter("select * from ",sqlconn);
DataSet ds1=new DataSet();
sda1.Fill(ds1);
olddepname.DataSource=ds1.Tables[0].DefaultView;
olddepname.DataTextField=" ";
olddepname.DataValueField =" ";
olddepname.DataBind();