Dataview example

using System;

using System.Collections;

using System.Configuration;

using System.Data;

using System.Linq;

using System.Web;

using System.Web.Security;

using System.Web.UI;

using System.Web.UI.HtmlControls;

using System.Web.UI.WebControls;

using System.Web.UI.WebControls.WebParts;

using System.Xml.Linq;

public partial class dataviewsample : System.Web.UI.Page

{

protected void Page_Load(object sender, EventArgs e)

{

}

protected void Button1_Click(object sender, EventArgs e)

{

DataTable dt = new DataTable();

dt.TableName = "Books";

DataColumn dc1 = new DataColumn();

dc1.ColumnName = "BookID";

dc1.DataType = typeof(int);

dc1.AllowDBNull = false;

dc1.Unique = true;

DataColumn dc2 = new DataColumn();

dc2.ColumnName = "Category";

dc2.DataType = typeof(string);

DataColumn dc3 = new DataColumn();

dc3.ColumnName = "BookName";

dc3.DataType = typeof(string);

DataColumn dc4 = new DataColumn();

dc4.ColumnName = "Author";

dc4.DataType = typeof(string);

dt.Columns.AddRange(new DataColumn[] { dc1, dc2, dc3, dc4 });

dt.Rows.Add(new object[] { 1, "iPhone", "iPhone User Interface Cookbook: RAW", "Cameron Banga" });

dt.Rows.Add(new object[] { 2, "MySQL", "MySQL 5.1 Plugin Development", "Andrew Hutchings, Sergei Golubchik" });

dt.Rows.Add(new object[] { 3, "MySQL", "MySQL Admin Cookbook", "Daniel Schneller, Udo Schwedt" });

dt.Rows.Add(new object[] { 4, "Asp.net", "Asp.net Admin Cookbook", "Daniel Schneller, Udo Schwedt" });

dt.Rows.Add(new object[] { 5, "C#.net", "C#.net Admin Cookbook", "Daniel Schneller, Udo Schwedt" });

dt.Rows.Add(new object[] { 6, "Asp.net", "WCF Admin Cookbook", "Daniel Schneller, Udo Schwedt" });

dt.AcceptChanges();

Label1.Text = "Source DataTable";

GridView1.DataSource = dt.DefaultView;

GridView1.DataBind();

//this line create a new DataView

DataView dView = new DataView(dt);

dView.RowFilter = "Category = 'MySQL'";

Label2.Text = "Here we create a new DataView
" +

"and set the RowFilter (Category = 'MySQL')";

GridView2.DataSource = dView;

GridView2.DataBind();

//this line create a new DataView

DataTable dt2 = dView.ToTable();

dView.RowFilter = "Category = 'Asp.net'";

Label3.Text = "Here we create a new DataTable from DataView";

GridView3.DataSource = dView;

GridView3.DataBind();

//this line create a new DataTable from DataView

DataTable dt2 = dView.ToTable();

Label3.Text = "Here we create a new DataTable from DataView";

GridView4.DataSource = dt2;

GridView4.DataBind();

}

}

.....................................

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="dataviewsample.aspx.cs" Inherits="dataviewsample" %>

How to use DataView ToTable method

to create a new DataTable in ado.net

---