Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 404
  • Last Modified:

ASP.net print results of database SQL statement

Hi

I am using the code shown in the code section below to get all the records
from a table in a database held online. How do I print my results on the webpage?
Do I use "Response"
Protected Sub Button1_Click(ByVal sender As Object, ByVal e As EventArgs) Handles Button1.Click


        '// define a connection to the database
        Dim cn As New OleDbConnection(ConfigurationManager.ConnectionStrings("WhatEverNameYouWant").ConnectionString)

        '// define the sql statement to execute
        Dim cmd As New OleDbCommand("SELECT * FROM [Contacts]", cn)

        Try

            '// open the connection
            cn.Open()

            '// execute the sql statement
            Using reader As OleDbDataReader = cmd.ExecuteReader(CommandBehavior.CloseConnection)

                While reader.Read()
                    '// this loops through all of the returned records
                End While

            End Using

        Catch ex As Exception
            Response.Write(ex.Message)
        Finally
            If cn.State <> ConnectionState.Closed Then
                cn.Close()
            End If
        End Try


    End Sub

Open in new window

0
Murray Brown
Asked:
Murray Brown
  • 4
  • 3
  • 2
  • +1
1 Solution
 
meispiscesCommented:
"Print results on webpage".You mean to print the results only or the entire webpage with results. Please explain what you wish to do so in detail..

Thanks
0
 
Paul MacDonaldDirector, Information SystemsCommented:
One way would be to issue
  RESPONSE.WRITE(whatever)
inside your loop.  That will give you a page full of whatever is coming out of the database.  It won't be formatted in any particular way, but you'll be able to read it.

Just for testing, you might try
 RESPONSE.WRITE(whatever & "<br />")
so each item out of the database is on its own line in the page.
0
 
Murray BrownMicrosoft Cloud Azure/Excel Solution DeveloperAuthor Commented:
Thanks but how do I write each record. What do I put where you have put "whatever"
0
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
Carl TawnSystems and Integration DeveloperCommented:
Just dumping everything using Response.Write is how you would do things in Classic ASP, we've moved on bit since then :)

The quickest way to get your data up on screen would be to bind it to a GridView. Drop a GridView onto your page from the Toolbox. Then replace these lines:

                While reader.Read()
                    '// this loops through all of the returned records
                End While

Open in new window

With:
GridView1.DataSource = reader
GridView1.DataBind()

Open in new window

0
 
Murray BrownMicrosoft Cloud Azure/Excel Solution DeveloperAuthor Commented:
Thanks but how do I write each record in each response?
0
 
Paul MacDonaldDirector, Information SystemsCommented:
...
   While reader.Read()
      Response.Write(reader("column_name") & "<br />")
   End While
...

As both [carl_tawn] and I note, this is a quick and dirty method.  It will give you what you asked for, but it won't be formatted (look nice).
0
 
Carl TawnSystems and Integration DeveloperCommented:
If you are just starting out with ASP.Net then it will really be worth your while going through the samples here:
 
    http://www.asp.net

It will teach you the basics of working with data, binding to controls and the types of data presentation controls available.
0
 
Murray BrownMicrosoft Cloud Azure/Excel Solution DeveloperAuthor Commented:
Thanks very much. Sorry for late reply
0
 
Murray BrownMicrosoft Cloud Azure/Excel Solution DeveloperAuthor Commented:
Thanks carl_tawn. I just hosted my first online Access darabase> Really appreciate all your help and patience. Murray
0
 
Carl TawnSystems and Integration DeveloperCommented:
No problem. Glad you got there in the end :)
0

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

  • 4
  • 3
  • 2
  • +1
Tackle projects and never again get stuck behind a technical roadblock.
Join Now