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"); } }