{"id":154,"date":"2016-11-13T04:27:09","date_gmt":"2016-11-13T04:27:09","guid":{"rendered":"http:\/\/www.softwaretraininginchennai.com\/blog\/?p=154"},"modified":"2017-02-10T03:02:11","modified_gmt":"2017-02-10T03:02:11","slug":"crud-operation-with-sharepoint-list-in-visual-web-part","status":"publish","type":"post","link":"https:\/\/www.softwaretraininginchennai.com\/blog\/crud-operation-with-sharepoint-list-in-visual-web-part\/","title":{"rendered":"CRUD operation with SharePoint List in Visual web part"},"content":{"rendered":"<div style=\"color: #000;\">\n<h2><span style=\"color: #2e75b5; font-family: Calibri; font-size: 14pt;\">Document by Ganesan &#8211; Ganesanva@hotmail.com &#8211; + 919600370429<br \/>\n<\/span><\/h2>\n<ul>\n<li>\n<div>Create <strong>EmployeeList<\/strong> in Sharepoint 2010 site with the below Columns.<\/div>\n<p><strong>EmployeeName<\/strong>, <strong>Age<\/strong><\/li>\n<\/ul>\n<p><img decoding=\"async\" src=\"http:\/\/www.softwaretraininginchennai.com\/blog\/wp-content\/uploads\/2016\/11\/111316_0426_CRUDoperati1.png\" alt=\"\" \/><\/p>\n<ul>\n<li>Create a new Visual Web part Project using File &#8211;&gt;New Project<\/li>\n<\/ul>\n<p><img decoding=\"async\" src=\"http:\/\/www.softwaretraininginchennai.com\/blog\/wp-content\/uploads\/2016\/11\/111316_0426_CRUDoperati2.png\" alt=\"\" \/><br \/>\nClick Ok.<br \/>\nThe Solution Explorer will looks as below,<br \/>\n<img decoding=\"async\" src=\"http:\/\/www.softwaretraininginchennai.com\/blog\/wp-content\/uploads\/2016\/11\/111316_0426_CRUDoperati3.png\" alt=\"\" \/><br \/>\nIn VisualWebPart1UserControl.ascx Put the below code snippet,<\/p>\n<div>\n<table style=\"border-collapse: collapse;\" border=\"0\">\n<colgroup>\n<col style=\"width: 576px;\" \/><\/colgroup>\n<tbody valign=\"top\">\n<tr>\n<td style=\"border: solid #a3a3a3 1.0pt; padding: 2px; color: #000;\"><b>&lt;table border=&#8221;0&#8243; cellpadding=&#8221;2&#8243; cellspacing=&#8221;2&#8243;&gt;<br \/>\n&lt;tr&gt;<br \/>\n&lt;td colspan=&#8221;2&#8243; style=&#8221;color:Green&#8221;&gt;<br \/>\n&lt;asp:Label ID=&#8221;lblresults&#8221; runat=&#8221;server&#8221;&gt;&lt;\/asp:Label&gt;<br \/>\n&lt;\/td&gt;<br \/>\n&lt;\/tr&gt;<br \/>\n&lt;tr&gt;<br \/>\n&lt;td&gt;<br \/>\nEmployee Name<br \/>\n&lt;\/td&gt;<br \/>\n&lt;td&gt;<br \/>\n&lt;asp:TextBox ID=&#8221;txtEmployeeName&#8221; runat=&#8221;server&#8221;&gt;&lt;\/asp:TextBox&gt;<br \/>\n&lt;\/td&gt;<br \/>\n&lt;\/tr&gt;<br \/>\n&lt;tr&gt;<br \/>\n&lt;td&gt;<br \/>\nAge<br \/>\n&lt;\/td&gt;<br \/>\n&lt;td&gt;<br \/>\n&lt;asp:TextBox ID=&#8221;txtAge&#8221; runat=&#8221;server&#8221;&gt;&lt;\/asp:TextBox&gt;<br \/>\n&lt;\/td&gt;<br \/>\n&lt;\/tr&gt;<br \/>\n&lt;tr&gt;<br \/>\n&lt;td&gt;<br \/>\n&lt;\/td&gt;<br \/>\n&lt;td&gt;<br \/>\n&lt;asp:Button ID=&#8221;btnSave&#8221; runat=&#8221;server&#8221; Text=&#8221;Save&#8221; OnClick=&#8221;btnSave_Click&#8221; \/&gt;<br \/>\n&lt;asp:Button ID=&#8221;btnUpdate&#8221; runat=&#8221;server&#8221; Text=&#8221;Update&#8221;<br \/>\nonclick=&#8221;btnUpdate_Click&#8221; \/&gt;<br \/>\n&lt;asp:HiddenField ID=&#8221;hfId&#8221; runat=&#8221;server&#8221; \/&gt;<br \/>\n&lt;asp:Button ID=&#8221;btnClear&#8221; runat=&#8221;server&#8221; Text=&#8221;Clear&#8221;<br \/>\nonclick=&#8221;btnClear_Click&#8221; \/&gt;<br \/>\n&lt;\/td&gt;<br \/>\n&lt;\/tr&gt;<br \/>\n&lt;tr&gt;<br \/>\n&lt;td colspan=&#8221;2&#8243;&gt;<br \/>\n&lt;asp:GridView ID=&#8221;grvEmployeeDetails&#8221; runat=&#8221;server&#8221; AutoGenerateColumns=&#8221;false&#8221;&gt;<br \/>\n&lt;Columns&gt;<br \/>\n&lt;asp:BoundField DataField=&#8221;ID&#8221; HeaderText=&#8221;ID&#8221; \/&gt;<br \/>\n&lt;asp:BoundField DataField=&#8221;EmployeeName&#8221; HeaderText=&#8221;Employee Name&#8221; \/&gt;<br \/>\n&lt;asp:BoundField DataField=&#8221;Age&#8221; HeaderText=&#8221;Age&#8221; \/&gt;<br \/>\n&lt;asp:TemplateField&gt;<br \/>\n&lt;ItemTemplate&gt;<br \/>\n&lt;asp:Button ID=&#8221;btnEdit&#8221; runat=&#8221;server&#8221; Text=&#8221;Edit&#8221; onclick=&#8221;btnEdit_Click&#8221; \/&gt;<br \/>\n&lt;\/ItemTemplate&gt;<br \/>\n&lt;\/asp:TemplateField&gt;<br \/>\n&lt;\/Columns&gt;<br \/>\n&lt;\/asp:GridView&gt;<br \/>\n&lt;\/td&gt;<br \/>\n&lt;\/tr&gt;<br \/>\n&lt;\/table&gt;<\/b><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<p><img decoding=\"async\" src=\"http:\/\/www.softwaretraininginchennai.com\/blog\/wp-content\/uploads\/2016\/11\/111316_0426_CRUDoperati4.png\" alt=\"\" \/><br \/>\nIn VisualWebPart1UserControl.ascx.cs put\/Replace the below code snippet,<\/p>\n<div>\n<table style=\"border-collapse: collapse;\" border=\"0\">\n<colgroup>\n<col style=\"width: 537px;\" \/><\/colgroup>\n<tbody valign=\"top\">\n<tr>\n<td style=\"border: solid #a3a3a3 1.0pt; padding: 2px; color: #000;\"><b>public partial class VisualWebPart1UserControl : UserControl<br \/>\n{<br \/>\nprotected void Page_Load(object sender, EventArgs e)<br \/>\n{<br \/>\nif (!Page.IsPostBack)<br \/>\n{<br \/>\nBindGrid();<br \/>\nbtnSave.Visible = true;<br \/>\nbtnUpdate.Visible = false;<br \/>\n}<br \/>\n}<br \/>\nprivate void BindGrid()<br \/>\n{<br \/>\nusing (SPSite site = new SPSite(SPContext.Current.Site.Url)) \/\/ Site Collection<br \/>\n{<br \/>\nusing (SPWeb web = site.OpenWeb()) \/\/ Site<br \/>\n{<br \/>\nSPList list = web.Lists[&#8220;EmployeeList&#8221;]; \/\/ List<br \/>\nSPQuery curQry = new SPQuery();<br \/>\ncurQry.Query = &#8220;&#8221;;<br \/>\n\/\/Get the Items using Query<br \/>\nSPListItemCollection olistitemcollection = list.GetItems(curQry);<br \/>\nDataTable dt = olistitemcollection.GetDataTable();<br \/>\ngrvEmployeeDetails.DataSource = dt;<br \/>\ngrvEmployeeDetails.DataBind();<br \/>\n}<br \/>\n}<br \/>\n}<br \/>\nprotected void btnSave_Click(object sender, EventArgs e)<br \/>\n{<br \/>\nusing (SPSite site = new SPSite(SPContext.Current.Site.Url)) \/\/ Site Collection<br \/>\n{<br \/>\nusing (SPWeb web = site.OpenWeb()) \/\/ Site<br \/>\n{<br \/>\nSPList list = web.Lists[&#8220;EmployeeList&#8221;]; \/\/ List<br \/>\nSPListItem oListItem = list.Items.Add();<br \/>\noListItem[&#8220;Title&#8221;] = txtEmployeeName.Text;<br \/>\noListItem[&#8220;EmployeeName&#8221;] = txtEmployeeName.Text;<br \/>\noListItem[&#8220;Age&#8221;] = txtAge.Text;<br \/>\noListItem.Update();<br \/>\nBindGrid();<br \/>\nlblresults.Text = &#8220;Saved Successfully&#8221;;<br \/>\n}<br \/>\n}<br \/>\n}<br \/>\nprotected void btnEdit_Click(object sender, EventArgs e)<br \/>\n{<br \/>\nButton btn = (Button)sender;<br \/>\n\/\/Get the row that contains this button<br \/>\nGridViewRow gvr = (GridViewRow)btn.NamingContainer;<br \/>\nhfId.Value = gvr.Cells[0].Text;<br \/>\ntxtEmployeeName.Text = gvr.Cells[1].Text;<br \/>\ntxtAge.Text = gvr.Cells[2].Text;<br \/>\nbtnSave.Visible = false;<br \/>\nbtnUpdate.Visible = true;<br \/>\n}<br \/>\nprotected void btnUpdate_Click(object sender, EventArgs e)<br \/>\n{<br \/>\nusing (SPSite site = new SPSite(SPContext.Current.Site.Url)) \/\/ Site Collection<br \/>\n{<br \/>\nusing (SPWeb web = site.OpenWeb()) \/\/ Site<br \/>\n{<br \/>\nSPList list = web.Lists[&#8220;EmployeeList&#8221;]; \/\/ List<br \/>\nSPListItem oListItem = list.Items.GetItemById(Convert.ToInt32(hfId.Value));<br \/>\noListItem[&#8220;Title&#8221;] = txtEmployeeName.Text;<br \/>\noListItem[&#8220;EmployeeName&#8221;] = txtEmployeeName.Text;<br \/>\noListItem[&#8220;Age&#8221;] = txtAge.Text;<br \/>\noListItem.Update();<br \/>\nBindGrid();<br \/>\nlblresults.Text = &#8220;Updated Successfully&#8221;;<br \/>\n}<br \/>\n}<br \/>\n}<br \/>\nprotected void btnClear_Click(object sender, EventArgs e)<br \/>\n{<br \/>\ntxtEmployeeName.Text = string.Empty;<br \/>\ntxtAge.Text = string.Empty;<br \/>\nhfId.Value = string.Empty;<br \/>\nlblresults.Text = string.Empty;<br \/>\nbtnSave.Visible = true;<br \/>\nbtnUpdate.Visible = false;<br \/>\n}<br \/>\n}<\/b><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<p><img decoding=\"async\" src=\"http:\/\/www.softwaretraininginchennai.com\/blog\/wp-content\/uploads\/2016\/11\/111316_0426_CRUDoperati5.png\" alt=\"\" \/><br \/>\nRight click on the Project and Click <strong>Deploy<\/strong>.<br \/>\nGo to Home Page and Click on Site Actions &#8211;&gt;Edit Page<br \/>\nInsert &#8211;&gt;Web part in Ribbon.<br \/>\n<img decoding=\"async\" src=\"http:\/\/www.softwaretraininginchennai.com\/blog\/wp-content\/uploads\/2016\/11\/111316_0426_CRUDoperati6.png\" alt=\"\" \/><br \/>\nSelect the Web part and click Add.<br \/>\n<img decoding=\"async\" src=\"http:\/\/www.softwaretraininginchennai.com\/blog\/wp-content\/uploads\/2016\/11\/111316_0426_CRUDoperati7.png\" alt=\"\" \/><br \/>\nThe Output as below,<br \/>\n<img decoding=\"async\" src=\"http:\/\/www.softwaretraininginchennai.com\/blog\/wp-content\/uploads\/2016\/11\/111316_0426_CRUDoperati8.png\" alt=\"\" \/><br \/>\n<img decoding=\"async\" src=\"http:\/\/www.softwaretraininginchennai.com\/blog\/wp-content\/uploads\/2016\/11\/111316_0426_CRUDoperati9.png\" alt=\"\" \/><br \/>\n<img decoding=\"async\" src=\"http:\/\/www.softwaretraininginchennai.com\/blog\/wp-content\/uploads\/2016\/11\/111316_0426_CRUDoperati10.png\" alt=\"\" \/><br \/>\n<img decoding=\"async\" src=\"http:\/\/www.softwaretraininginchennai.com\/blog\/wp-content\/uploads\/2016\/11\/111316_0426_CRUDoperati11.png\" alt=\"\" \/><br \/>\nClick below to download the solution,<br \/>\n<a href=\"https:\/\/1drv.ms\/u\/s!ArddhCoxftkQg6l3ED81o25f4nzffg\">https:\/\/1drv.ms\/u\/s!ArddhCoxftkQg6l3ED81o25f4nzffg<\/a><\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>Document by Ganesan &#8211; Ganesanva@hotmail.com &#8211; + 919600370429 Create EmployeeList in Sharepoint 2010 site with the below Columns. EmployeeName, Age Create a new Visual Web part Project using File &#8211;&gt;New Project Click Ok. The Solution Explorer will looks as below, In VisualWebPart1UserControl.ascx Put the below code snippet, &lt;table border=&#8221;0&#8243; cellpadding=&#8221;2&#8243; cellspacing=&#8221;2&#8243;&gt; &lt;tr&gt; &lt;td colspan=&#8221;2&#8243; style=&#8221;color:Green&#8221;&gt; [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[8,1],"tags":[63,73,127,131,132,134,135,139,148],"class_list":["post-154","post","type-post","status-publish","format-standard","hentry","category-sharepoint-freelancers-in-chennai","category-uncategorized","tag-download-visual-webpart-sample","tag-freelance-sharepoint-developer","tag-server-object-model-example","tag-share-point-freelancing-in-chennai","tag-share-point-part-time-consultants-in-chennai","tag-sharepoint-2010-crud-operation-in-visual-studio","tag-sharepoint-list-crud-operation","tag-sharepoint-training-in-chennai","tag-visual-webpart-in-sharepoint-2010"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.2 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>CRUD operation with SharePoint List in Visual web part | Maria Academy<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.softwaretraininginchennai.com\/blog\/crud-operation-with-sharepoint-list-in-visual-web-part\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"CRUD operation with SharePoint List in Visual web part | Maria Academy\" \/>\n<meta property=\"og:description\" content=\"Document by Ganesan &#8211; Ganesanva@hotmail.com &#8211; + 919600370429 Create EmployeeList in Sharepoint 2010 site with the below Columns. EmployeeName, Age Create a new Visual Web part Project using File &#8211;&gt;New Project Click Ok. The Solution Explorer will looks as below, In VisualWebPart1UserControl.ascx Put the below code snippet, &lt;table border=&#8221;0&#8243; cellpadding=&#8221;2&#8243; cellspacing=&#8221;2&#8243;&gt; &lt;tr&gt; &lt;td colspan=&#8221;2&#8243; style=&#8221;color:Green&#8221;&gt; [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.softwaretraininginchennai.com\/blog\/crud-operation-with-sharepoint-list-in-visual-web-part\/\" \/>\n<meta property=\"og:site_name\" content=\"Maria Academy\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/DotnetTrainingChennai\" \/>\n<meta property=\"article:published_time\" content=\"2016-11-13T04:27:09+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2017-02-10T03:02:11+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/www.softwaretraininginchennai.com\/blog\/wp-content\/uploads\/2016\/11\/111316_0426_CRUDoperati1.png\" \/>\n<meta name=\"author\" content=\"admin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@dotnettraining2\" \/>\n<meta name=\"twitter:site\" content=\"@dotnettraining2\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"admin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.softwaretraininginchennai.com\/blog\/crud-operation-with-sharepoint-list-in-visual-web-part\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.softwaretraininginchennai.com\/blog\/crud-operation-with-sharepoint-list-in-visual-web-part\/\"},\"author\":{\"name\":\"admin\",\"@id\":\"https:\/\/www.softwaretraininginchennai.com\/blog\/#\/schema\/person\/e7dbda3490333ae356b6ad09076c8a6e\"},\"headline\":\"CRUD operation with SharePoint List in Visual web part\",\"datePublished\":\"2016-11-13T04:27:09+00:00\",\"dateModified\":\"2017-02-10T03:02:11+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.softwaretraininginchennai.com\/blog\/crud-operation-with-sharepoint-list-in-visual-web-part\/\"},\"wordCount\":640,\"image\":{\"@id\":\"https:\/\/www.softwaretraininginchennai.com\/blog\/crud-operation-with-sharepoint-list-in-visual-web-part\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/www.softwaretraininginchennai.com\/blog\/wp-content\/uploads\/2016\/11\/111316_0426_CRUDoperati1.png\",\"keywords\":[\"Download Visual webpart sample\",\"freelance sharepoint developer\",\"server object model example\",\"Share Point freelancing in chennai\",\"Share Point Part time consultants in chennai\",\"Sharepoint 2010 CRUD operation in Visual studio\",\"Sharepoint list CRUD operation\",\"sharepoint training in Chennai\",\"Visual Webpart in sharepoint 2010\"],\"articleSection\":[\"SharePoint Freelancers in Chennai\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.softwaretraininginchennai.com\/blog\/crud-operation-with-sharepoint-list-in-visual-web-part\/\",\"url\":\"https:\/\/www.softwaretraininginchennai.com\/blog\/crud-operation-with-sharepoint-list-in-visual-web-part\/\",\"name\":\"CRUD operation with SharePoint List in Visual web part | Maria Academy\",\"isPartOf\":{\"@id\":\"https:\/\/www.softwaretraininginchennai.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.softwaretraininginchennai.com\/blog\/crud-operation-with-sharepoint-list-in-visual-web-part\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.softwaretraininginchennai.com\/blog\/crud-operation-with-sharepoint-list-in-visual-web-part\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/www.softwaretraininginchennai.com\/blog\/wp-content\/uploads\/2016\/11\/111316_0426_CRUDoperati1.png\",\"datePublished\":\"2016-11-13T04:27:09+00:00\",\"dateModified\":\"2017-02-10T03:02:11+00:00\",\"author\":{\"@id\":\"https:\/\/www.softwaretraininginchennai.com\/blog\/#\/schema\/person\/e7dbda3490333ae356b6ad09076c8a6e\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.softwaretraininginchennai.com\/blog\/crud-operation-with-sharepoint-list-in-visual-web-part\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.softwaretraininginchennai.com\/blog\/crud-operation-with-sharepoint-list-in-visual-web-part\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.softwaretraininginchennai.com\/blog\/crud-operation-with-sharepoint-list-in-visual-web-part\/#primaryimage\",\"url\":\"http:\/\/www.softwaretraininginchennai.com\/blog\/wp-content\/uploads\/2016\/11\/111316_0426_CRUDoperati1.png\",\"contentUrl\":\"http:\/\/www.softwaretraininginchennai.com\/blog\/wp-content\/uploads\/2016\/11\/111316_0426_CRUDoperati1.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.softwaretraininginchennai.com\/blog\/crud-operation-with-sharepoint-list-in-visual-web-part\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.softwaretraininginchennai.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"CRUD operation with SharePoint List in Visual web part\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.softwaretraininginchennai.com\/blog\/#website\",\"url\":\"https:\/\/www.softwaretraininginchennai.com\/blog\/\",\"name\":\"Maria Academy\",\"description\":\"Dot Net Training in Chennai, Best Dot Net Training Institute in Chennai, .Net Training in Chennai\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.softwaretraininginchennai.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.softwaretraininginchennai.com\/blog\/#\/schema\/person\/e7dbda3490333ae356b6ad09076c8a6e\",\"name\":\"admin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/secure.gravatar.com\/avatar\/f68fba18793457e0192658e2fe53431c0fb4a1d551aef61c57c1847324110d80?s=96&d=mm&r=g\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/f68fba18793457e0192658e2fe53431c0fb4a1d551aef61c57c1847324110d80?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/f68fba18793457e0192658e2fe53431c0fb4a1d551aef61c57c1847324110d80?s=96&d=mm&r=g\",\"caption\":\"admin\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"CRUD operation with SharePoint List in Visual web part | Maria Academy","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.softwaretraininginchennai.com\/blog\/crud-operation-with-sharepoint-list-in-visual-web-part\/","og_locale":"en_US","og_type":"article","og_title":"CRUD operation with SharePoint List in Visual web part | Maria Academy","og_description":"Document by Ganesan &#8211; Ganesanva@hotmail.com &#8211; + 919600370429 Create EmployeeList in Sharepoint 2010 site with the below Columns. EmployeeName, Age Create a new Visual Web part Project using File &#8211;&gt;New Project Click Ok. The Solution Explorer will looks as below, In VisualWebPart1UserControl.ascx Put the below code snippet, &lt;table border=&#8221;0&#8243; cellpadding=&#8221;2&#8243; cellspacing=&#8221;2&#8243;&gt; &lt;tr&gt; &lt;td colspan=&#8221;2&#8243; style=&#8221;color:Green&#8221;&gt; [&hellip;]","og_url":"https:\/\/www.softwaretraininginchennai.com\/blog\/crud-operation-with-sharepoint-list-in-visual-web-part\/","og_site_name":"Maria Academy","article_publisher":"https:\/\/www.facebook.com\/DotnetTrainingChennai","article_published_time":"2016-11-13T04:27:09+00:00","article_modified_time":"2017-02-10T03:02:11+00:00","og_image":[{"url":"http:\/\/www.softwaretraininginchennai.com\/blog\/wp-content\/uploads\/2016\/11\/111316_0426_CRUDoperati1.png","type":"","width":"","height":""}],"author":"admin","twitter_card":"summary_large_image","twitter_creator":"@dotnettraining2","twitter_site":"@dotnettraining2","twitter_misc":{"Written by":"admin","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.softwaretraininginchennai.com\/blog\/crud-operation-with-sharepoint-list-in-visual-web-part\/#article","isPartOf":{"@id":"https:\/\/www.softwaretraininginchennai.com\/blog\/crud-operation-with-sharepoint-list-in-visual-web-part\/"},"author":{"name":"admin","@id":"https:\/\/www.softwaretraininginchennai.com\/blog\/#\/schema\/person\/e7dbda3490333ae356b6ad09076c8a6e"},"headline":"CRUD operation with SharePoint List in Visual web part","datePublished":"2016-11-13T04:27:09+00:00","dateModified":"2017-02-10T03:02:11+00:00","mainEntityOfPage":{"@id":"https:\/\/www.softwaretraininginchennai.com\/blog\/crud-operation-with-sharepoint-list-in-visual-web-part\/"},"wordCount":640,"image":{"@id":"https:\/\/www.softwaretraininginchennai.com\/blog\/crud-operation-with-sharepoint-list-in-visual-web-part\/#primaryimage"},"thumbnailUrl":"http:\/\/www.softwaretraininginchennai.com\/blog\/wp-content\/uploads\/2016\/11\/111316_0426_CRUDoperati1.png","keywords":["Download Visual webpart sample","freelance sharepoint developer","server object model example","Share Point freelancing in chennai","Share Point Part time consultants in chennai","Sharepoint 2010 CRUD operation in Visual studio","Sharepoint list CRUD operation","sharepoint training in Chennai","Visual Webpart in sharepoint 2010"],"articleSection":["SharePoint Freelancers in Chennai"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.softwaretraininginchennai.com\/blog\/crud-operation-with-sharepoint-list-in-visual-web-part\/","url":"https:\/\/www.softwaretraininginchennai.com\/blog\/crud-operation-with-sharepoint-list-in-visual-web-part\/","name":"CRUD operation with SharePoint List in Visual web part | Maria Academy","isPartOf":{"@id":"https:\/\/www.softwaretraininginchennai.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.softwaretraininginchennai.com\/blog\/crud-operation-with-sharepoint-list-in-visual-web-part\/#primaryimage"},"image":{"@id":"https:\/\/www.softwaretraininginchennai.com\/blog\/crud-operation-with-sharepoint-list-in-visual-web-part\/#primaryimage"},"thumbnailUrl":"http:\/\/www.softwaretraininginchennai.com\/blog\/wp-content\/uploads\/2016\/11\/111316_0426_CRUDoperati1.png","datePublished":"2016-11-13T04:27:09+00:00","dateModified":"2017-02-10T03:02:11+00:00","author":{"@id":"https:\/\/www.softwaretraininginchennai.com\/blog\/#\/schema\/person\/e7dbda3490333ae356b6ad09076c8a6e"},"breadcrumb":{"@id":"https:\/\/www.softwaretraininginchennai.com\/blog\/crud-operation-with-sharepoint-list-in-visual-web-part\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.softwaretraininginchennai.com\/blog\/crud-operation-with-sharepoint-list-in-visual-web-part\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.softwaretraininginchennai.com\/blog\/crud-operation-with-sharepoint-list-in-visual-web-part\/#primaryimage","url":"http:\/\/www.softwaretraininginchennai.com\/blog\/wp-content\/uploads\/2016\/11\/111316_0426_CRUDoperati1.png","contentUrl":"http:\/\/www.softwaretraininginchennai.com\/blog\/wp-content\/uploads\/2016\/11\/111316_0426_CRUDoperati1.png"},{"@type":"BreadcrumbList","@id":"https:\/\/www.softwaretraininginchennai.com\/blog\/crud-operation-with-sharepoint-list-in-visual-web-part\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.softwaretraininginchennai.com\/blog\/"},{"@type":"ListItem","position":2,"name":"CRUD operation with SharePoint List in Visual web part"}]},{"@type":"WebSite","@id":"https:\/\/www.softwaretraininginchennai.com\/blog\/#website","url":"https:\/\/www.softwaretraininginchennai.com\/blog\/","name":"Maria Academy","description":"Dot Net Training in Chennai, Best Dot Net Training Institute in Chennai, .Net Training in Chennai","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.softwaretraininginchennai.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.softwaretraininginchennai.com\/blog\/#\/schema\/person\/e7dbda3490333ae356b6ad09076c8a6e","name":"admin","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/f68fba18793457e0192658e2fe53431c0fb4a1d551aef61c57c1847324110d80?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/f68fba18793457e0192658e2fe53431c0fb4a1d551aef61c57c1847324110d80?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/f68fba18793457e0192658e2fe53431c0fb4a1d551aef61c57c1847324110d80?s=96&d=mm&r=g","caption":"admin"}}]}},"_links":{"self":[{"href":"https:\/\/www.softwaretraininginchennai.com\/blog\/wp-json\/wp\/v2\/posts\/154","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.softwaretraininginchennai.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.softwaretraininginchennai.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.softwaretraininginchennai.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.softwaretraininginchennai.com\/blog\/wp-json\/wp\/v2\/comments?post=154"}],"version-history":[{"count":1,"href":"https:\/\/www.softwaretraininginchennai.com\/blog\/wp-json\/wp\/v2\/posts\/154\/revisions"}],"predecessor-version":[{"id":296,"href":"https:\/\/www.softwaretraininginchennai.com\/blog\/wp-json\/wp\/v2\/posts\/154\/revisions\/296"}],"wp:attachment":[{"href":"https:\/\/www.softwaretraininginchennai.com\/blog\/wp-json\/wp\/v2\/media?parent=154"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.softwaretraininginchennai.com\/blog\/wp-json\/wp\/v2\/categories?post=154"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.softwaretraininginchennai.com\/blog\/wp-json\/wp\/v2\/tags?post=154"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}