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"