DataTable

How to delete empty/null rows from DataTable in C#

How to delete empty/null rows from DataTable in C#

Delete null rows: Here in this article, we learn how to delete blanks rows from DataTable in C#. I was working with excel file where have to import data from an Excel sheet to database. For import have to read excel data to DataTable then save it to the database. Then I figure out that […]


by - Satinder singh

3 Ways Convert Datatable to JSON in Asp.net C#

3 Ways Convert Datatable to JSON in Asp.net C#

 Convert Datatable to JSON C#: This article explains how to convert DataTable to JSON string in Asp.net C#. i.e. serialize DataTable to JSON array in C#. For example, let’s say you have SQL database and now want to return SQL data to JSON in C# application i.e how to return JSON String from DataTable in […]


by - Satinder singh

Sorting Gridview control on header click with pagination Asp.net C#

Sorting Gridview control on header click with pagination Asp.net C#

 Overview: Asp.net sorting Gridview control  on column header click in Ascending or Descending order,  binding with DataTable Asp.net c# with pagination. In this article, I am going to give some overview on how to  SORT the data when user click on Gridview Header cell  (i.e) Sorting Gridview control in Asp.net. Also, I recommend you have a look […]


by - Satinder singh

moreLinq DistinctBy – Remove Duplicate Record From DataTable Based On Specific ColumnName

moreLinq DistinctBy – Remove Duplicate Record From DataTable Based On Specific ColumnName

 Overview: Here in this article I am going to show you how to remove duplicate records from datatable depending upon specific Column-Name. I recommend you to check my previous article (CLICK) where have written how to remove the duplicate record from DataTable without use `For loop`, `Dataview`, `Array List` and delete duplicated over looping etc and […]


by - Satinder singh

Remove Duplicate rows records from DataTable Asp.net c#

Remove Duplicate rows records from DataTable Asp.net c#

Overview: This article explains how to remove duplicate records from DataTable in C#. In SQL Server database if a table contains duplicate records then it is easy to select unique records by using DISTINCT built-in Ms-SQL function and get duplicate free rows. But when a Dot.NET c# DataTable contains duplicate records then, we have to […]


by - Satinder singh