Retrieving data from database

[kgenn]

Hello everyone :)

Please help me in my problem about putting the data from database (MS Access 2003) to a label. What syntax should I use?.

I used AccessDataSource for connection and Datagridview for the output..

Thanks! :D
Your help will be highly appreciated ;)

[kvprajapati]

>I used AccessDataSource for connection and Datagridview for the output..
>What syntax should I use?.

Select statement is required.

SELECT * FROM TABLENAME

[kgenn]

>I used AccessDataSource for connection and Datagridview for the output..
>What syntax should I use?.

Select statement is required.

SELECT * FROM TABLENAME

thanks for the help.

but how can I retrieve that and put in a textbox?

textbox.text = ?

[kvprajapati]

If you are not familiar with ADO.NET then please read this thread - http://www.daniweb.com/forums/thread334982.html

[kgenn]

If you are not familiar with ADO.NET then please read this thread - http://www.daniweb.com/forums/thread334982.html

thanks! :)