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
Why static variables are used?
Are there functions in c#?
Why objects are stored in heap in c#?
What is desktop GUI application?
i want the csharp questions&answeres
Are all methods virtual in c#?
What is stringreader in c#?
What is the difference between delegates and superdelegates?
What is an object pool in .net?
Which is faster array or arraylist in c#?
What is the function of the not null constraint?
Is it possible to inherit multiple interfaces?
What does console readkey do in c#?
Can private virtual methods be overridden in c#.net?
How do you implement thread synchronization in c#?