displaying results from database

[jlisec01]

hi there, i had just a quick question, inside the head section of my web page I have the following code:

Sub getSData(s as Object, e As EventArgs)
        Dim objConn As OleDbConnection
	Dim objCmd As OleDbCommand
	Dim objRdr As OleDbDataReader
 
        objConn = New OleDbConnection("Provider=Microsoft.Jet.OleDb.4.0;Data Source=" &server.mappath("\access_db\sysDB.mdb"))
        objCmd = New OleDbCommand("SELECT * FROM Student", objConn)
        objConn.Open()
        objRdr = objCmd.ExecuteReader()
        While objRdr.Read()
          Response.Write(objRdr.Item("Name") & "<br />")
        End While
        objRdr.Close()
        objConn.Close()
End Sub

then I have a button that calls this function, it works 100% but the results are displayed towards the top of the page, and my question is how could I get the results to display where I want on the page? for instance the middle of the page? thanks for any help.

[imaginekitty]

... it works 100% but the results are displayed towards the top of the page, and my question is how could I get the results to display where I want on the page? for instance the middle of the page? thanks for any help.

Don't use Response.Write. Assign it to the .Text value of an <asp:literal> on the page instead.

[jlisec01]

Don't use Response.Write. Assign it to the .Text value of an <asp:literal> on the page instead.

many thanks, I used the following in the script:

lblNames.Text = objRdr.Item("Name") & "<br />"

and in the body I have:

<asp:literal id="lblNames" runat="server"/>

but when I click the button to submit it, it just displays the very last name in the database, any ideals? thanks again.

[imaginekitty]

... but when I click the button to submit it, it just displays the very last name in the database, any ideals? thanks again.

You are overwriting it each time. Try this instead

lblNames.Text += objRdr.Item("Name") & "<br />"

I'm pretty sure the += works the same in VB.NET as it does in C#. If not do the old school version

lblNames.Text = lblNames.Text & objRdr.Item("Name") & "<br />"

[imaginekitty]

You should also consider a repeater or listview or one of the other databindables depending on what you're really after.

Databindables? Is that even a word? lol

[jlisec01]

lol, many thanks.