public void state_bind()
{
DropDown_state.DataSource = bs.bs_bind();
DropDown_state.DataTextField = "State";
DropDown_state.DataValueField = "Sid";
DropDown_state.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
DropDown_state.DataSource = bs.bs_state();
DropDown_state.DataTextField = "StateName";
DropDown_state.DataValueField = "SID";
DropDown_state.DataBind();
}
}
protected void State_Bind()
{
SqlConnection con = new SqlConnection(str);
SqlDataAdapter ad = new SqlDataAdapter("dd_state", con);
DataTable dt = new DataTable();
ad.Fill(dt);
DropDown_state.DataSource = dt;
DropDown_state.DataTextField = "SNAME";
DropDown_state.DataValueField = "SID";
DropDown_state.DataBind();
}
