private void Country()
{
ddlCountry.Items.Clear();
con.Open();
SqlCommand Show = new SqlCommand();
Show.Connection = con;
Show.CommandText = @"select ID, Name from Country order by Name";
SqlDataReader DATA;
DATA = Show.ExecuteReader();
ddlCountry.Items.Add(new ListItem("Select Country", "0"));
while (DATA.Read())
{
ListItem new_Item = new ListItem();
new_Item.Text = DATA["Name"].ToString();
new_Item.Value = DATA["ID"].ToString();
ddlCountry.Items.Add(new_Item);
}
con.Close();
}
private void Upazila(int ID)
{
ddlUpazila.Items.Clear();
con.Open();
SqlCommand Show = new SqlCommand();
Show.Connection = con;
Show.CommandText = @"select ID, Name from Upazila where LinkID=" + ID + " order by Name";
SqlDataReader DATA;
DATA = Show.ExecuteReader();
ddlUpazila.Items.Add(new ListItem("Select Upazila", "0"));
while (DATA.Read())
{
ListItem new_Item = new ListItem();
new_Item.Text = DATA["Name"].ToString();
new_Item.Value = DATA["ID"].ToString();
ddlUpazila.Items.Add(new_Item);
}
con.Close();
}
private void DocotorCatagoris()
{
ddlDoctorCatagoris.Items.Clear();
con.Open();
SqlCommand Show = new SqlCommand();
Show.Connection = con;
Show.CommandText = @"select ID, Catagoris from DoctorCatagoris order by Catagoris";
SqlDataReader DATA;
DATA = Show.ExecuteReader();
ddlDoctorCatagoris.Items.Add(new ListItem("Doctor Categories", "0"));
while (DATA.Read())
{
ListItem new_Item = new ListItem();
new_Item.Text = DATA["Catagoris"].ToString();
new_Item.Value = DATA["Catagoris"].ToString();
ddlDoctorCatagoris.Items.Add(new_Item);
}
con.Close();
}
