{"id":172,"date":"2016-11-24T12:39:01","date_gmt":"2016-11-24T12:39:01","guid":{"rendered":"http:\/\/www.softwaretraininginchennai.com\/blog\/?p=172"},"modified":"2017-02-10T03:01:02","modified_gmt":"2017-02-10T03:01:02","slug":"crud-in-asp-net-web-application-using-stored-procedure","status":"publish","type":"post","link":"https:\/\/www.softwaretraininginchennai.com\/blog\/crud-in-asp-net-web-application-using-stored-procedure\/","title":{"rendered":"CRUD in ASP.net web application using Stored procedure"},"content":{"rendered":"
\n

Document by Maria Academy – mariatrainingacademy@gmail.com\u00a0– +919042710472
\n<\/span><\/h2>\n

Create Database in SQL server as below,<\/p>\n\n\n<\/colgroup>\n\n\n
Create database StudentDB<\/b><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

Create StudentDetails table using the below script,<\/p>\n

\n\n\n<\/colgroup>\n\n\n
CREATE TABLE [dbo].[StudentDetails](
\n[StudentId] [int] IDENTITY(1,1) NOT NULL,
\n[StudentName] [varchar](100) NULL,
\n[Age] [int] NULL
\n) ON [PRIMARY]<\/b><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n

Run the below Stored Procedures in SQL Server,<\/p>\n

\n\n\n<\/colgroup>\n\n\n
create Proc [dbo].[Ins_StudentDetails]
\n@StudentName varchar(100),
\n@Age int
\nas
\nbegin
\nINSERT INTO [StudentDetails]
\n([StudentName]
\n,[Age])
\nVALUES
\n(@StudentName
\n,@Age)<\/b><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n
\n\n\n<\/colgroup>\n\n\n
create Proc [dbo].[Select_StudentDetails]
\nas
\nbegin
\nselect * from StudentDetails
\nend<\/b><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n
\n\n\n<\/colgroup>\n\n\n
create Proc [dbo].[Update_StudentDetails]
\n@StudentId int,
\n@StudentName varchar(100),
\n@Age int
\nas
\nbegin
\nUPDATE [StudentDetails]
\nSET [StudentName] = @StudentName
\n,[Age] = @Age
\nWHERE StudentId=@StudentId
\nend<\/b><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n

Create a new Asp.net web application CRUDinProcedure as below,
\nFile -> New Project
\n\"\"
\nClick OK.
\nSolution Explorer as below,
\n\"\"
\nAdd new Page AddStudentDetails.aspx<\/strong>
\nPut \/ Replace the below code in AddStudentDetails.aspx<\/strong><\/p>\n

\n\n\n<\/colgroup>\n\n\n
<html xmlns=”http:\/\/www.w3.org\/1999\/xhtml”>
\n<head id=”Head1″ runat=”server”>
\n<title><\/title>
\n<\/head>
\n<body>
\n<form id=”form1″ runat=”server”>
\n<div>
\n<table border=”0″ cellspacing=”2″ cellpadding=”2″>
\n<tr>
\n<td>
\n<asp:Label ID=”lblStudentName” runat=”server” Text=”Student Name”><\/asp:Label>
\n<\/td>
\n<td>
\n<asp:TextBox ID=”txtStudentName” runat=”server”><\/asp:TextBox>
\n<\/td>
\n<\/tr>
\n<tr>
\n<td>
\n<asp:Label ID=”lblAge” runat=”server” Text=”Age”><\/asp:Label>
\n<\/td>
\n<td>
\n<asp:TextBox ID=”txtAge” runat=”server”><\/asp:TextBox>
\n<\/td>
\n<\/tr>
\n<tr>
\n<td><\/td>
\n<td>
\n<asp:Button ID=”btnSubmit” runat=”server” Text=”Submit” OnClick=”btnSubmit_Click” \/>
\n<asp:Button ID=”btnUpdate” runat=”server” Text=”Update” OnClick=”btnUpdate_Click” \/>
\n<asp:Button ID=”btnClear” runat=”server” Text=”Clear” OnClick=”btnClear_Click” \/>
\n<asp:HiddenField ID=”hfId” runat=”server”><\/asp:HiddenField>
\n<\/td>
\n<\/tr>
\n<tr>
\n<td colspan=”2″>
\n<asp:GridView ID=”grvStudentDetails” runat=”server” AutoGenerateColumns=”false”>
\n<Columns>
\n<asp:BoundField DataField=”StudentId” HeaderText=”StudentId” \/>
\n<asp:BoundField DataField=”StudentName” HeaderText=”StudentName” \/>
\n<asp:BoundField DataField=”Age” HeaderText=”Age” \/>
\n<asp:TemplateField>
\n<ItemTemplate>
\n<asp:Button ID=”btnEdit” runat=”server” Text=”Edit” OnClick=”btnEdit_Click” \/>
\n<\/ItemTemplate>
\n<\/asp:TemplateField>
\n<\/Columns>
\n<\/asp:GridView>
\n<\/td>
\n<\/tr>
\n<\/table>
\n<\/div>
\n<\/form>
\n<\/body>
\n<\/html><\/b><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n

Replace the below code in AddStudentDetails.aspx.cs,<\/p>\n

\n\n\n<\/colgroup>\n\n\n
public partial class AddStudentDetails : System.Web.UI.Page
\n{
\nSqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings[“DefaultConnection”].ToString());
\nprotected void Page_Load(object sender, EventArgs e)
\n{
\nif (!Page.IsPostBack)
\n{
\nBindGrid();
\n}
\n}
\nprivate void BindGrid()
\n{
\nbtnSubmit.Visible = true;
\nbtnUpdate.Visible = false;
\nSqlCommand cmd = new SqlCommand(“Select_StudentDetails”, con);
\ncmd.CommandType = CommandType.StoredProcedure;
\nSqlDataAdapter ada = new SqlDataAdapter(cmd);
\nDataSet ds = new DataSet();
\nada.Fill(ds);
\ngrvStudentDetails.DataSource = ds.Tables[0];
\ngrvStudentDetails.DataBind();
\n}
\nprotected void btnSubmit_Click(object sender, EventArgs e)
\n{
\ncon.Open();
\nSqlCommand cmd = new SqlCommand(“Ins_StudentDetails”, con);
\ncmd.CommandType = CommandType.StoredProcedure;
\ncmd.Parameters.Add(“@StudentName”, SqlDbType.VarChar).Value = txtStudentName.Text;
\ncmd.Parameters.Add(“@Age”, SqlDbType.Int).Value = txtAge.Text;
\nint result = cmd.ExecuteNonQuery();
\nif (result > 0)
\n{
\nResponse.Write(“Inserted Successfully”);
\n}
\ncon.Close();
\nBindGrid();
\nbtnClear_Click(null, null);
\n}
\nprotected void btnEdit_Click(object sender, EventArgs e)
\n{
\nButton btn = (Button)sender;
\n\/\/Get the row that contains this button
\nGridViewRow gvr = (GridViewRow)btn.NamingContainer;
\nhfId.Value = gvr.Cells[0].Text;
\ntxtStudentName.Text = gvr.Cells[1].Text;
\ntxtAge.Text = gvr.Cells[2].Text;
\nbtnSubmit.Visible = false;
\nbtnUpdate.Visible = true;
\n}
\nprotected void btnUpdate_Click(object sender, EventArgs e)
\n{
\ncon.Open();
\nSqlCommand cmd = new SqlCommand(“Update_StudentDetails”, con);
\ncmd.CommandType = CommandType.StoredProcedure;
\ncmd.Parameters.Add(“@StudentId”, SqlDbType.Int).Value = hfId.Value;
\ncmd.Parameters.Add(“@StudentName”, SqlDbType.VarChar).Value = txtStudentName.Text;
\ncmd.Parameters.Add(“@Age”, SqlDbType.Int).Value = txtAge.Text;
\nint result = cmd.ExecuteNonQuery();
\nif (result > 0)
\n{
\nResponse.Write(“Updated Successfully”);
\n}
\ncon.Close();
\nBindGrid();
\nbtnClear_Click(null, null);
\n}
\nprotected void btnClear_Click(object sender, EventArgs e)
\n{
\ntxtStudentName.Text = string.Empty;
\ntxtAge.Text = string.Empty;
\nhfId.Value = string.Empty;
\n}
\n}<\/b><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n

Screenshot as below,
\n\"\"
\nThe Output will be as below,<\/b><\/span>
\n\"\"
\n\"\"
\n\"\"
\n\"\"
\nClick below to download the solution,
\nhttps:\/\/1drv.ms\/u\/s!ArddhCoxftkQg6of7HjHOGOkB8IMXA<\/a><\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"

Document by Maria Academy – mariatrainingacademy@gmail.com\u00a0– +919042710472 Create Database in SQL server as below, Create database StudentDB Create StudentDetails table using the below script, CREATE TABLE [dbo].[StudentDetails]( [StudentId] [int] IDENTITY(1,1) NOT NULL, [StudentName] [varchar](100) NULL, [Age] [int] NULL ) ON [PRIMARY] Run the below Stored Procedures in SQL Server, create Proc [dbo].[Ins_StudentDetails] @StudentName varchar(100), @Age […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3,1],"tags":[10,11,12,17,20,24,25,26,28,35,38,41,47],"class_list":["post-172","post","type-post","status-publish","format-standard","hentry","category-dot-net-training-in-chennai","category-uncategorized","tag-net-freelance-developer-in-chennai","tag-net-freelancers-in-chennai","tag-net-part-time-consultant-in-chennai","tag-asp-net-crud-with-stored-procedure","tag-asp-net-training-in-chennai","tag-asp-net-web-application-and-stored-procedure","tag-asp-net-web-application-download","tag-asp-net-web-application-sample","tag-asp-net-with-ado-net-architecture","tag-crud-operation-in-asp-net","tag-dot-net-consultants-in-chennai","tag-dot-net-freelancer","tag-dot-net-training-chennai"],"yoast_head":"\nCRUD in ASP.net web application using Stored procedure | 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-in-asp-net-web-application-using-stored-procedure\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"CRUD in ASP.net web application using Stored procedure | Maria Academy\" \/>\n<meta property=\"og:description\" content=\"Document by Maria Academy – mariatrainingacademy@gmail.com\u00a0– +919042710472 Create Database in SQL server as below, Create database StudentDB Create StudentDetails table using the below script, CREATE TABLE [dbo].[StudentDetails]( [StudentId] [int] IDENTITY(1,1) NOT NULL, [StudentName] [varchar](100) NULL, [Age] [int] NULL ) ON [PRIMARY] Run the below Stored Procedures in SQL Server, create Proc [dbo].[Ins_StudentDetails] @StudentName varchar(100), @Age […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.softwaretraininginchennai.com\/blog\/crud-in-asp-net-web-application-using-stored-procedure\/\" \/>\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-24T12:39:01+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2017-02-10T03:01:02+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/www.softwaretraininginchennai.com\/blog\/wp-content\/uploads\/2016\/11\/112416_1238_CRUDinASPne1.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=\"4 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-in-asp-net-web-application-using-stored-procedure\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.softwaretraininginchennai.com\/blog\/crud-in-asp-net-web-application-using-stored-procedure\/\"},\"author\":{\"name\":\"admin\",\"@id\":\"https:\/\/www.softwaretraininginchennai.com\/blog\/#\/schema\/person\/e7dbda3490333ae356b6ad09076c8a6e\"},\"headline\":\"CRUD in ASP.net web application using Stored procedure\",\"datePublished\":\"2016-11-24T12:39:01+00:00\",\"dateModified\":\"2017-02-10T03:01:02+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.softwaretraininginchennai.com\/blog\/crud-in-asp-net-web-application-using-stored-procedure\/\"},\"wordCount\":735,\"image\":{\"@id\":\"https:\/\/www.softwaretraininginchennai.com\/blog\/crud-in-asp-net-web-application-using-stored-procedure\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/www.softwaretraininginchennai.com\/blog\/wp-content\/uploads\/2016\/11\/112416_1238_CRUDinASPne1.png\",\"keywords\":[\".net freelance developer in chennai\",\".net freelancers in chennai\",\".net part time consultant in chennai\",\"ASP.net CRUD with Stored Procedure\",\"Asp.net Training in chennai\",\"Asp.net web application and stored procedure\",\"Asp.net web application download\",\"Asp.net web application sample\",\"Asp.net with Ado.net architecture\",\"CRUD operation in Asp.net\",\"Dot net consultants in chennai\",\"Dot net freelancer\",\"dot net training Chennai\"],\"articleSection\":[\"dot net training in chennai\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.softwaretraininginchennai.com\/blog\/crud-in-asp-net-web-application-using-stored-procedure\/\",\"url\":\"https:\/\/www.softwaretraininginchennai.com\/blog\/crud-in-asp-net-web-application-using-stored-procedure\/\",\"name\":\"CRUD in ASP.net web application using Stored procedure | Maria Academy\",\"isPartOf\":{\"@id\":\"https:\/\/www.softwaretraininginchennai.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.softwaretraininginchennai.com\/blog\/crud-in-asp-net-web-application-using-stored-procedure\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.softwaretraininginchennai.com\/blog\/crud-in-asp-net-web-application-using-stored-procedure\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/www.softwaretraininginchennai.com\/blog\/wp-content\/uploads\/2016\/11\/112416_1238_CRUDinASPne1.png\",\"datePublished\":\"2016-11-24T12:39:01+00:00\",\"dateModified\":\"2017-02-10T03:01:02+00:00\",\"author\":{\"@id\":\"https:\/\/www.softwaretraininginchennai.com\/blog\/#\/schema\/person\/e7dbda3490333ae356b6ad09076c8a6e\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.softwaretraininginchennai.com\/blog\/crud-in-asp-net-web-application-using-stored-procedure\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.softwaretraininginchennai.com\/blog\/crud-in-asp-net-web-application-using-stored-procedure\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.softwaretraininginchennai.com\/blog\/crud-in-asp-net-web-application-using-stored-procedure\/#primaryimage\",\"url\":\"http:\/\/www.softwaretraininginchennai.com\/blog\/wp-content\/uploads\/2016\/11\/112416_1238_CRUDinASPne1.png\",\"contentUrl\":\"http:\/\/www.softwaretraininginchennai.com\/blog\/wp-content\/uploads\/2016\/11\/112416_1238_CRUDinASPne1.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.softwaretraininginchennai.com\/blog\/crud-in-asp-net-web-application-using-stored-procedure\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.softwaretraininginchennai.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"CRUD in ASP.net web application using Stored procedure\"}]},{\"@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 in ASP.net web application using Stored procedure | 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-in-asp-net-web-application-using-stored-procedure\/","og_locale":"en_US","og_type":"article","og_title":"CRUD in ASP.net web application using Stored procedure | Maria Academy","og_description":"Document by Maria Academy – mariatrainingacademy@gmail.com\u00a0– +919042710472 Create Database in SQL server as below, Create database StudentDB Create StudentDetails table using the below script, CREATE TABLE [dbo].[StudentDetails]( [StudentId] [int] IDENTITY(1,1) NOT NULL, [StudentName] [varchar](100) NULL, [Age] [int] NULL ) ON [PRIMARY] Run the below Stored Procedures in SQL Server, create Proc [dbo].[Ins_StudentDetails] @StudentName varchar(100), @Age […]","og_url":"https:\/\/www.softwaretraininginchennai.com\/blog\/crud-in-asp-net-web-application-using-stored-procedure\/","og_site_name":"Maria Academy","article_publisher":"https:\/\/www.facebook.com\/DotnetTrainingChennai","article_published_time":"2016-11-24T12:39:01+00:00","article_modified_time":"2017-02-10T03:01:02+00:00","og_image":[{"url":"http:\/\/www.softwaretraininginchennai.com\/blog\/wp-content\/uploads\/2016\/11\/112416_1238_CRUDinASPne1.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":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.softwaretraininginchennai.com\/blog\/crud-in-asp-net-web-application-using-stored-procedure\/#article","isPartOf":{"@id":"https:\/\/www.softwaretraininginchennai.com\/blog\/crud-in-asp-net-web-application-using-stored-procedure\/"},"author":{"name":"admin","@id":"https:\/\/www.softwaretraininginchennai.com\/blog\/#\/schema\/person\/e7dbda3490333ae356b6ad09076c8a6e"},"headline":"CRUD in ASP.net web application using Stored procedure","datePublished":"2016-11-24T12:39:01+00:00","dateModified":"2017-02-10T03:01:02+00:00","mainEntityOfPage":{"@id":"https:\/\/www.softwaretraininginchennai.com\/blog\/crud-in-asp-net-web-application-using-stored-procedure\/"},"wordCount":735,"image":{"@id":"https:\/\/www.softwaretraininginchennai.com\/blog\/crud-in-asp-net-web-application-using-stored-procedure\/#primaryimage"},"thumbnailUrl":"http:\/\/www.softwaretraininginchennai.com\/blog\/wp-content\/uploads\/2016\/11\/112416_1238_CRUDinASPne1.png","keywords":[".net freelance developer in chennai",".net freelancers in chennai",".net part time consultant in chennai","ASP.net CRUD with Stored Procedure","Asp.net Training in chennai","Asp.net web application and stored procedure","Asp.net web application download","Asp.net web application sample","Asp.net with Ado.net architecture","CRUD operation in Asp.net","Dot net consultants in chennai","Dot net freelancer","dot net training Chennai"],"articleSection":["dot net training in chennai"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.softwaretraininginchennai.com\/blog\/crud-in-asp-net-web-application-using-stored-procedure\/","url":"https:\/\/www.softwaretraininginchennai.com\/blog\/crud-in-asp-net-web-application-using-stored-procedure\/","name":"CRUD in ASP.net web application using Stored procedure | Maria Academy","isPartOf":{"@id":"https:\/\/www.softwaretraininginchennai.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.softwaretraininginchennai.com\/blog\/crud-in-asp-net-web-application-using-stored-procedure\/#primaryimage"},"image":{"@id":"https:\/\/www.softwaretraininginchennai.com\/blog\/crud-in-asp-net-web-application-using-stored-procedure\/#primaryimage"},"thumbnailUrl":"http:\/\/www.softwaretraininginchennai.com\/blog\/wp-content\/uploads\/2016\/11\/112416_1238_CRUDinASPne1.png","datePublished":"2016-11-24T12:39:01+00:00","dateModified":"2017-02-10T03:01:02+00:00","author":{"@id":"https:\/\/www.softwaretraininginchennai.com\/blog\/#\/schema\/person\/e7dbda3490333ae356b6ad09076c8a6e"},"breadcrumb":{"@id":"https:\/\/www.softwaretraininginchennai.com\/blog\/crud-in-asp-net-web-application-using-stored-procedure\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.softwaretraininginchennai.com\/blog\/crud-in-asp-net-web-application-using-stored-procedure\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.softwaretraininginchennai.com\/blog\/crud-in-asp-net-web-application-using-stored-procedure\/#primaryimage","url":"http:\/\/www.softwaretraininginchennai.com\/blog\/wp-content\/uploads\/2016\/11\/112416_1238_CRUDinASPne1.png","contentUrl":"http:\/\/www.softwaretraininginchennai.com\/blog\/wp-content\/uploads\/2016\/11\/112416_1238_CRUDinASPne1.png"},{"@type":"BreadcrumbList","@id":"https:\/\/www.softwaretraininginchennai.com\/blog\/crud-in-asp-net-web-application-using-stored-procedure\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.softwaretraininginchennai.com\/blog\/"},{"@type":"ListItem","position":2,"name":"CRUD in ASP.net web application using Stored procedure"}]},{"@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\/172","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=172"}],"version-history":[{"count":1,"href":"https:\/\/www.softwaretraininginchennai.com\/blog\/wp-json\/wp\/v2\/posts\/172\/revisions"}],"predecessor-version":[{"id":294,"href":"https:\/\/www.softwaretraininginchennai.com\/blog\/wp-json\/wp\/v2\/posts\/172\/revisions\/294"}],"wp:attachment":[{"href":"https:\/\/www.softwaretraininginchennai.com\/blog\/wp-json\/wp\/v2\/media?parent=172"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.softwaretraininginchennai.com\/blog\/wp-json\/wp\/v2\/categories?post=172"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.softwaretraininginchennai.com\/blog\/wp-json\/wp\/v2\/tags?post=172"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}