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
How does a while loop work?
How do I use the 'using' keyword with multiple objects?
Do events have return type c#?
Can we extend sealed class in c#?
How to find the current application file path while runtime?
Give some examples of commonly used i/o classes?
What is the use of return in c#?
How can i Spawn a Thread
We cannot create instances of static classes. Can we have constructors for static classes?
What is a private method in c#?
List some of the classes used by system.data namespace?
What is the meaning of 0 in c#?
What is the difference between internal and private in c#?
Can we extend static class in c#?
How do we achieve encapsulation in c#?