Steveluo’s Blog

Just another WordPress.com weblog

Archive for April, 2009

LINQ

Posted by steveluo on April 11, 2009

1) How to use Aggregate functions with LINQ to SQL
2) http://www.linqpad.net/
3)  Chasing Tail: C# needs Linq to be (really) functional language

4 microsoft 101 samples

5: 7 tricks to simplify your programs with LINQ | Igor Ostrovsky Blogging

Advertisements

Posted in Uncategorized | Leave a Comment »

DataTable to Excel

Posted by steveluo on April 10, 2009

1) cliperboard
   http://www.experts-exchange.com/Programming/Languages/C_Sharp/Q_23003697.html
2) CSV file
    http://gis.utah.gov/code-c-/c-convert-ado-net-datatable-to-excel-spreadsheet-3
3) interop

4)  XML
ds as new dataset
ds.tables.add(yourtable)
ds.writexml(“yourfile”)

Posted in Uncategorized | Leave a Comment »