what's the Difference between DataView and DataTable?
Answer Posted / ahmed yassin
DataView Object provides a window into a DataTable that can
be sorted and filtered using the Sort,RowFilter, and
RowStateFilter properties.It also contains the AllowDelete,
AllowEdit,AllowEdit, and AllowNew properties to constrain
user input as needed.
DataTable can have many DataView objects assigned to it,
allowing the data tobe viewed in many diffirent ways
without requiring the data to be reread from the database.
Example:::
DataTable customer = GetDataTable() //ur datable method
// add new datarow by adding the values
customer.Rows.Add("73OOFUFU","Mohamed","Ilyas",2533.00m);
customer.Rows.Add("3636366H","Idriis","Yassin",25545.00m);
//Sort and display
DataView view = new DataView(customer);
view.sort = "LastName ASC, FirstName ASC, Salary DESC";
GridView gv = new GridView();
gv.EnableViewState = false;
form1.Controls.Add(gv);
// assing ur gridview to dataview
gv.DataSource = veiw;
gv.DataBind();
*********************************
Sorry if there is some misspelt.
| Is This Answer Correct ? | 48 Yes | 7 No |
Post New Answer View All Answers
Explain circular reference in c#?
Do we get an error while executing the “finally” block in c#?
What is datasource c#?
what is an event? Define delegate?
Can you store strings in arrays?
What is static classes?
What is a service layer c#?
What is the difference between a method and a property?
What basic steps are needed to display a simple report in crystal?
What is inheritance in csharp?
What is difference between singleordefault and firstordefault?
Define a jagged array in c#?
What is a statement c#?
What is use of console?
What is regex replace in c#?