ASP.NET & Databases Part 4
page 1 of 5
Published: 26 Oct 2001
Unedited - Community Contributed
This part will be looking at displaying the data from a DataSet.
by . .
Average Rating: This article has not yet been rated.
Views (Total / Last 10 Days): 23162/ 42


ASP.NET & Databases : Part 4

Published 10/26/01


Welcome to another part in ASP & Databases, this time we are going to be looking at how to display our data in or on something. We're going to be using the DataSet that we got in Part 3, and for you lazy people who want to steal my code, here it is -

<%@ Page Language="VB" Debug="true" %>

<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.Oledb" %>
<script language="VB" runat="server">
Sub Page_Load(sender as object, e as eventargs)

Dim objConn as New OleDBConnection("Provider=Microsoft.Jet.OLEDB.4.0; Data Source=e:\sff\site\db\test.mdb")

Dim ds as Dataset = New DataSet()
Dim objAdapter as New OleDbDataAdapter("SELECT * FROM users", objConn)
Dim objCmdBld as New OleDbCommandBuilder(objAdapter)

objAdapter.Fill(ds, "users")

'add any more code that I show you here. Don't close Tags yet.

View Entire Article

User Comments

No comments posted yet.

Product Spotlight
Product Spotlight 

Community Advice: ASP | SQL | XML | Regular Expressions | Windows

©Copyright 1998-2024  |  Page Processed at 2024-04-23 12:09:09 AM  AspAlliance Recent Articles RSS Feed
About ASPAlliance | Newsgroups | Advertise | Authors | Email Lists | Feedback | Link To Us | Privacy | Search