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
Assembly Code. in Rejester AL. How do Contast Replece( or Change): Bit D3 With Bit D4 and Bit D2 With Bit D5 and Bit D1 With Bit D6 and Bit D0 With Bit D7 I am Not Know Very Well Write English.
How string definitions will prevent escaping on backslashes in C#?
What you mean by inner exception in c#?
What is the difference between dynamic and var in c#?
Are c# generics the same as c++ templates?
Is null in c#?
Explain the use of SN.exe
Which is the best language for desktop application?
What is callback function in c#?
What is a console in c#?
What is a collection in c#?
What is difference between association, aggregation and inheritance relationships?
Which namespace is required to implement trace ?
Is double a decimal?
What is using in c#?