ASP.NET Discussion

<html>
<body>
<script language="jscript" runat="server">

   function Pag_load( sender : Object, events : EventArgs )
   {
    if ( !IsPostBack )
    {
     var dataBaseConnection : OleDbConnection = new
     OleDbConnection( ConfigurationSettings.AppSettings(
     "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=C:\Documents and Settings\Philip\Mijn documenten\Stage\test2\Sportdienst 2005.mdb" ) );

     var queryString : System.String =
     "SELECT Categorienummer, Categorienaam FROM Categorie";

     dataBaseConnection.Open();

     var dataBaseCommand : OleDbCommand =
     new OleDbCommand( queryString, dataBaseConnection );

     var dataReader = dataBaseCommand.ExecuteReader();

     // while we read a row from result of
     // query, add first item to drop down list
     while ( dataReader.Read() )
     nameList.Items.Add( dataReader.GetString(0) +
     ", " + dataReader.GetString(1) );

    // close database connection
    dataBaseConnection.Close();
   }
   else
   {
    dataGrid.DataSource = GetData();
    dataGrid.DataBind();
   }
  } // end Page_load

  // Read a database and return the DataView
  function GetData() : ICollection
  {
    var set : DataSet = new DataSet();

    //establish a connection, and query the database
    var dataBaseConnection: OleDbConnection = new
    OleDbConnection( ConfigurationSettings.AppSettings(
   "ConnectionString" ) );

    var categorie : int = nameList.SelectedIndex + 1;

    var queryString : String =
    "SELECT Achternaam, Voornaam, Straat + Nr, "+
   "Postnummer, Gemeente FROM Categorie " +
   "WHERE (Categorienummer = " + categorie + ")";

    var dataBaseCommand : OleDbCommand =
    new OleDbCommand( queryString, dataBaseConnection );

    var dataAdapter : OleDbDataAdapter =
    new OleDbDataAdapter( dataBaseCommand );

    dataAdapter.Fill( set );

    // close database connection
    dataBaseCommand.Connection.Close();

    var dataView : DataView = new DataView( set.Tables[ 0 ] );
    dataView.Sort = "Title";

    return dataView;
  } // end GetData

</script>