public void bindFacultyType() { String str = ""; if (Session["User_Id"].ToString() == (100).ToString()) { str = ""; } else { str = " where FACID=" + Session["User_Id"].ToString(); } try { if (con.State == ConnectionState.Open) { con.Close(); } con.Open(); DataTable dt = new DataTable(); SqlCommand cmd = new SqlCommand("Select Distinct FACID from FACULTY_PROFILE$" + str, con); SqlDataAdapter da = new SqlDataAdapter(cmd); da.Fill(dt); con.Close(); Ddlfacultyid.DataSource = dt; Ddlfacultyid.DataValueField = "FACID"; Ddlfacultyid.DataBind(); Ddlfacultyid.Items.Insert(0, new ListItem("Select", "")); } catch (Exception ee) { Response.Write("<script>alert('Error While Binding Faculty');</script>"); } }
public void bindFacultyType() { try { SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["UniversityDatabaseConnectionString"].ConnectionString); con.Open(); DataTable dt = new DataTable(); SqlCommand cmd = new SqlCommand("Select Distinct FACID from FACULTY_PROFILE$", con); SqlDataAdapter da = new SqlDataAdapter(cmd); da.Fill(dt); con.Close(); Ddlfacultyid.DataSource = dt; Ddlfacultyid.DataValueField = "FACID"; Ddlfacultyid.DataBind(); Ddlfacultyid.Items.Insert(0, new ListItem("Select", "")); } catch (Exception ee) { Response.Write("<script>alert('Error While Binding Faculty!!');</script>"); } }