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 do I do implement a assert?
can you declare an override method to be static if the original method is not static?
What are custom attributes in c#?
Why is c# better than java?
What is ienumerable t in c#?
What is asp net c# corner?
What is javascriptserializer c#?
Which is the base class in c#?
What is difference between singleton and static class in c#?
Can we maintain state in webservice?
If you want to convert a base type to a derived type, what type of conversion do you use?
Explain the difference between class and interface in .net?
What is the role of the datareader class in ado.net connections?
Can you declare struct members as protected?
Differentiate between object pooling and connection pooling in c#?