SQL Select Statement

[jgaylord]

If I Select * from a Database...
How do I place the fields into TextBoxes?

Instead of selecting all should I specify each field or something? Please Explain...

 

[Dashley]

Its always better to select the fields instead of wild carding them all from a sql standpoint.

as you loop through the records

datareader(dr) for example

me.textbox1.text = dr("mycolumn1")
me.textbox2.text = dr("mycolumn2")

 

[SgtJarrow]

if you do wildcard, you can also use column index to tell which column you want:

me.textbox1.text = dr(0) 'First Column
me.textbox1.text = dr(1) 'Second Column

That can be useful if you are pulling a variable number of columns (generic code setup - looping through all columns by count - 1).

=======================================
People think it must be fun to be a super genius, but they don't realize how hard it is to put up with all the idiots in the world. (Calvin from Calvin And Hobbs)

Robert L. Johnson III
CCNA, CCDA, MCSA, CNA, Net+, A+, CHDP
VB/Access Programmer

 

[jgaylord]

Awesome! this worked Great!
Thank You SO MUCH!