ASP.NET Finding unique record using DataTable.DefaultView.ToTable

Introduction

Hello did you know about select distinct in SQL Server ?
This is a simple way in ASP.NET to Select Distinct data by using using DataTable.DefaultView.ToTable.
We choose "Customer" field for select distinct.
The result will look like picture below.

Step 1: Create/Get DataTable

We can use this Code to create data for this example.

C#

        DataTable dt = TestTable().DefaultView.ToTable(true, "CustomerName");
        GridView1.DataSource = TestTable();
        GridView1.DataBind();

        GridView2.DataSource = TestTable.DefaultView.ToTable(true, "CustomerName");
        GridView2.DataBind();
    

VB

        Dim dt As DataTable = TestTable.DefaultView.ToTable(True, "CustomerName")
        GridView1.DataSource = TestTable()
        GridView1.DataBind()

        GridView2.DataSource = TestTable.DefaultView.ToTable(True, "CustomerName")
        GridView2.DataBind()