Get query result from DataSet

<%@ Page Language=VB Debug=true %>
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.OLEDB" %>
<script runat=server>
Sub Page_Load(ByVal Sender as Object, ByVal E as EventArgs)
    Dim DBConn as OleDbConnection
    Dim DBCommand As OleDbDataAdapter
    Dim DSPageData as New DataSet
    DBConn = New OleDbConnection( _
        "PROVIDER=Microsoft.Jet.OLEDB.4.0;" _
        & "DATA SOURCE=" _
        & Server.MapPath("EmployeeDatabase.mdb;"))
    DBCommand = New OleDbDataAdapter _
        ("Select Count(ID) as TheCount " _
        & "from Employee", DBConn)
        
    DBCommand.Fill(DSPageData, _
        "EmpCount")
    lblMessage.Text = "Total Employees: " _
        & DSPageData.Tables("EmpCount"). _
        Rows(0).Item("TheCount") 

End Sub
</SCRIPT>
<HTML>
<HEAD>
<TITLE>Values in an Access Table</TITLE>
</HEAD>
<Body LEFTMARGIN="40">
<form runat="server">
<BR><BR>
<asp:label
    id="lblMessage"
    runat="Server"
/>
</form>
</BODY>
</HTML>

EmployeeDatabase.zip( 10 k)

Related examples in the same category

1.	Loop through data in Sql Server by DataSet
2.	Loop through DataSet
3.	Load Table from DataSet
4.	Build a DataSet
5.	Create DataSet pragmatically
6.	Build a DataSet with relationship
7.	Output the content of a DataSet as XML
8.	Finding a Particular Row in a DataSet
9.	Converting XML to DataSet and Vice versa
10.	Converting XML to DataSet and Vice versa (VB)
11.	Programmatically creating a DataSet object
12.	DataSet Serialization and Deserialization using Binary Format

Get query result from DataSet : DataSet « ADO.net Database « ASP.Net

Related examples in the same category