Displaying Output

Fakhruddin Zavery · Feb 28, 2004

Hello,

Is it possible to display output from a simple select statement e.g select *
from employee and display it on your apsx page in text boxes or label
fields?

I have seen it that you can display one particular field e.g select phone
from employee where firstname =@firstname.

I can assign that phone output to a particular textbox or label on my page
but what if i wanted other fields to go in other appropriate boxes or
labels?

Thanks In Advance

--
Fakhruddin Zavery
Sr. Systems Analyst / Programmer
CATS Tanzania Ltd.
NIC Life House 4th Floor
P. O. Box 2569, Dar es Salaam, Tanzania
Tel. +255-22 2137915, 2112631
Fax +255-22 2113033, 2112916
Mob +255 744 277452
website: http://www.catsgroup.com

Cor · Feb 28, 2004

Hi Fakhruddin,

Have for that a look at the SQLdatareader

http://msdn.microsoft.com/library/d...ystemdatasqlclientsqldatareaderclasstopic.asp

Your where clause is right.

For that you need the command.parameters

http://msdn.microsoft.com/library/d.../vbtsksettinggettingdatacommandparameters.asp

I hope this helps?

Cor