Started the second SharePoint-related project on gotdotnet, Sharepoint data provider, with the goal ProgramUsers can use Standard dataset to operate data in SharePoint sites and use SQL-like syntaxes to conveniently obtain data.
Currently, in the pre-Alpha stage, only the data in the specified directory of the specified site list is imported to dataset, as shown in the following figure.Code:
Listdataadapter Ada = new listdataadapter ("http: // SPs", "shared document library ");
Dataset DS = Ada. Fill ();
This. datagrid1.datasource = Ds;
Dataset ds2 = Ada. Fill ("subdirectory 1/subdirectory 2 ");
This. Maid = DS2;
The effect is as follows:
The goal of this project is to use code similar to the following syntax to obtain data, and modify the data and update it back to SharePoint:
Listdataadapter Ada = new listdataadapter ("http: // SPs", "shared document library ");
Ada. selectcommandtext = "select top 10 *. doc from subdirectory 1 where (creator = 'kaneboy ') and (file size <20000) order by DESC at last modification ";
Dataset DS = Ada. Fill ();
DS. Tables ["shared document library"]. Rows [0] ["Custom Attributes"] = somedata;
Ada. Update (DS );
If you are interested, you can download the source code from workspaces. gotdotnet. com/sharepointdataprovider.