Using VB.Net and ASP.Net 1.1
Here is a VERY simple MS Access database request.
How can I get a line break between the name, address, & city fields when
they are written?
& vbCrLf _ returns an error of " End of statement expected."
<%@ Page Language="VB" %>
<%@ Import Namespace="System.Data.Oledb" %>
<script runat="server">
Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs)
Dim DBConnection As OledbConnection
DBConnection = New OledbConnection("Provider=Microsoft.Jet.Oledb.4.0; " & _
"Data Source=C:\Inetpub\wwwroot\Experiment.mdb" )
DBConnection.Open()
Dim DBCommand As OledbCommand
DBCommand = New OledbCommand("SELECT * FROM table1, Experiment")
Dim SQLString AS String
SQLString = "SELECT * FROM Table1"
DBCommand = New OleDBCommand(SQLString, DBConnection)
Dim DBReader AS OledbDatareader
DBReader = DBCommand.ExecuteReader()
While DBReader.Read()
Response.Write("Name is " & DBReader("Name"))
Response.Write(DBReader("Address1"))
Response.Write(DBReader("city"))
End While
DBReader.Close()
DBConnection.Close()
End Sub
</script>
</head>
<body>
<form id="form1" runat="server">
</form>
</body>
</html>
