ListBox

when iam searching a table field in my database with a text box i want to Show Result in a ListBox Iused Some Methods But It is Not Success

any one can help me?
:sign0085:

Sorry, but I don't understand exactly what you want to do.
What kind of data do you enter into the Textbox and what result should be displayed in the ListBox.

Best regards.

Ihave Many Fields Like Student name,address,phone,mobile etc

when iam search the student name via a textbox i want to display the search result in the listbox
can you help me?

You find attached a small program showing a solution.

Best regards.

Ya I Downloaded The Progaram But it is not cleared my dout

this is my code

Command.AddParameter("STUDENT")
Command.SetParameter("STUDENT",STUDENT.Text)

Reader.New1

Command.CommandText = "select * from studentinfo where studentname=@STUDENT"
Connection.BeginTransaction
Reader.Value = Command.ExecuteReader

Do While Reader.ReadNextRow = True
'ListboxView1.Add(Reader.GetValue(1))

Loop
Reader.Close

Connection.EndTransaction

this is My concept is this possible 'ListboxView1.Add(Reader.GetValue(1))

I thing Now You Can Help Me
:sign0085:

You should use:

ListboxView1.Clear
For i=0 to Reader.FieldCount-1
ListboxView1.Add(Reader.GetValue(i))
Next

Best regards.