All pastes #2074795 Raw Edit

Miscellany

public text v1 · immutable
#2074795 ·published 2011-06-05 00:09 UTC
rendered paste body
<%@ Import Namespace="System.Data" %>

<SCRIPT Runat="Server">

Dim CodesArray As ArrayList

Sub Page_Load

  If Not Page.IsPostBack Then

    '-- Import XML file into data set
    Dim StateCodes = New DataSet
    StateCodes.ReadXml("StateCodes.xml")
		
   '-- Bind state names to drop-down list
    StatesList.DataSource = StateCodes
    StatesList.DataTextField = "name"
    StatesList.DataValueField = "name"
    StatesList.DataBind()

    '-- Create array of state codes
    CodesArray = New ArrayList
    Dim Row As DataRow
    For Each Row in StateCodes.Tables("state").Rows
      CodesArray.Add(Row("code"))
    Next
    ViewState("CodesArray") = CodesArray

  End If

  '-- Rebuild array of state codes
  CodesArray = New ArrayList
  CodesArray = ViewState("CodesArray")	

End Sub

Sub Get_Code (Src As Object, Args As EventArgs)
  TheCode.Text = CodesArray(StatesList.SelectedIndex)
End Sub

</SCRIPT>

<form Runat="Server">

<asp:DropDownList id="StatesList" Runat="Server"/>
<asp:Button Text="Find Code" OnClick="Get_Code" Runat="Server"/>
<asp:Label id="TheCode" Runat="Server"/>

</form>