protected void FillMeetingDropDown1() { FillControls fc = new FillControls(); SqlConnection con = DataAccess.GetConnction(); try { SqlCommand cmd = new SqlCommand("spFillMeeting", con); cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.Parameters.Add(new SqlParameter { ParameterName = "@MinistryId", DbType = DbType.String, Size = 50, Value = Session["ministry"] != null? Session["ministry"].ToString():"0" }); fc.fillDropDown(cmd, ddlMeetingFilter, "MeetingDate", "MeetingDateI", "----Select Meeting----", ""); } catch (Exception e) { LogError(e); } finally { if (con.State == System.Data.ConnectionState.Open) { con = null; } } }