protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { if (Session["name"] == null) { Response.Redirect("~/loginPage.aspx"); } else { string username = Session["name"].ToString(); this.Label8.Text = string.Format("Hi {0}", Session["name"].ToString() + "!"); //Label8.Visible = false; //Label8.Text = username; string connString = ConfigurationManager.ConnectionStrings["tomms_prodConnectionString"].ConnectionString; SqlConnection con = null; try { con = new SqlConnection(connString); /*For State Dropdown Load*/ string com = "Select RowID, ast_lvl_ast_lvl from ast_lvl (nolock)"; SqlDataAdapter adpt = new SqlDataAdapter(com, con); DataTable dt = new DataTable(); adpt.Fill(dt); DropDownState.DataSource = dt; DropDownState.DataBind(); DropDownState.DataTextField = "ast_lvl_ast_lvl"; DropDownState.DataValueField = "RowID"; DropDownState.DataBind(); DropDownState.Items.Insert(0, new ListItem("ALL", "0")); /*For District Dropdown Load*/ DropDownDistrict.Items.Insert(0, new ListItem("ALL", "0")); /*For Clinic Cate Dropdown Load*/ DropDownCliniccat.Items.Insert(0, new ListItem("Dental Delivery Units", "1")); DropDownCliniccat.Items.Insert(0, new ListItem("CHAIRS, EXAMINATION/TREATMENT, DENTISTRY, SPECIALIST", "2")); DropDownCliniccat.Items.Insert(0, new ListItem("Chairs, Examination/Treatment, Dentistry", "3")); DropDownCliniccat.Items.Insert(0, new ListItem("ALL", "0")); } catch (Exception ex) { //log error //display friendly error to user string msg = "Insert Error:"; msg += ex.Message; throw new Exception(msg); } finally { con.Close(); } } } }
private void fillddl() { DropDownState.DataSource = db.manage_state(0, "", 4); DropDownState.DataTextField = "StateName"; DropDownState.DataValueField = "StateId"; DropDownState.DataBind(); DropDownState.Items.Insert(0, "--Select State--"); }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { if (Session["name"] == null) { Session["prevUrl"] = Request.Url; Response.Redirect("~/loginPage.aspx"); } else { string username = Session["name"].ToString(); this.Label8.Text = string.Format("Hi {0}", Session["name"].ToString() + "!"); string connString = ConfigurationManager.ConnectionStrings["tomms_prodConnectionString"].ConnectionString; SqlConnection con = null; try { con = new SqlConnection(connString); /*For State Dropdown Load*/ string com = "Select RowID, ast_lvl_ast_lvl from ast_lvl (nolock)"; SqlDataAdapter adpt = new SqlDataAdapter(com, con); DataTable dt = new DataTable(); adpt.Fill(dt); DropDownState.DataSource = dt; DropDownState.DataBind(); DropDownState.DataTextField = "ast_lvl_ast_lvl"; DropDownState.DataValueField = "RowID"; DropDownState.DataBind(); DropDownState.Items.Insert(0, new ListItem("--Select--", "0")); DropDownClinicCategory.Items.Insert(0, new ListItem("KESIHATAN", "1")); DropDownClinicCategory.Items.Insert(0, new ListItem("PERGIGIAN", "2")); DropDownClinicCategory.Items.Insert(0, new ListItem("ALL", "0")); // MyReportViewer.ServerReport.ReportServerUrl = new Uri("http://chs015-2-3/ReportServer"); MyReportViewer.ServerReport.ReportServerUrl = new Uri("http://Localhost/ReportServer"); MyReportViewer.ServerReport.ReportPath = "/AdditionalEB EquipmentList FORMVAR2/MEET"; MyReportViewer.ServerReport.Refresh(); } catch (Exception ex) { //log error //display friendly error to user string msg = "Insert Error:"; msg += ex.Message; throw new Exception(msg); } finally { con.Close(); } } } }
protected void loadstate() { if (DropDowncountry.SelectedIndex != 0) { int conutryId = Convert.ToInt32(DropDowncountry.SelectedValue); DataTable dt = mpDetailsBAL.loadState(conutryId); DropDownState.DataSource = dt; DropDownState.DataTextField = "state"; DropDownState.DataValueField = "stateId"; DropDownState.DataBind(); DropDownState.Items.Insert(0, new ListItem("Select State", "0")); string estate = dt1.Rows[0]["state"].ToString(); DropDownState.Items.FindByText(estate).Selected = true; loadconstituency();// to load and select the relevant constituency. DropDownpermanentState.DataSource = dt; DropDownpermanentState.DataTextField = "state"; DropDownpermanentState.DataValueField = "stateId"; DropDownpermanentState.DataBind(); DropDownpermanentState.Items.Insert(0, new ListItem("Select State", "0")); string pstate = dt1.Rows[0]["permanentState"].ToString(); DropDownpermanentState.Items.FindByText(pstate).Selected = true; loadpermanentDistrict(); DropDowncurrentState.DataSource = dt; DropDowncurrentState.DataTextField = "state"; DropDowncurrentState.DataValueField = "stateId"; DropDowncurrentState.DataBind(); DropDowncurrentState.Items.Insert(0, new ListItem("Select State", "0")); string cstate = dt1.Rows[0]["currentState"].ToString(); DropDowncurrentState.Items.FindByText(cstate).Selected = true; loadcurrentDistrict(); // put party in party combo box. dt.Dispose(); dt = mpDetailsBAL.loadParty(conutryId); DropDownparty.DataSource = dt; DropDownparty.DataTextField = "partyName"; DropDownparty.DataValueField = "partyId"; DropDownparty.DataBind(); DropDownparty.Items.Insert(0, new ListItem("Select Party", "0")); string pparty = dt1.Rows[0]["partyName"].ToString(); DropDownparty.Items.FindByText(pparty).Selected = true; } else { DropDownState.Items.Clear(); DropDownState.Items.Insert(0, new ListItem("Select State", "0")); DropDownpermanentState.Items.Clear(); DropDownpermanentState.Items.Insert(0, new ListItem("Select State", "0")); DropDowncurrentState.Items.Clear(); DropDowncurrentState.Items.Insert(0, new ListItem("Select State", "0")); } }
protected void DropDownZone_SelectedIndexChanged(object sender, EventArgs e) { string connString = ConfigurationManager.ConnectionStrings["tomms_prodConnectionString"].ConnectionString; SqlConnection con = null; try { con = new SqlConnection(connString); /*For Zone Dropdown Load*/ if (DropDownZone.SelectedItem.Text == "ALL") { /*For State Dropdown Load*/ string com = "Select RowID, ast_lvl_ast_lvl from ast_lvl (nolock)"; SqlDataAdapter adpt = new SqlDataAdapter(com, con); DataTable dt = new DataTable(); adpt.Fill(dt); DropDownState.DataSource = dt; DropDownState.DataBind(); DropDownState.DataTextField = "ast_lvl_ast_lvl"; DropDownState.DataValueField = "RowID"; DropDownState.DataBind(); DropDownState.Items.Insert(0, new ListItem("ALL", "0")); } else { /*For State Dropdown Load*/ string com = "Select distinct Dense_rank() Over(order by ast_loc_state) as RowID, ast_loc_state as ast_lvl_ast_lvl from ast_loc (Nolock) where ast_loc_zone = '" + DropDownZone.SelectedItem.Text + "'"; SqlDataAdapter adpt = new SqlDataAdapter(com, con); DataTable dt = new DataTable(); adpt.Fill(dt); DropDownState.DataSource = dt; DropDownState.DataBind(); DropDownState.DataTextField = "ast_lvl_ast_lvl"; DropDownState.DataValueField = "RowID"; DropDownState.DataBind(); DropDownState.Items.Insert(0, new ListItem("ALL", "0")); } } catch (Exception ex) { //log error //display friendly error to user string msg = "Insert Error:"; msg += ex.Message; } }
public void fillData() { DropDownState.DataTextField = objBusinessLayer.BusinessFillState().Columns[0].ToString(); objDataTableOne = objBusinessLayer.BusinessFillState(); DropDownState.DataSource = objDataTableOne; DropDownState.DataBind(); DropDownPlan.DataTextField = objBusinessLayer.BusinessFillPlan().Columns[0].ToString(); objDataTableTwo = objBusinessLayer.BusinessFillPlan(); DropDownPlan.DataSource = objDataTableTwo; DropDownPlan.DataBind(); Random rnd = new Random(); lblPatientID.Text = Convert.ToString(rnd.Next(10000, 99999)); }
public void State() { cn.Open(); //Response.Write(DropDownCountry.SelectedValue); using (SqlCommand cmd = new SqlCommand("select StateName,stateid from Statetable where CountryId='" + DropDownCountry.SelectedValue + "'", cn)) { using (SqlDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection)) { DropDownState.DataSource = dr; DropDownState.Items.Clear(); DropDownState.Items.Add("Please Select State"); DropDownState.DataTextField = "StateName"; DropDownState.DataValueField = "StateId"; DropDownState.DataBind(); } } }
protected void DropDowncountry_SelectedIndexChanged(object sender, EventArgs e) { if (DropDowncountry.SelectedIndex != 0) { int conutryId = Convert.ToInt32(DropDowncountry.SelectedValue); DataTable dt = mpDetailsBAL.loadState(conutryId); DropDownState.DataSource = dt; DropDownState.DataTextField = "state"; DropDownState.DataValueField = "stateId"; DropDownState.DataBind(); DropDownState.Items.Insert(0, new ListItem("Select State", "0")); DropDownpermanentState.DataSource = dt; DropDownpermanentState.DataTextField = "state"; DropDownpermanentState.DataValueField = "stateId"; DropDownpermanentState.DataBind(); DropDownpermanentState.Items.Insert(0, new ListItem("Select State", "0")); DropDowncurrentState.DataSource = dt; DropDowncurrentState.DataTextField = "state"; DropDowncurrentState.DataValueField = "stateId"; DropDowncurrentState.DataBind(); DropDowncurrentState.Items.Insert(0, new ListItem("Select State", "0")); // put party in party combo box. dt.Dispose(); dt = mpDetailsBAL.loadParty(conutryId); DropDownparty.DataSource = dt; DropDownparty.DataTextField = "partyName"; DropDownparty.DataValueField = "partyId"; DropDownparty.DataBind(); DropDownparty.Items.Insert(0, new ListItem("Select Party", "0")); } else { DropDownState.Items.Clear(); DropDownState.Items.Insert(0, new ListItem("Select State", "0")); DropDownpermanentState.Items.Clear(); DropDownpermanentState.Items.Insert(0, new ListItem("Select State", "0")); DropDowncurrentState.Items.Clear(); DropDowncurrentState.Items.Insert(0, new ListItem("Select State", "0")); } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { string connString = ConfigurationManager.ConnectionStrings["tomms_prodConnectionString"].ConnectionString; SqlConnection con = null; try { con = new SqlConnection(connString); /*For State Dropdown Load*/ string com = "select Statecode , SatateDesc from PR_location_mst (nolock)"; SqlDataAdapter adpt = new SqlDataAdapter(com, con); DataTable dt = new DataTable(); adpt.Fill(dt); DropDownState.DataSource = dt; DropDownState.DataBind(); DropDownState.DataTextField = "SatateDesc"; DropDownState.DataValueField = "Statecode"; DropDownState.DataBind(); DropDownState.Items.Insert(0, new ListItem("ALL", "0")); /*For PO Status Dropdown Load*/ string com1 = "select ast_grp_grp_cd ,ast_grp_general_name from ast_grp (nolock) order by ast_grp_general_name"; SqlDataAdapter adpt1 = new SqlDataAdapter(com1, con); DataTable dt1 = new DataTable(); adpt1.Fill(dt1); Category.DataSource = dt1; Category.DataBind(); Category.DataTextField = "ast_grp_general_name"; Category.DataValueField = "ast_grp_grp_cd"; Category.DataBind(); Category.Items.Insert(0, new ListItem("ALL", "0")); /*For PO Status Dropdown Load*/ string com2 = "select mfg_mst_mfg_cd , mfg_mst_mfg_cd as MfgDescription from mfg_mst (nolock) order by mfg_mst_mfg_cd "; SqlDataAdapter adpt2 = new SqlDataAdapter(com2, con); DataTable dt2 = new DataTable(); adpt2.Fill(dt2); Manafacturer.DataSource = dt2; Manafacturer.DataBind(); Manafacturer.DataTextField = "MfgDescription"; Manafacturer.DataValueField = "mfg_mst_mfg_cd"; Manafacturer.DataBind(); Manafacturer.Items.Insert(0, new ListItem("ALL", "0")); } catch (Exception ex) { //log error //display friendly error to user string msg = "Insert Error:"; msg += ex.Message; throw new Exception(msg); } finally { con.Close(); } } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { if (Session["name"] == null) { Session["prevUrl"] = Request.Url; Response.Redirect("~/loginPage.aspx"); } else { string username = Session["name"].ToString(); this.Label8.Text = string.Format("Hi {0}", Session["name"].ToString() + "!"); string connString = ConfigurationManager.ConnectionStrings["tomms_prodConnectionString"].ConnectionString; SqlConnection con = null; try { con = new SqlConnection(connString); /*For State Dropdown Load*/ string com = "Select RowID, ast_lvl_ast_lvl from ast_lvl (nolock)"; SqlDataAdapter adpt = new SqlDataAdapter(com, con); DataTable dt = new DataTable(); adpt.Fill(dt); DropDownState.DataSource = dt; DropDownState.DataBind(); DropDownState.DataTextField = "ast_lvl_ast_lvl"; DropDownState.DataValueField = "RowID"; DropDownState.DataBind(); DropDownState.Items.Insert(0, new ListItem("--Select--", "0")); DropDownDistrict.Items.Insert(0, new ListItem("--Select--", "0")); DropDownDocType.Items.Insert(0, new ListItem("PPM B03 & CHECKLIST", "1")); // DropDownDocType.Items.Insert(0, new ListItem("PPM CHECKLIST", "2"));//commented by muruganantham DropDownDocType.Items.Insert(0, new ListItem("--Select--", "0")); freq_DropDownList1.Items.Insert(0, new ListItem("--Select--", "0")); freq_DropDownList1.Items.Insert(1, new ListItem("1", "1")); freq_DropDownList1.Items.Insert(2, new ListItem("2", "2")); string com1 = "WITH Years(No , Year) AS ( SELECT 1, 2013 year UNION ALL SELECT No+1,year+1 FROM Years AS d where Year < Year(getdate())) SELECT No , Year FROM Years order by year desc"; SqlDataAdapter adpt1 = new SqlDataAdapter(com1, con); DataTable dt1 = new DataTable(); adpt1.Fill(dt1); DropDownYear.DataSource = dt1; DropDownYear.DataBind(); DropDownYear.DataTextField = "Year"; DropDownYear.DataValueField = "No"; DropDownYear.DataBind(); DropDownYear.Items.Insert(0, new ListItem("--Select--", "0")); } catch (Exception ex) { //log error //display friendly error to user string msg = "Insert Error:"; msg += ex.Message; throw new Exception(msg); } finally { con.Close(); } } } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { if (Session["name"] == null) { Session["prevUrl"] = Request.Url; Response.Redirect("~/loginPage.aspx"); } else { string username = Session["name"].ToString(); this.Label8.Text = string.Format("Hi {0}", Session["name"].ToString() + "!"); // Label8.Visible = false; // Label8.Text = username; string connString = ConfigurationManager.ConnectionStrings["tomms_prodConnectionString"].ConnectionString; SqlConnection con = null; try { con = new SqlConnection(connString); /*For Zone Dropdown Load*/ string com01 = "select distinct ast_loc_zone , ast_loc_zone from ast_loc (nolock)"; SqlDataAdapter adptzo = new SqlDataAdapter(com01, con); DataTable dtzo = new DataTable(); adptzo.Fill(dtzo); DropDownZone.DataSource = dtzo; DropDownZone.DataBind(); DropDownZone.DataTextField = "ast_loc_zone"; DropDownZone.DataValueField = "ast_loc_zone"; DropDownZone.DataBind(); DropDownZone.Items.Insert(0, new ListItem("ALL", "0")); /*For State Dropdown Load*/ string com = "Select RowID, ast_lvl_ast_lvl from ast_lvl (nolock)"; SqlDataAdapter adpt = new SqlDataAdapter(com, con); DataTable dt = new DataTable(); adpt.Fill(dt); DropDownState.DataSource = dt; DropDownState.DataBind(); DropDownState.DataTextField = "ast_lvl_ast_lvl"; DropDownState.DataValueField = "RowID"; DropDownState.DataBind(); DropDownState.Items.Insert(0, new ListItem("ALL", "0")); /*For District Dropdown Load*/ DropDownDistrict.Items.Insert(0, new ListItem("ALL", "0")); /*For Circle Dropdown Load*/ DropDowncircle.Items.Insert(0, new ListItem("ALL", "0")); /*For Clinic Cate Dropdown Load*/ DropDownCliniccat.Items.Insert(0, new ListItem("KESIHATAN", "1")); DropDownCliniccat.Items.Insert(0, new ListItem("PERGIGIAN", "2")); DropDownCliniccat.Items.Insert(0, new ListItem("ALL", "0")); /*For BE Category Cate Dropdown Load*/ string com4 = "select ast_grp_grp_cd , ast_grp_category from ast_grp (nolock) order by ast_grp_category "; SqlDataAdapter adpt4 = new SqlDataAdapter(com4, con); DataTable dt4 = new DataTable(); adpt4.Fill(dt4); DropDownBECate.DataSource = dt4; DropDownBECate.DataBind(); DropDownBECate.DataTextField = "ast_grp_category"; DropDownBECate.DataValueField = "ast_grp_grp_cd"; DropDownBECate.DataBind(); DropDownBECate.Items.Insert(0, new ListItem("ALL", "0")); /*For BE Category Cate Dropdown Load*/ string com5 = "select wrk_sts_status ,wrk_sts_desc from wrk_sts (nolock) where wrk_sts_disable_flag = 0"; SqlDataAdapter adpt5 = new SqlDataAdapter(com5, con); DataTable dt5 = new DataTable(); adpt5.Fill(dt5); DropDownList1.DataSource = dt5; DropDownList1.DataBind(); DropDownList1.DataTextField = "wrk_sts_desc"; DropDownList1.DataValueField = "wrk_sts_status"; DropDownList1.DataBind(); DropDownList1.Items.Insert(0, new ListItem("ALL", "0")); } catch (Exception ex) { //log error //display friendly error to user string msg = "Insert Error:"; msg += ex.Message; throw new Exception(msg); } finally { con.Close(); } } } }
protected void Page_Load(object sender, EventArgs e) { DropDownState.DataSource = states; DropDownState.DataBind(); }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { if (Session["name"] == null) { Session["prevUrl"] = Request.Url; Response.Redirect("~/loginPage.aspx"); } else { string username = Session["name"].ToString(); this.Label8.Text = string.Format("Hi {0}", Session["name"].ToString() + "!"); //Label8.Visible = false; //Label8.Text = username; string connString = ConfigurationManager.ConnectionStrings["tomms_prodConnectionString"].ConnectionString; SqlConnection con = null; try { con = new SqlConnection(connString); /*For State Dropdown Load*/ string com = "Select RowID, ast_lvl_ast_lvl from ast_lvl (nolock)"; SqlDataAdapter adpt = new SqlDataAdapter(com, con); DataTable dt = new DataTable(); adpt.Fill(dt); DropDownState.DataSource = dt; DropDownState.DataBind(); DropDownState.DataTextField = "ast_lvl_ast_lvl"; DropDownState.DataValueField = "RowID"; DropDownState.DataBind(); DropDownState.Items.Insert(0, new ListItem("ALL", "0")); /*For District Dropdown Load*/ //string com1 = "select RowID , ast_loc_ast_loc from ast_loc (nolock) where ast_loc_state = '" + DropDownState.SelectedItem.Text + "'"; // //SqlDataAdapter adpt1 = new SqlDataAdapter(com1, con); //DataTable dt1 = new DataTable(); //adpt1.Fill(dt1); //DropDownDistrict.DataSource = dt1; //DropDownDistrict.DataBind(); //DropDownDistrict.DataTextField = "ast_loc_ast_loc"; //DropDownDistrict.DataValueField = "RowID"; //DropDownDistrict.DataBind(); DropDownDistrict.Items.Insert(0, new ListItem("ALL", "0")); /*For Circle Dropdown Load*/ //string Com2 = "select RowID , ast_loc_circle from ast_loc (nolock) where ast_loc_state = '" + DropDownState.SelectedItem.Text + "' and ast_loc_ast_loc = '" + DropDownDistrict.SelectedItem.Text + "'"; // //SqlDataAdapter adpt2 = new SqlDataAdapter(Com2, con); //DataTable dt2 = new DataTable(); //adpt2.Fill(dt2); //DropDowncircle.DataSource = dt2; //DropDowncircle.DataBind(); //DropDowncircle.DataTextField = "ast_loc_circle"; //DropDowncircle.DataValueField = "RowID"; //DropDowncircle.DataBind(); DropDowncircle.Items.Insert(0, new ListItem("ALL", "0")); /*For Clinic Cate Dropdown Load*/ DropDownCliniccat.Items.Insert(0, new ListItem("KESIHATAN", "1")); DropDownCliniccat.Items.Insert(0, new ListItem("PERGIGIAN", "2")); DropDownCliniccat.Items.Insert(0, new ListItem("ALL", "0")); /*For Ownership Dropdown Load*/ DropDownOwner.Items.Insert(0, new ListItem("Existing", "1")); DropDownOwner.Items.Insert(0, new ListItem("New Biomedical", "2")); DropDownOwner.Items.Insert(0, new ListItem("Purchase Biomedical", "3")); DropDownOwner.Items.Insert(0, new ListItem("ALL", "0")); /*For BE Category Cate Dropdown Load*/ string com4 = "select ast_grp_grp_cd , ast_grp_category from ast_grp (nolock) order by ast_grp_category "; SqlDataAdapter adpt4 = new SqlDataAdapter(com4, con); DataTable dt4 = new DataTable(); adpt4.Fill(dt4); DropDownBECate.DataSource = dt4; DropDownBECate.DataBind(); DropDownBECate.DataTextField = "ast_grp_category"; DropDownBECate.DataValueField = "ast_grp_grp_cd"; DropDownBECate.DataBind(); DropDownBECate.Items.Insert(0, new ListItem("ALL", "0")); } catch (Exception ex) { //log error //display friendly error to user string msg = "Insert Error:"; msg += ex.Message; throw new Exception(msg); } finally { con.Close(); } } } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { if (Session["name"] == null) { Session["prevUrl"] = Request.Url; Response.Redirect("~/loginPage.aspx"); } else { string username = Session["name"].ToString(); this.Label8.Text = string.Format("Hi {0}", Session["name"].ToString() + "!"); //Label8.Visible = false; //Label8.Text = username; string connString = ConfigurationManager.ConnectionStrings["tomms_prodConnectionString"].ConnectionString; SqlConnection con = null; try { con = new SqlConnection(connString); string com01 = "select distinct ast_loc_zone , ast_loc_zone from ast_loc (nolock)"; SqlDataAdapter adptzo = new SqlDataAdapter(com01, con); DataTable dtzo = new DataTable(); adptzo.Fill(dtzo); DropDownZone.DataSource = dtzo; DropDownZone.DataBind(); DropDownZone.DataTextField = "ast_loc_zone"; DropDownZone.DataValueField = "ast_loc_zone"; DropDownZone.DataBind(); DropDownZone.Items.Insert(0, new ListItem("ALL", "0")); /*For State Dropdown Load*/ string com = "Select RowID, ast_lvl_ast_lvl from ast_lvl (nolock)"; SqlDataAdapter adpt = new SqlDataAdapter(com, con); DataTable dt = new DataTable(); adpt.Fill(dt); DropDownState.DataSource = dt; DropDownState.DataBind(); DropDownState.DataTextField = "ast_lvl_ast_lvl"; DropDownState.DataValueField = "RowID"; DropDownState.DataBind(); DropDownState.Items.Insert(0, new ListItem("ALL", "0")); DropDownDistrict.Items.Insert(0, new ListItem("ALL", "0")); DropDownCliniccat.Items.Insert(0, new ListItem("KESIHATAN", "1")); DropDownCliniccat.Items.Insert(0, new ListItem("PERGIGIAN", "2")); DropDownCliniccat.Items.Insert(0, new ListItem("ALL", "0")); /*For State Dropdown Load*/ string comown = "select distinct Ownership_desc as 'Ownership' , Ownership_desc from ownership_mst (nolock)"; SqlDataAdapter adptown = new SqlDataAdapter(comown, con); DataTable dtown = new DataTable(); adptown.Fill(dtown); DropDownownership.DataSource = dtown; DropDownownership.DataBind(); DropDownownership.DataTextField = "Ownership_desc"; DropDownownership.DataValueField = "Ownership"; DropDownownership.DataBind(); DropDownownership.Items.Insert(0, new ListItem("ALL", "0")); MyReportViewer.ProcessingMode = ProcessingMode.Remote; MyReportViewer.ServerReport.ReportServerUrl = new Uri("http://localhost/ReportServer"); MyReportViewer.ServerReport.ReportPath = "/TSD-Performance/TSD-USM-KPIPenalty"; MyReportViewer.ServerReport.Refresh(); } catch (Exception ex) { //log error //display friendly error to user string msg = "Insert Error:"; msg += ex.Message; throw new Exception(msg); } finally { con.Close(); } } } }