DataView is special table view which allows you to traverse through rows and columns respectively. C# DataView is an offline data holder as DataSet.
What you need is
- A Database connection object
- A Data Adapter which configures the data table using SQL query.
- And a dataset which holds the table information.
Create a data view object and initialize it with the dataset tables name as follows
SqlDataAdapter AccountRegistration = new SqlDataAdapter(“select * from accountregistration order by grpid”, Common.con);
DataSet AccountRegistrationDataset=new DataSet();
DataView AccountRegistrationTableView = new DataView(AccountRegistrationDataset.Tables);
Learn about more DatView operations