Skip to content

Tag Archives: .Net

Import Data from Excel using C# – Part 2

16-Feb-10

In my web application, we used to import data from MS Excel file. Few days before one of the client representative posted an issue that he can’t import data from XLSX (MS Excel 2007 File Format) files. Previously we were using OLE DB provider to import data from Excel file (Checkout my previous post regarding [...]

Filed in .Net, .Net 3.0 / 3.5, ASP.Net, Windows Forms | Also tagged , , , | Comments (0) »

Encrypting and Decrypting Configuration Sections

04-Feb-10

Recently I got chance to work with security audit team for my web application, and one suggestion I got from them is to encrypt connection strings section in web.config. I thought it involves lot of coding changes, and I was not aware of ASP.Net utility which will help to encrypt and decrypt the connection strings [...]

Filed in .Net, .Net 3.0 / 3.5, ASP.Net | Also tagged , | Comments (0) »

Isolated Storage in C#

03-Feb-10

As I am working in a Windows Application, client asked about the Windows 7 and Windows Vista compatibility. As I was writing only managed code I was not worried about the compatibility and most of the time it was working fine. (I was using Windows Vista). Today evening one of my colleague was testing the [...]

Filed in .Net, .Net 3.0 / 3.5, Windows Forms | Also tagged , | Comments (0) »

Writing File with Non Cache mode in C#

19-Jan-10

Normally when we are writing to the File Systems or I/O devices, Windows will cache the request or response to get better performance. This behavior is a good feature, but sometimes we require immediate change. By caching Windows sometimes mislead us. And I don’t think there is a way to avoid this option available in [...]

Filed in .Net, .Net 3.0 / 3.5 | Also tagged , , | Comments (0) »

Enumerating Instances of SQL Server using C#

18-Dec-09

One of the project I am worked, I had to enumerate SQL Server instances of the network for creating dynamic connection string. Here is a code snippet which will retrieve all the SQL Server instance in a network using C# and ADO.Net.

using System.Data;
using System.Data.Sql;

SqlDataSourceEnumerator sqlDataSourceEnumerator = SqlDataSourceEnumerator.Instance;
DataTable sqlServerInstances = sqlDataSourceEnumerator.GetDataSources();

The Data Table contains 4 columns, [...]

Filed in .Net, ASP.Net, SQL Server | Also tagged , , , | Comments (0) »