}///===== 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();
}
}
void CLS()
{
DrpTechArea.ClearSelection();
DrpState.ClearSelection();
DrpLGA.ClearSelection();
Drpfactype.ClearSelection();
DrpFacname.ClearSelection();
TextBox1.Text = "";
DrpState.Focus();
}
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---"));
}
