c# .net Adsense ADO.NET Linq Viruses/security asp.net MVC JQuery Angular-js Node-js SEO Java C++ SQL API Networking vb.net .Net Css JavaScript Generics c#.Net entity framework HTML Website host Website Construction Guide HTTP tutorial W3C tutorial Web Services JSON Psychology Ionic framework Angular ReactJS Python Computer Android
c# .net

How to convert Dataview to DataTable in c# .net?

| | ASP-NET , CSharp

A DataView allows you to store different views of data into Datatable and do data binding in applications.  We can get a datatable from a DataView which contains all rows and columns.

Syntax:

DataView Dview = new DataView();
DataTable Dtable = new DataTable();
Dtable = (DataTable)Dview.Table;

Example:

            string connetionString = null;
            SqlConnection connection;
            SqlCommand command;
            SqlDataAdapter adapter = new SqlDataAdapter();
            DataSet ds = new DataSet();
            string sql = null;
            connetionString = "Data Source=.;Initial Catalog=NorthWind;Integratedsecurity=true";
            sql = "Select firstname,lastname,HireDate fromEmployees";
            connection = new SqlConnection(connetionString);
            try
            {
                connection.Open();
                command = new SqlCommand(sql, connection);
                adapter.SelectCommand =command;
                adapter.Fill(ds, "Employees");
                adapter.Dispose();
                command.Dispose();
                connection.Close();
                DataView Dview = new DataView(ds.Tables[0]);
                DataTable Dtable = new DataTable();
                Dtable = (DataTable)Dview.Table;
                GridView1.DataSource = Dtable;
                GridView1.DataBind();
            }
            catch (Exception ex)
            {
                Console.WriteLine(ex.ToString());
           }

Here we get the employee as a datatable from the Corresponding DataView: