How to access data(tables) from sql server 2000 in C#
Plz tell me...How would i do this ????
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
GrzegorzPosted Mar 31, 2006, 9:22 AM
you cannot do this directly using sql componets. All what you can do is create sql statement as "select * from tableName", execute it using SqlCommand or SqlDataAdapter and then fill DataTable object or process data you got row by row. I suppose you know that before it you have to connect with DB using SqlConnection:)
Good luck,
Grek.