How to List All Tables and Their Rowcount in SQL Server

Hi friends,in this article I will explain about How to List All Tables and Their Rowcount in SQL Server.
I already explained in the previous articles about How to Backup All Databases in SQL Server, How to get Distinct Count across Multiple Tables in SQL Server and How to Remove/Delete duplicate records/Rows from a table in SQL Server

How to display SubTotal and Grand Total in ASP.Net GridView using C#/VB.NET

Hi friends,in this article i will explain about How to display SubTotal and Grand Total in ASP.Net GridView using c#/VB.NET.

I already explained in the previous articles about How to Edit GridView using BoundField Column in ASP.Net using C#/VB.NET, Code First Approach using Entity Framework 4.0 Sample example and How to create PDF document in ASP.NET with C#/VB.NET using iTextSharp

The records are divided into Groups and then SubTotal is calculated for each Group and then displayed using a dynamic Row in GridView.

How to Edit GridView using BoundField Column in ASP.Net using C#/VB.NET

Hi friends,in this article I will explain about How to Edit GridView using BoundField Column in ASP.Net using C#/VB.NET.
I already explained in the previous articles about Code First Approach using Entity Framework 4.0 Sample example, How to create PDF document in ASP.NET with C#/VB.NET using iTextSharp and Telerik RadGrid Grouping -Drag and Drop a column header to group by that column in ASP.NET using C#/VB.NET

When the GridView Row enters Edit Mode, the BoundField column gets converted to a TextBox dynamically to allow user modify the values.

Code First Approach using Entity Framework 4.0 Sample example using ASP.NET,C#.NET

Hi friends,in this article I will explain about Entity Framework Code First example  using ASP.NET,C#.NET.
I already explained in the previous articles about Telerik RadGrid Grouping -Drag and Drop a column header to group by that column in ASP.NET using C#/VB.NET, How to show validation control's Error messages in Alert box in ASP.NET and How to Upload Multiple Files Using FileUpload Control in ASP.NET using C#/VB.NET

How to Backup All Databases in SQL Server

Hi friends,in this article I will explain about How to Backup All Databases in SQL Server.

Below  is a SQL script to get all Databases Backup in specified folder.
Backup file name will be like "DataBaseName_{Date}-{Month}-{Year}.bak"

How to create PDF document in ASP.NET with C#/VB.NET using iTextSharp

Hi friends,in this article I will explain about How to create PDF document in ASP.NET with C#/VB.NET using iTextSharp.

What is iTextSharp:

iTextSharpopen source Java library for PDF generation and manipulation. It can be used to create PDF documents from scratch, to convert XML to PDF (using the extra XFA Worker DLL), to fill out interactive PDF forms, to stamp new content on existing PDF documents, to split and merge existing PDF documents, and much more.

          Here I’m going to explain how to create PDF document in ASP.NET using iTextSharp. First we have to download iTextSharp.dll class library and include to our project.