public void State_Bind() { DropDownList_state.DataSource = bs.bs_statebind(); DropDownList_state.DataTextField = "SNAME"; DropDownList_state.DataValueField = "SID"; DropDownList_state.DataBind(); }
public void state() { DropDownList_state.DataSource = bs.bs_state(); DropDownList_state.DataTextField = "STATE"; DropDownList_state.DataValueField = "SID"; DropDownList_state.DataBind(); }
public void fillstate() { cmd.CommandText = "Select * from tblstate"; dt = da.GetRecords(cmd); DropDownList_state.DataSource = dt; DropDownList_state.DataTextField = "st_name"; DropDownList_state.DataValueField = "st_id"; DropDownList_state.DataBind(); DropDownList_state.Items.Insert(0, new ListItem("Select State", "0")); }
protected void StateBind() { SqlConnection con = new SqlConnection(str); SqlCommand cm = new SqlCommand(); cm.CommandText = "dd_state"; cm.CommandType = CommandType.StoredProcedure; cm.Connection = con; SqlDataAdapter ad = new SqlDataAdapter(cm); DataTable dt = new DataTable(); ad.Fill(dt); DropDownList_state.DataSource = dt; DropDownList_state.DataTextField = "SNAME"; DropDownList_state.DataValueField = "SID"; DropDownList_state.DataBind(); }