public void specificationlist()
 {
     Code cd = new Code();
     cd.role = "2";
     DataSet ds = cd.viewdata();
     if (ds != null && ds.Tables[0].Rows.Count > 0)
     {
         DropDownList2.DataTextField = "Name";
         DropDownList2.DataValueField = "ID";
         DropDownList2.DataSource = ds;
         DropDownList2.DataBind();
     }
 }
 public void specialistdata()
 {
     Code cd = new Code();
     cd.role = "2";
     DataSet ds = cd.viewdata();
     if (ds != null && ds.Tables[0].Rows.Count > 0)
     {
         DropDownList1.DataTextField = "Name";
         DropDownList1.DataValueField = "ID";
         DropDownList1.DataSource = ds;
         DropDownList1.DataBind();
         DropDownList1.Items.Insert(0, "Select Specialist");
     }
 }
    public void countrynames()
    {
        Code cd = new Code();
        cd.role = "6";
        DataSet ds = cd.viewdata();
        if (ds != null && ds.Tables[0].Rows.Count > 0)
        {
            DropDownList4.DataTextField = "Name";
            DropDownList4.DataValueField = "ID";
            DropDownList4.DataSource = ds;
            DropDownList4.DataBind();

            DropDownList5.DataTextField = "Name";
            DropDownList5.DataValueField = "ID";
            DropDownList5.DataSource = ds;
            DropDownList5.DataBind();
        }
    }