4 article(s)

• How to Export SQL Server Data to Excel in C# (Without Office Interop)

  Export SQL Server query results to Excel with ClosedXML — no Office installation, no COM Interop, safe on servers and containers, with styling and a Web API download endpoint.

  @llaxmikant · Mar 21, 2026
• Bulk Upload into SQL Server using SqlBulkCopy and C#

  Load 100,000 rows in under a second with SqlBulkCopy: column mappings, batch sizes, transactions, staging tables, and the constraint fine print — measured for real.

  @llaxmikant · Feb 28, 2026
• Compare DataTables with LINQ: Except, Intersect and Union

  To compare two ADO.NET DataTable objects, call AsEnumerable() on each to get a sequence of DataRow, then apply LINQ set operators: Except gives rows in the…

  @llaxmikant · Jan 1, 2026
• Convert a DataTable to CSV, List or JSON in .NET

  To convert an ADO.NET DataTable to CSV, a strongly-typed List<T, or a JSON string in .NET 9, iterate the table's columns and rows with a StringBuilder for…

  @llaxmikant · Nov 19, 2025