Dataset persistence

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi

I'm relatively new to .NET technologies and basically I need this information. We would like to persist the data returned from a database and present the user in Excel/?/Customized GUI Application in order to make him to change the data. Finally all the data updated are to committed back in Database. I know data persistence is possible using dataset but can guide some kind of examples/cod

Is it possible to present the persisted data in Excel or I have to build a customized application? Please some links/examples/samples please

I appreciate your assistance

TIA
Holy
 
You can use ComInterop to directly query a database and return the results
in Excel. Similarly, you can get data from Excel into a DataSet using
ADO.NET like this http://www.knowdotnet.com/articles/exceldatasource.html

If you have Excel 2003 you can use DataSet.WriteXML to store the contents
in XML and then open it with Excel. If you aren't using 2003, there's a
pretty good example here http://www.codeproject.com/vb/net/Data_Extract.asp


Holysmoke said:
Hi,

I'm relatively new to .NET technologies and basically I need this
Click to expand...
information. We would like to persist the data returned from a database and
present the user in Excel/?/Customized GUI Application in order to make him
to change the data. Finally all the data updated are to committed back in
Database. I know data persistence is possible using dataset but can guide
some kind of examples/code
Is it possible to present the persisted data in Excel or I have to build a
Click to expand...
customized application? Please some links/examples/samples please.
 
Back
Top