Exporting Excel Sheet without getting any warning message

We find many articles in order to export the data into excel sheet.

By using the below code we can export data to excel sheet without getting any warning message when we are trying to open the file.

In order to do this we need to  Add library files of NPOI into our project. This can be added though nuget or you can directly download from the below link and refer the dll into your project.

http://npoi.codeplex.com/releases

Logging the error message into text files in the application

With the below code you can log the error messages getting in your application into text files.
By doing this we can easily trace out the issue where we are getting.

Add the below code into Web.config App settings section

<add key="LogFilePath" value="C:\RootFolder\SubFolder\Logs\LogFile"/>

Import Html Files into Data Base

Below code is used to read the html files from ftp site and import all the data into Database.

Add the below Key codes into web.config file

DropDown List Item Disable using jQuery or Java script

In this post you can learn how to disable dropDown list item using jQuery
Suppose let’s assume the dropdown contains two items as: Audi, Mercedes

Here is the JQuery code to disable list item in the dropdown using jquery

window.onload Vs Document Ready

Launching Code on Document Ready

To ensure that their code runs after the browser finishes loading the document, many JavaScript programmers wrap their code in an onload function:

Connection Pooling

When we want a front-end to communicate with backend, we need to establish connection between them.

For this:

 1. Database server has to create a socket and wait for the request to come.

2. Client will have to create a socket in its own process.

3. Client using its socket has to submit a request to server socket.

4. Sever socket should receive the request on existing client and shift’s the client to another new socket which has to be created freshly. This is done so that server main socket is free to receive request from another client(s).

Difference between IEnumerable and IQueryable

In LINQ   to query data from database and collections, we use IEnumerable and IQueryable for data manipulation. IEnumerable is inherited by IQueryable, hence it has all the features of it and except this, it has its own features. Both have their own importance to query data and data manipulation.