Loading

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

aida athamnia

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 !!!!!!!!!!!!!!!!!!!!!!

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Dipa Ahuja16y ago
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 ...
0