public void bind_ddl()
{
try
{
bl.Category = "yes_no";
dtt = dl.Ddl_cat_list(bl);
ddl_smoking.Items.Clear();
ddl_smoking.DataSource = dtt.table;
ddl_smoking.DataTextField = "name";
ddl_smoking.DataValueField = "id";
ddl_smoking.DataBind();
ddl_smoking.Items.Insert(0, new ListItem("Select Smoking", "0"));
ddl_alcpohal.Items.Clear();
ddl_alcpohal.DataSource = dtt.table;
ddl_alcpohal.DataTextField = "name";
ddl_alcpohal.DataValueField = "id";
ddl_alcpohal.DataBind();
ddl_alcpohal.Items.Insert(0, new ListItem("Select Alcoholic", "0"));
bl.Category = "bp";
dtt = dl.Ddl_cat_list(bl);
ddl_bp.Items.Clear();
ddl_bp.DataSource = dtt.table;
ddl_bp.DataTextField = "name";
ddl_bp.DataValueField = "id";
ddl_bp.DataBind();
ddl_bp.Items.Insert(0, new ListItem("Select Blood Pressure", "0"));
bl.Category = "diabatic";
dtt = dl.Ddl_cat_list(bl);
ddl_diabetic.Items.Clear();
ddl_diabetic.DataSource = dtt.table;
ddl_diabetic.DataTextField = "name";
ddl_diabetic.DataValueField = "id";
ddl_diabetic.DataBind();
ddl_diabetic.Items.Insert(0, new ListItem("Select Diabetic", "0"));
}
catch (NullReferenceException)
{
// Utilities.MessageBox_UpdatePanel_Redirect(UpdatePanel2, "Your Session Has Expired Please Login Again", "../Logout.aspx");
}
}
