Basically, I'm creating a very simple program that creates an Excel table from information put into the program. I've got a class set up for each set of data (essentially what will become the table's rows) and the variables in the class will be the columns. The data is collected and placed in a List<> of the class. All I need to figure out how to do now, is create the excel table. I've read a lot about SQL ADO.NET, but I'm too sure I fully understand the entire process. After reading
http://davidhayden.com/blog/dave/archive/2...05/26/2973.aspx and
http://www.csharp-station.com/Tutorials/Ad...t/Lesson01.aspx I still don't know how exactly this can be done. I've come to the conclusion that I need an OleDB dataset and data adapter. Where I get stuck is the command I need to put into the data adapter.
Could someone point me in the direction of a tutorial, or explain right here, what kind of command string I need to input into the Data Adapter to create and then add rows to this table?
30 Jun, 2008 - 11:32 AM
|