How to create a DataTable and filling it with a data from the database using the DataView?

See more:

C#

Hello everybody,

I am a new ASP.NET developer and I want to create a table programmatically using HtmlTable or DataTable and then filling this table with the data from the database using DataView.

I could be able to create a table using HtmlTable but when I did a search regarding "how to fill HtmlTable with a data using DataView", I found that DataView will not work with HtmlTable. So I repeated creating the table using the DataTable, but now I need to fill it with the data using DataView, so how can I do that?

My code:

DataTable table = new DataTable();

        DataColumn col1 = new DataColumn("Name");
        DataColumn col2 = new DataColumn("Username");

        col1.DataType = System.Type.GetType("System.String");
        col2.DataType = System.Type.GetType("System.String");

        table.Columns.Add(col1);
        table.Columns.Add(col2);

        DataRow row = table.NewRow();
        row[col1] = "John";
        row[col2] = "John123";
        table.Rows.Add(row);


        GridView gv = new GridView();
        gv.DataSource = table;
        gv.DataBind();