VB.NET & SQL, pasting SELECT query results to a textbox

Question

I'm building a client database system for a travel company.

They want to be able to retrieve all of their customer emails with one click, and have it appear on a textbox on the page, where they can copy it off and paste it into Outlook.

Currently, the textbox is called emailList, and is invisible until the button called emailGet is clicked.

However, I have no idea how to make the text appear into the textbox from an SQL query.

My SQL query is: SELECT CEmail FROM Clients. That's pretty much it.

In pseudocode, what I'm trying to do is:

sqlQuery = "SELECT CEmail FROM Clients"
Execute select query and store results (in a variable? or maybe directly to the textbox?)
emailList.Text = Result of sqlQuery

Thank you! :)

you need to use an sql reader for this. Check this out. SO. Next time use search function... — Alin I
– Alin I, Commented Jul 11, 2013 at 21:58

rwisch45 · Accepted Answer · 2013-07-12 01:08:11Z

1

Private Sub GetEmailAddresses() 
        Dim sText As String = String.Empty
    Dim sConnString As String = String.Empty 'Put your connection string in here

    Using cn As New OleDb.OleDbConnection(sConnString)
        cn.Open()
        Dim cmd As New OleDb.OleDbCommand("SELECT CEmail FROM Clients", cn)
        Dim r As OleDb.OleDbDataReader = cmd.ExecuteReader()

        If Not r.HasRows Then Exit Sub

        Do While r.Read()
            sText = sText & ";" & r.GetString(0)
        Loop

        cn.Close()
    End Using

    txtboxList.Text = sText
End Sub

edited Jul 12, 2013 at 1:08

answered Jul 11, 2013 at 23:46

rwisch45

3,7022 gold badges27 silver badges36 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Fares K. A. Over a year ago

Thanks for your reply! :) My connection string is PROVIDER=Microsoft.Jet.OLEDB.4.0;Data Source=|DataDirectory|AlfarisGuestsDB.mdb, and once I made sConnString = what I wrote above, it said that the keyword provider was not recognized :/ I always use that connection string and it works fine.

rwisch45 Over a year ago

What I used above was a connection for a SQL database. If you are using an Access database, then you'll want an OLEDB connection. I've modified my answer to reflect that

Fares K. A. Over a year ago

Ah, that's interesting. Learned something new today. :D Thanks a billion, my friend!

Collectives™ on Stack Overflow

VB.NET & SQL, pasting SELECT query results to a textbox

1 Answer 1

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related