Dll til at handle al databasefunktionalitet
Jeg har lavet alt så det virker fra en dll fil med undtagelse af en reader... Det skal virke nogenlunde således, men hvordan får jeg det til det:aspx___________________________
<%@ Page Language="VB" %>
<%@ Import Namespace="AccessDatabase" %>
<script runat="server">
Function getData() As String
Dim str As String
Dim dR As System.Data.OleDb.OleDbDataReader
Dim DB As New AccessDB
DB.OpenConn("db.mdb")
dR = DB.Reader("SELECT * FROM Vare;")
If dR.Read() Then
str = "READ!"
End IF
If DB.IsError Then
str = cStr(DB.SpecError())
End IF
dR.Close
DB.CloseConn
Return str
End Function
</script>
<html>
<head>
</head>
<body>
<% getData %>
</body>
</html>
dll / vb____________________________________
Public Function Reader(sql As String) As OleDbDataReader
dbCommand = New OleDbCommand
dbCommand.CommandText = sql
dbCommand.Connection = dbConnection
Dim dR As OleDbDataReader
Try
dR = dbCommand.ExecuteReader()
Catch e As Exception
errorOccured = true
eString = e.ToString()
End Try
Return dR
End Function
