Sharepoint List to ADO.Net data table

Question

Is it possible to convert a share point list (getting it via the web service or object model) and transform it into a ADO.NET data table?

Answer 1

For Web Service Try out this Link, but it is straight Forward in the Object Model.

Answer 2

Get the list items through a SPQuery,

SPWeb web = SPContext.Current.Web;
SPSiteDataQuery query=new SPQuery();

//write your own query
// ...

//execute the query 
DataTable tbl = web.GetSiteData(query);

Now you have a ADO.NET DataTable to work on.

Answer 3

Or using the GetDataTable method in the OM:

SPWeb oWebsite = SPContext.Current.Web;
SPList oList = oWebsite.Lists["List_Name"];
SPListItemCollection collListItems = oList.Items;

DataGrid1.DataSource = collListItems.GetDataTable();
DataGrid1.DataBind();