what's the Difference between DataView and DataTable?
Answer Posted / rajesh kumar chekuri
DataTable: Represents one table in-memory
DataView:: Represents a customized view of a DataTable for
sorting, filtering, searching, editing, and navigation.
See the following example u can get Better idea...
// Create a new DataTable.
System.Data.DataTable table = new
DataTable("Customers");
// Declare variables for DataColumn and DataRow objects.
DataColumn column;
DataRow row;
// Create new DataColumn, set DataType,
// ColumnName and add to DataTable.
column = new DataColumn();
column.DataType = System.Type.GetType("System.String");
column.ColumnName = "ID";
column.ReadOnly = true;
column.Unique = true;
// Add the Column to the DataColumnCollection.
table.Columns.Add(column);
// Create second column.
// Add the column to the table.
table.Columns.Add("FirstName",
System.Type.GetType("System.String"));
// Add the column to the table.
table.Columns.Add("LastName",
System.Type.GetType("System.String"));
// Make the ID column the primary key column.
DataColumn[] PrimaryKeyColumns = new DataColumn[1];
PrimaryKeyColumns[0] = table.Columns["id"];
table.PrimaryKey = PrimaryKeyColumns;
// add new datarow by adding the values
table.Rows.Add("C101", "Rajesh", "Kumar");
table.Rows.Add("C102", "Fareed", "sk");
table.Rows.Add("C103", "Rajesh", "Raji");
//Sort and display
DataView view = new DataView(table);
view.Sort = "LastName ASC, FirstName ASC";
// assing ur gridview to dataview
GridView1.DataSource = view;
GridView1.DataBind();
| Is This Answer Correct ? | 18 Yes | 9 No |
Post New Answer View All Answers
Is c# queue thread safe?
What is the difference between list and arraylist in c#?
how to create crystal reports give one detail example(i want to view age category report) please give suitable example in my small knowledge
Which of the following operations can you not perform on an ado.net dataset?
Which attribute adorn a test class to be picked up by the NUnit GUI in the NUnit test framework?
Can interface inherit class in c#?
What are All kind of access specifiers for a class and for methods
How do you define a predicate?
Is lazy thread safe c#?
What is the use of readkey in c#?
Illustrate race condition?
What can I create with c#?
Why does dllimport not work for me?
How many types of variables are there in c#?
Why do we need a singleton class?