Line break VB.NET

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

dancer - 07 Jul 2007 00:48 GMT

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>

Reply to this Message

Juan T. Llibre - 07 Jul 2007 01:29 GMT

You don't need the ampersand. Just use :

DBConnection = New OledbConnection("Provider=Microsoft.Jet.Oledb.4.0;" _
"Data Source=C:\Inetpub\wwwroot\Experiment.mdb" )

Juan T. Llibre, asp.net MVP
asp.net faq : http://asp.net.do/faq/
foros de asp.net, en español : http://asp.net.do/foros/
======================================

> Using VB.Net and ASP.Net 1.1
>
[quoted text clipped - 62 lines]
>
> </html>

Reply to this Message

Alexey Smirnov - 07 Jul 2007 09:19 GMT

> You don't need the ampersand. Just use :
>
[quoted text clipped - 5 lines]
> foros de asp.net, en espa?ol :http://asp.net.do/foros/
> ======================================

You need the ampersand.

Regarding line break

Response.Write("Name is " & DBReader("Name") & "<br>")
Response.Write(DBReader("Address1") & "<br>")
Response.Write(DBReader("city") & "<br>")

Reply to this Message

Juan T. Llibre - 07 Jul 2007 13:48 GMT

I must be getting lysdexic in my advanced age.

Sorry for the crossed wire.

Juan T. Llibre, asp.net MVP
asp.net faq : http://asp.net.do/faq/
foros de asp.net, en español : http://asp.net.do/foros/
======================================
On Jul 7, 2:29 am, "Juan T. Llibre" <nomailrepl...@nowhere.com> wrote:

> You don't need the ampersand. Just use :
>
[quoted text clipped - 5 lines]
> foros de asp.net, en español :http://asp.net.do/foros/
> ======================================

You need the ampersand.

Regarding line break

Response.Write("Name is " & DBReader("Name") & "<br>")
Response.Write(DBReader("Address1") & "<br>")
Response.Write(DBReader("city") & "<br>")

Reply to this Message

Alexey Smirnov - 07 Jul 2007 13:58 GMT

> I must be getting lysdexic in my advanced age.

it happens to me all the time, never mind :-)

Reply to this Message

Rate this thread:

Line break VB.NET

Free Magazines