Monday, July 14, 2008

Convert DataTable to DataView in C# in VS 2008

The following sample will demonstrate the convertion from DataTable to DataView in C# in VS 2008.

In VS 2008, DataView having one method which accept datatable as input parameter and it return the converted result as dataview by using DataView().

// Create dynamic data table.
var dataTable = new DataTable();


// Create columns
dataTable.Columns.Add("FirstName");
dataTable.Columns.Add("LastName");
dataTable.Columns.Add("Salary");


var dataRow = dataTable.NewRow();
dataRow[0] = "Kannan";
dataRow[1] = "Arjun";
dataRow[2] = 1000;



// Add new Datarow to data table.
dataTable.Rows.Add(dataRow);



dataRow = dataTable.NewRow();
dataRow[0] = "Seema";
dataRow[1] = "Sekar";
dataRow[2] = 4000;



// Add new Datarow to data table.
dataTable.Rows.Add(dataRow);



// Convert data table to dataview.
var dataView = new DataView(dataTable);
// Now ready to use this dataview.



Happy coding!!!