}///===== End void FillstateDp() { try { string sqlstate = "Select distinct statename from tbl_state order by statename asc"; SqlConnection con = new SqlConnection(ConnectAll.ConnectMe()); con.Open(); SqlCommand cmd = new SqlCommand(sqlstate, con); SqlDataReader r = cmd.ExecuteReader(); DrpState.Items.Clear(); DrpState.Items.Add(""); drpstate2.Items.Clear(); drpstate2.Items.Add(""); while (r.Read()) { DrpState.Items.Add(r["statename"].ToString()); drpstate2.Items.Add(r["statename"].ToString()); } DrpState.DataBind(); drpstate2.DataBind(); con.Close(); r.Dispose(); } catch (Exception ex) { lblerr.Visible = true; lblerr.Text = " " + ex.Message.ToString().Trim(); } }
protected void GetState() { DataTable dt = MDC.getDataTable("select distinct State from RTO"); if (dt.Rows.Count > 0) { DrpState.DataSource = dt; DrpState.DataTextField = "State"; DrpState.DataValueField = "State"; DrpState.DataBind(); } }
public void BindState() { int CountryID; int.TryParse(DrpCountry.SelectedValue, out CountryID); DataTable dtState = HRMWcfService1.BALDropDownList.StateList(CountryID); DrpState.DataSource = dtState; DrpState.DataTextField = "StateName"; DrpState.DataValueField = "StateID"; DrpState.DataBind(); DrpState.Items.Insert(0, new ListItem("---Select State---")); }