How to fetch and append a data from the database??

[azwandy]

Hi everyone..! I need a little bit of help here.. Right now I'm developing a Web service. This Web service is called DMS (Desktop Management System) Web service. Now, this web service needs to access an Access database and fetch a data from the database. What I need to know is, is there any way that the data can be append into a variable. The variable will be used to pass to a function in a separate program called DMS Windows application. I will be all grateful if anyone can help me on this problem. Thank you.

[jmcilhinney]

I'm not experienced at all with Web Services but I believe that they carry DataSets. Now, a DataSet is a DataSet, whether it has been carried by a Web Service or not, which is exactly the point. The same type of object gets used regardless of the situation. A dataSet contains DataTables, a DataTable contains DataRows and a DataRow contains values. You can get those values and do whatever you want with them, whether there was a Web Service involved or not.