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(); }