how to connect listbox with textbox

Question

0.00/5 (No votes)

See more:

hi , i had created a textbox and listbox , i am storing the text box values to the database table , now i need to list the textbox items in the table to the listbox using vb.net coding .

Posted 1-Dec-11 18:25pm

ANANTH P

Add a Solution

Comments

[no name] 2-Dec-11 0:30am

create a select statement that would select all textbox items in your database. Then iterate over the result and use the Add method of the ListBox control.

-Ed

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

**Manoj K Bhoir** · Answer 1 · 2011-12-01T18:36:00

It's very simple.You can do this using DataReader object
I assume that you are using Access DataBase.

VB

Dim objda As OleDbDataAdapter = New OleDbDataAdapter
Dim dr As OleDbDataReader
objda.SelectCommand = New OleDbCommand
objda.SelectCommand.Connection = Con 'Connection Object
objda.SelectCommand.CommandText = "Select FieldName FROM TableName"
        Try
            dr = objda.SelectCommand.ExecuteReader    'Exectuing query
        Catch ex As OleDb.OleDbException
            MessageBox.Show(ex.ToString)  'Providing Error Message
        End Try
        While dr.Read                     'Reading DataReader Items
            ListBox1.Items.Add(dr.Item(0))'Adding these Items Into ListBox
        End While
        dr.Close()                        'Closing DataReader Object

Add this code on Button_Click Event. :)