ASP.net is killing me

**Teeeita** · Apr 24th, 2003, 01:32 PM

I am just learning asp.net and Iwant to create a connection to an access database, retrieve data and display that in my page.
I came across some tutorials, but they don't say where exactly the code should be placed. I really need step by step instructions. I have created an asp.net web application and am using a webform, where do I go from here?

Any suggestions please?

**pvb** · Apr 24th, 2003, 04:56 PM

Here's one of about a million different ways of doing that:

VB Code:

<%@ Import Namespace = "System.Data" %>
<%@ Import Namespace = "System.Data.OleDb" %>
<script runat="server" language="vb">
Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs)
    If Not Page.IsPostBack Then
        bindAuthors()
    End If
End Sub
Protected Sub bindAuthors()
    Dim mdbPath As String = "D:\AccessData\Biblio2002.mdb"
    Dim connString As String = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & mdbPath
    Dim cn As New OleDbConnection(connString)
    Dim cmdText As String = "Select Top 100 * From Authors Order By Author"
    Dim cmd As New OleDbCommand(cmdText, cn)
    cmd.Connection.Open()
    gridAuthors.DataSource = cmd.ExecuteReader(CommandBehavior.CloseConnection)
    gridAuthors.DataBind()
End Sub 
</script>
<html>
  <body>
    <form runat="server">
        <asp:DataGrid
            Runat="server"
            AutoGenerateColumns="True"
            ID="gridAuthors"/>  
    </form>
  </body>
</html>

Thread: ASP.net is killing me

Thread Tools

Display

ASP.net is killing me

Posting Permissions