ASP.Net Archives - Page 3 of 8

02/02/2015 by Nitesh

Connect Access 2007-2010 Database In C#

Friends, In this post, we will see how can we connect Access 2007-2010 database in C#. As we know Microsoft introduced new Access format from Access 2007 onwards (.accdb extension), we cannot use the default JET.OLEDB provider that we used to use before. With the new database, Microsoft also launched a new provider namely ACE.OLEDB…

03/01/2015 by Nitesh

Export Data From GridView to Excel 2007/2010 in ASP.Net

Friends, In this post, we will see how can we export data from GridView to Excel 2007/2010 format in ASP.Net in less than 5 minutes. Without much delay, let’s get started – Add EPPlus package using Nuget. Include OfficeOpenXml and OfficeOpenXml.Table namespaces at the top. In your event handler, write the below code. You’re done….

31/12/2014 by Nitesh

How To Remove Session Support from SQL Server

Friends, In this post we will see how can we remove Session State Support from SQL Server for ASP.Net applications. To completely remove the Session State support from SQL, we need to perform the following actions – Open Command Prompt Go to C:\Windows\Microsoft.Net\Framework\<Your Framework Version>\ Type aspnet_regsql -S SQLSERVER -U User -P Password -ssremove Confirm the question…

30/12/2014 by Nitesh

Generate SQL Script to Manage Session State in Custom SQL Database

Friends, ASP.Net provides 3 different ways to store sessions. They are – InProc Session Mode StateServer Session Mode SQL Server Session Mode In case you are interested to read further about sessions, you can read this excellent article by Abhijit Jana. In this post, we will see some specific details about SQL Server Session Mode….

21/10/2014 by Nitesh

How To Implement Select All/Unselect All CheckBoxes in GridView Rows

Friends, In my last posts, I explained How To Add CheckBox to GridView and How To Get Selected Multiple Rows From GridView. In this post, I will explain how can you select/unselect all rows of a GridView by selecting a CheckBox in client side. We will start with using the same GridView, we are using…