see a list of customers located in the customer table in my database (SQL server) using C #

Question

Hi Hi My problem is that I want to see a list of customers located in the customer table in my database (SQL server) using C # in my code I made first a connection to my database then I used the query select * from customer but then I did not know what to do ???? knowing that my project is the development of a WCF layer that contains a customer service in which I need to display the list of customers. PLEASE HELP ME !!!!!!!!!!!!!!!!!!!!!!

Dipa Ahuja · Answer

you can use the DataAdapter and dataset.. and using the DataAdapter's fill method you can load data in dataset.. Ex: SqlDataAdapter da; DataSet ds; da = new SqlDataAdapter(Select * from Table1 ); ds = new DataSet(); da.Fill(ds); now you can use the dataset object as datasource to display data ...