How to access data(tables) from sql server 2000 in C#

Question

Plz tell me...How would i do this ????

Grzegorz · Answer

Hi 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.