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

Introduction

ASP.NET & Databases : Part 4

Published 10/26/01

Introduction

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")
objConn.Open()

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-2017 ASPAlliance.com  |  Page Processed at 2017-06-24 3:07:05 PM  AspAlliance Recent Articles RSS Feed
About ASPAlliance | Newsgroups | Advertise | Authors | Email Lists | Feedback | Link To Us | Privacy | Search