RSS

Archive | c# RSS feed for this section

Compare and update XML File with the changes

30. October 2008

0 Comments

Recently I had a requirement to compare 2 XML Files, which has the existing and new settings of an application stored in them. what I wanted to do is when a new XML file of settings is arrived, I had to compare and retain the existing settings, and add any new ones if there are [...]

Continue reading...

Create Excel Sheets Programmatically with C# without Installing Excel.

25. July 2008

2 Comments

Here goes one more needy component for developers. a lot of developers always had a problem of exporting data to excel programmatically. if you Google this topic you will get many results regarding this. here are some which caught my eyes. How To Use ADO.NET to Retrieve and Modify Records in an Excel Workbook With Visual [...]

Continue reading...

Create PDF Files on the fly with C# and PDFSharp

24. July 2008

5 Comments

Recently one of my colleague asked me is there anyway to programmatically merge huge number of PDF  files in to a single file, without using Adobe Acrobat libraries, well the answer is yeah. and there are a lot of off the shelve and open source libraries available for this. the best one I found is [...]

Continue reading...

Visual Studio 2008, C# 3.0, LINQ, ASP.Net 3.5 Getting Started

18. February 2008

3 Comments

these days I’m just playing around with Visual studio 2008 and its new features, C# 3.0 LINQ, Windows Presentation Foundation, Silverlight, ASP.Net 3.5 and much more. And trust me last few months, I have received a lot of emails regarding How to’s of these and requesting resources to learn these language improvements. well may be [...]

Continue reading...

Windows Services Self Installation

26. December 2007

0 Comments

W. Kevin Hazzard had blogged a good post about how to make windows services to install them selves without using installutil.exe command which comes with the .NET framework. you can read the full article here.

Continue reading...

SQL Server 2008 Table Valued Parameters

23. December 2007

4 Comments

Last two weeks I have been working on developing bulk data manipulations. And even before that I always wondered “What’s the best way to pass an array of values into a SQL Server stored procedure.” One option I found was OPENXML, which I blogged here. And I was trying out visual studio 2008 and SQL [...]

Continue reading...

ADO.Net & OPENXML to Perform Bulk Database Operations

18. December 2007

3 Comments

Last week at my work I had to write a tool to process few hundreds of thousand email files and insert their details to the MS SQL Server 2005 database. Doing it in traditional way might require much connectivity to the database and will consume many resources. I was wondering what if I could insert [...]

Continue reading...