question

Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic

   hy everyone,

i've connect to a database with asp. whit the info i take from it i'm trying 2 make a drop down menu. problem is that my drop down menu is empty

i'll put in my cod if any one can see what's wrong please tell me

<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>
<form runat="server">
 <Header:ImageHeader id = "head" runat = "server">
 </Header:ImageHeader>
 <br />

 Authors:
 <asp:DropDownList ID="nameList" runat="server" 
  Width="158px" Height="22px">
 </asp:DropDownList>
 <asp:Button ID="button" Text="select" runat="server">
 </asp:Button>
 <p>
  <asp:DataGrid ID="dataGrid" runat="server">
  </asp:DataGrid>
 </p>

 </form>
 </body>
</html>