How Do Access An Access Database Field Through A DataSet? RSS

• • Reply
  

  eForRealYo

  Member

  400 Points

  80 Posts

  How Do Access An Access Database Field Through A DataSet?

  Oct 20, 2003 07:16 PM|LINK

  I have the following problem. I have a query to select all the fields from a table in my database, but I am not sure how to access this information that is stored in the database. Here is my code, and where i want to insert the info from the database into the page.

  // Page Load Function
  void Page_Load(object sender, EventArgs e) {
      // Get Page Style
          System.Data.DataSet PageStyle = new System.Data.DataSet();
          PageStyle = GetStyle();
  
  
      // Navigation Setup
          // Dimension variables
          string fileName;
  
  
          // Set Variables
          fileName = this.Request.ServerVariables["SCRIPT_NAME"].Substring(this.Request.ServerVariables["SCRIPT_NAME"].LastIndexOf("/")+1);
  
  
          // Change fileName to pageName and disable link
          switch (fileName) {
              case "default.aspx":
                  PageTitle.Text = "My-V-Max.com";
                  HomeLnk.NavigateUrl = "";
  /*
  REPLACE------->    HomeLnk.ForeColor = System.Drawing.ColorTranslator.FromHtml("#E0E0E0");
  
  
  I want to replace the "#E0E0E0" value,
  with the same type of color value,
  but I want it to be dynamic and get the color value from the database,
  I already have "#E0E0E0" set as the data for the ForeColor field in the Style table in my access database.
  */
  
  
  
  
  
  
                  HomeTab.BackColor = System.Drawing.Color.Black;
                  break;
              case "stories.aspx":
                  PageTitle.Text = "My-V-Max Stories";
                  StoriesLnk.NavigateUrl = "";
                  StoriesLnk.ForeColor = System.Drawing.ColorTranslator.FromHtml("#E0E0E0");
                  StoriesTab.BackColor = System.Drawing.Color.Black;
                  break;
              case "mods.aspx":
                  PageTitle.Text = "Modifications";
                  ModsLnk.NavigateUrl = "";
                  ModsLnk.ForeColor = System.Drawing.ColorTranslator.FromHtml("#E0E0E0");
                  ModsTab.BackColor = System.Drawing.Color.Black;
                  break;
              case "photos.aspx":
                  PageTitle.Text = "Photo Album";
                  PhotoLnk.NavigateUrl = "";
                  PhotoLnk.ForeColor = System.Drawing.ColorTranslator.FromHtml("#E0E0E0");
                  PhotoTab.BackColor = System.Drawing.Color.Black;
                  break;
              case "links.aspx":
                  PageTitle.Text = "Links";
                  LinksLnk.NavigateUrl = "";
                  LinksLnk.ForeColor = System.Drawing.ColorTranslator.FromHtml("#E0E0E0");
                  LinksTab.BackColor = System.Drawing.Color.Black;
                  break;
              case "contact.aspx":
                  PageTitle.Text = "Contact";
                  ContactLnk.NavigateUrl = "";
                  ContactLnk.ForeColor = System.Drawing.ColorTranslator.FromHtml("#E0E0E0");
                  ContactTab.BackColor = System.Drawing.Color.Black;
                  break;
              default:
                  PageTitle.Text = "Unknown";
                  break;
          }
  }
  
  
  // Page Style Function
  System.Data.DataSet GetStyle() {
      string connectionString = "Provider=Microsoft.Jet.OLEDB.4.0; Ole DB Services=-4; Data Source=C:\\Documents an" +
          "d Settings\\Eric\\My Documents\\My Websites\\myVMax\\myVMaxdb.mdb";
      System.Data.IDbConnection dbConnection = new System.Data.OleDb.OleDbConnection(connectionString);
  
  
      string queryString = "SELECT [Style].* FROM [Style]";
      System.Data.IDbCommand dbCommand = new System.Data.OleDb.OleDbCommand();
      dbCommand.CommandText = queryString;
      dbCommand.Connection = dbConnection;
  
  
      System.Data.IDbDataAdapter dataAdapter = new System.Data.OleDb.OleDbDataAdapter();
      dataAdapter.SelectCommand = dbCommand;
      System.Data.DataSet dataSet = new System.Data.DataSet();
      dataAdapter.Fill(dataSet);
  
  
      return dataSet;
  }