how to update list items in share point using Windows Form Application

Question

Normal 0 false false false EN-IN X-NONE X-NONE MicrosoftInternetExplorer4 /* Style Definitions */ table.MsoNormalTable {mso-style-name:Table Normal; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-priority:99; mso-style-qformat:yes; mso-style-parent:; mso-padding-alt:0cm 5.4pt 0cm 5.4pt; mso-para-margin-top:0cm; mso-para-margin-right:0cm; mso-para-margin-bottom:10.0pt; mso-para-margin-left:0cm; line-height:115%; mso-pagination:widow-orphan; font-size:11.0pt; font-family:Calibrisans-serif; mso-ascii-font-family:Calibri; mso-ascii-theme-font:minor-latin; mso-fareast-font-family:Times New Roman; mso-fareast-theme-font:minor-fareast; mso-hansi-font-family:Calibri; mso-hansi-theme-font:minor-latin; mso-bidi-font-family:Times New Roman; mso-bidi-theme-font:minor-bidi;} How to develop a Windows Form Application in visual studio. The page should read data from the excel file using the OLEDB . If the data in the particular column in excel file matches the list item in the SharePoint site then I need to update other list items in share point site.

Muralidharan Deenathayalan · Answer

You have to sharepoint model (prior to 2010 vesion) / client object model (2010) to create the list into sharepoint list. string connString = Provider=Microsoft.Jet.OLEDB.4.0;Data Source= + FileName + ;Extended Properties=Excel 8.0; ; OleDbConnection oledbConn = new OleDbConnection(connString); oledbConn.Open(); OleDbCommand cmd = new OleDbCommand( SELECT * FROM [Sheet1$]  oledbConn); OleDbDataAdapter oleda = new OleDbDataAdapter(); oleda.SelectCommand = cmd; DataSet ds = new DataSet(); oleda.Fill(ds exceldata ); using (SPSite site = new SPSite( sharepoint site url )) { using (SPWeb web = site.OpenWeb()) { foreach (DataRow row in ds.Tables[0].Rows) { SPList list = web.Lists[ YourList ]; SPListItem Item = list.Items.Add(); item[ Title ] = row.ItemArray[0].ToString(); item[ Description ] = row.ItemArray[1].ToString() item.Update(); } } } http: //spreadsheet2splist.codeplex.com/ H ope this helps you.

how to update list items in share point , using Windows Form Application