{"id":93,"date":"2016-10-26T06:40:17","date_gmt":"2016-10-26T06:40:17","guid":{"rendered":"http:\/\/www.softwaretraininginchennai.com\/blog\/?p=93"},"modified":"2017-02-10T03:05:39","modified_gmt":"2017-02-10T03:05:39","slug":"windows-application-crud-operation-with-ado-net","status":"publish","type":"post","link":"https:\/\/www.softwaretraininginchennai.com\/blog\/windows-application-crud-operation-with-ado-net\/","title":{"rendered":"Windows Application CRUD Operation with ADO.net"},"content":{"rendered":"
\n

Document by Ganesan – Ganesanva@hotmail.com – +919600370429
\n<\/span><\/h2>\n

Create TestDB<\/strong> Database in Server Explorer
\nCreate table UserDetails<\/strong> in TestDB with the below code snippet,<\/p>\n

\n\n\n<\/colgroup>\n\n\n
CREATE TABLE [dbo].[UserDetails] (
\n[UserId] INT IDENTITY (1, 1) NOT NULL,
\n[UserName] VARCHAR (100) NULL,
\n[Password] VARCHAR (100) NULL,
\n[City] VARCHAR (100) NULL,
\nPRIMARY KEY CLUSTERED ([UserId] ASC)
\n);<\/b><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n

\"\"
\nAdd the below Connection string in app.config,<\/p>\n

\n\n\n<\/colgroup>\n\n\n
<connectionStrings>
\n<add name=”TestConnection” connectionString=”Data Source=(LocalDb)\\v11.0;Initial Catalog=TestDB;Integrated Security=True;Pooling=False” providerName=”System.Data.SqlClient” \/>
\n<\/connectionStrings><\/b><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n

\"\"
\nDesign Form1 as below,
\n\"\"
\nTextbox Properties<\/strong>
\nUserName Name – txtUserName
\nPassword Name – txtPassword
\nCity Name – txtCity
\nSave -btnSave
\nShow Data Link Name -linkLabel1<\/p>\n

Events<\/strong>
\nbtnSave OnClick =btnSave_Click
\nShow Data Link onClick= linkLabel1_LinkClicked
\nAdd below Namespace in Form1.cs.<\/p>\n

\n\n\n<\/colgroup>\n\n\n
Using System.Data.SqlClient;
\nUsing System.Configuration;<\/b><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n

Add Reference System.Configuration.DLL in the Project.
\nIn Form1.cs (Replace) put the below Snippet,<\/p>\n

\n\n\n<\/colgroup>\n\n\n
public partial class Form1 : Form
\n{
\nSqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings[“TestConnection”].ConnectionString);
\npublic Form1()
\n{
\nInitializeComponent();
\n}
\nprivate void btnSave_Click(object sender, EventArgs e)
\n{
\ncon.Open();
\nSqlCommand cmd = new SqlCommand(“insert into UserDetails values(‘”+txtUserName.Text+”‘”+”,'”+txtPassword.Text +”‘,'”+txtCity.Text+”‘)”,con);
\nint results=cmd.ExecuteNonQuery();
\ncon.Close();
\nif (results > 0)
\n{
\nMessageBox.Show(“Inserted Successfully”);
\n}
\n}
\nprivate void Clear()
\n{
\ntxtUserName.Text = string.Empty;
\ntxtPassword.Text = string.Empty;
\ntxtCity.Text = string.Empty;
\n}
\nprivate void linkLabel1_LinkClicked(object sender, LinkLabelLinkClickedEventArgs e)
\n{
\nShowData objShowData = new ShowData();
\nobjShowData.Show();
\nthis.Hide();
\n}
\n}<\/b><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n

Add ShowData.cs form as below design,
\n\"\"
\nProperties<\/strong>
\nDataGrid Name – dgvGridData
\nUpdate Data Name – lnkUpdate<\/p>\n

Events<\/strong>
\nlnkUpdate Link onClick Event – lnkUpdate_LinkClicked
\nShowData Form OnLoad Event – ShowData_Load
\nAdd below Namespace in ShowData .cs.<\/p>\n

\n\n\n<\/colgroup>\n\n\n
Using System.Data.SqlClient;
\nUsing System.Configuration;<\/b><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n

In ShowData.cs (Replace) put the below Snippet,<\/p>\n

\n\n\n<\/colgroup>\n\n\n
public partial class ShowData : Form
\n{
\nSqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings[“TestConnection”].ConnectionString);
\npublic ShowData()
\n{
\nInitializeComponent();
\n}
\nprivate void ShowData_Load(object sender, EventArgs e)
\n{
\nSqlCommand cmd = new SqlCommand(“select * from UserDetails”, con);
\nSqlDataAdapter ada = new SqlDataAdapter(cmd);
\nDataSet ds = new DataSet();
\nada.Fill(ds);
\ndgvGridData.DataSource = ds.Tables[0];
\n}
\nprivate void lnkUpdate_LinkClicked(object sender, LinkLabelLinkClickedEventArgs e)
\n{
\nUpdateUserData objUpdateUserData = new UpdateUserData();
\nobjUpdateUserData.Show();
\nthis.Hide();
\n}
\n}<\/b><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n

Add UpdateUserData.cs Form as below Design,
\n\"\"
\nProperties<\/strong>
\nUserId textbox Name – txtUserId
\nUserName Textbox -txtUserName
\nPassword Textbox – txtPassword
\nCity Textbox – txtCity
\nUpdate button name -btnUpdate
\nGet Data button Name – btnGet
\nClear button Name – btnClear
\nShow Data Link Name -linkLabel1<\/p>\n

Event :<\/strong>
\nbtnUpdate onClick =btnUpdate_Click
\nbtnGet onClick= btnGet_Click
\nbtnClear onClick =btnClear_Click
\nlinkLabel1 onClick – linkLabel1_LinkClicked<\/p>\n

Add below Namespace in UpdateUserData .cs.<\/p>\n

\n\n\n<\/colgroup>\n\n\n
Using System.Data.SqlClient;
\nUsing System.Configuration;<\/b><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n

Put (Replace) the below snippet in UpdateUserData.cs ,<\/p>\n

\n\n\n<\/colgroup>\n\n\n
public partial class UpdateUserData : Form
\n{
\nSqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings[“TestConnection”].ConnectionString);
\npublic UpdateUserData()
\n{
\nInitializeComponent();
\n}
\nprivate void btnUpdate_Click(object sender, EventArgs e)
\n{
\ncon.Open();
\nSqlCommand cmd = new SqlCommand(“Update UserDetails Set UserName='” + txtUserName.Text + “‘,Password='” + txtPassword.Text + “‘,City='” + txtCity.Text + “‘ where UserId=” + txtUserId.Text, con);
\nint results = cmd.ExecuteNonQuery();
\ncon.Close();
\nif (results > 0)
\n{
\nMessageBox.Show(“Updated Successfully”);
\n}
\nClear();
\n}
\nprivate void Clear()
\n{
\ntxtUserId.Text = string.Empty;
\ntxtUserName.Text = string.Empty;
\ntxtPassword.Text = string.Empty;
\ntxtCity.Text = string.Empty;
\nbtnGet.Enabled = true;
\n}
\nprivate void btnGet_Click(object sender, EventArgs e)
\n{
\ncon.Open();
\nSqlCommand cmd = new SqlCommand(“select * from UserDetails where UserId=”+txtUserId.Text, con);
\nSqlDataReader dr = cmd.ExecuteReader();
\nwhile (dr.Read())
\n{
\ntxtUserName.Text = dr[“UserName”].ToString();
\ntxtPassword.Text = dr[“Password”].ToString();
\ntxtCity.Text = dr[“City”].ToString();
\n}
\ncon.Close();
\nbtnGet.Enabled = false;
\n}
\nprivate void linkLabel1_LinkClicked(object sender, LinkLabelLinkClickedEventArgs e)
\n{
\nShowData objShowData = new ShowData();
\nobjShowData.Show();
\nthis.Hide();
\n}
\nprivate void btnClear_Click(object sender, EventArgs e)
\n{
\nClear();
\n}
\n}<\/b><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n

The Output as below,<\/b><\/span>
\n\"\"
\n\"\"
\n\"\"
\nTable Data as below,
\n\"\"
\nClick below to download the solution,
\nhttps:\/\/1drv.ms\/u\/s!ArddhCoxftkQg6khuXmrBnLklntXTA<\/a><\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"

Document by Ganesan – Ganesanva@hotmail.com – +919600370429 Create TestDB Database in Server Explorer Create table UserDetails in TestDB with the below code snippet, CREATE TABLE [dbo].[UserDetails] ( [UserId] INT IDENTITY (1, 1) NOT NULL, [UserName] VARCHAR (100) NULL, [Password] VARCHAR (100) NULL, [City] VARCHAR (100) NULL, PRIMARY KEY CLUSTERED ([UserId] ASC) ); Add the below […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[4,1],"tags":[56,57,62,65,68,107,126,164,165,166,167],"class_list":["post-93","post","type-post","status-publish","format-standard","hentry","category-information-on-dotnet","category-uncategorized","tag-dotnet-consultant-in-chennai","tag-dotnet-course-in-chennai","tag-dotnet-windows-application-training","tag-download-windows-application-with-ado-net","tag-free-dot-net-demo-session-in-usa","tag-online-dotnet-training-in-hyderabad","tag-sample-windows-appllication","tag-windows-app-with-ado-net-architecture","tag-windows-application-in-net","tag-windows-application-tutorial","tag-windows-crud-operation"],"yoast_head":"\nWindows Application CRUD Operation with ADO.net | 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\/windows-application-crud-operation-with-ado-net\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Windows Application CRUD Operation with ADO.net | Maria Academy\" \/>\n<meta property=\"og:description\" content=\"Document by Ganesan – Ganesanva@hotmail.com – +919600370429 Create TestDB Database in Server Explorer Create table UserDetails in TestDB with the below code snippet, CREATE TABLE [dbo].[UserDetails] ( [UserId] INT IDENTITY (1, 1) NOT NULL, [UserName] VARCHAR (100) NULL, [Password] VARCHAR (100) NULL, [City] VARCHAR (100) NULL, PRIMARY KEY CLUSTERED ([UserId] ASC) ); Add the below […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.softwaretraininginchennai.com\/blog\/windows-application-crud-operation-with-ado-net\/\" \/>\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-10-26T06:40:17+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2017-02-10T03:05:39+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/www.softwaretraininginchennai.com\/blog\/wp-content\/uploads\/2016\/10\/102616_0640_WindowsAppl1.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\/windows-application-crud-operation-with-ado-net\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.softwaretraininginchennai.com\/blog\/windows-application-crud-operation-with-ado-net\/\"},\"author\":{\"name\":\"admin\",\"@id\":\"https:\/\/www.softwaretraininginchennai.com\/blog\/#\/schema\/person\/e7dbda3490333ae356b6ad09076c8a6e\"},\"headline\":\"Windows Application CRUD Operation with ADO.net\",\"datePublished\":\"2016-10-26T06:40:17+00:00\",\"dateModified\":\"2017-02-10T03:05:39+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.softwaretraininginchennai.com\/blog\/windows-application-crud-operation-with-ado-net\/\"},\"wordCount\":618,\"image\":{\"@id\":\"https:\/\/www.softwaretraininginchennai.com\/blog\/windows-application-crud-operation-with-ado-net\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/www.softwaretraininginchennai.com\/blog\/wp-content\/uploads\/2016\/10\/102616_0640_WindowsAppl1.png\",\"keywords\":[\"Dotnet Consultant in chennai\",\"Dotnet Course in chennai\",\"Dotnet Windows application training\",\"download windows application with ado.net\",\"Free dot net demo session in USA\",\"online dotnet training in hyderabad\",\"sample windows appllication\",\"windows app with ado.net architecture\",\"windows application in .net\",\"windows application tutorial\",\"windows CRUD operation\"],\"articleSection\":[\"information on dotnet\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.softwaretraininginchennai.com\/blog\/windows-application-crud-operation-with-ado-net\/\",\"url\":\"https:\/\/www.softwaretraininginchennai.com\/blog\/windows-application-crud-operation-with-ado-net\/\",\"name\":\"Windows Application CRUD Operation with ADO.net | Maria Academy\",\"isPartOf\":{\"@id\":\"https:\/\/www.softwaretraininginchennai.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.softwaretraininginchennai.com\/blog\/windows-application-crud-operation-with-ado-net\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.softwaretraininginchennai.com\/blog\/windows-application-crud-operation-with-ado-net\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/www.softwaretraininginchennai.com\/blog\/wp-content\/uploads\/2016\/10\/102616_0640_WindowsAppl1.png\",\"datePublished\":\"2016-10-26T06:40:17+00:00\",\"dateModified\":\"2017-02-10T03:05:39+00:00\",\"author\":{\"@id\":\"https:\/\/www.softwaretraininginchennai.com\/blog\/#\/schema\/person\/e7dbda3490333ae356b6ad09076c8a6e\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.softwaretraininginchennai.com\/blog\/windows-application-crud-operation-with-ado-net\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.softwaretraininginchennai.com\/blog\/windows-application-crud-operation-with-ado-net\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.softwaretraininginchennai.com\/blog\/windows-application-crud-operation-with-ado-net\/#primaryimage\",\"url\":\"http:\/\/www.softwaretraininginchennai.com\/blog\/wp-content\/uploads\/2016\/10\/102616_0640_WindowsAppl1.png\",\"contentUrl\":\"http:\/\/www.softwaretraininginchennai.com\/blog\/wp-content\/uploads\/2016\/10\/102616_0640_WindowsAppl1.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.softwaretraininginchennai.com\/blog\/windows-application-crud-operation-with-ado-net\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.softwaretraininginchennai.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Windows Application CRUD Operation with ADO.net\"}]},{\"@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":"Windows Application CRUD Operation with ADO.net | 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\/windows-application-crud-operation-with-ado-net\/","og_locale":"en_US","og_type":"article","og_title":"Windows Application CRUD Operation with ADO.net | Maria Academy","og_description":"Document by Ganesan – Ganesanva@hotmail.com – +919600370429 Create TestDB Database in Server Explorer Create table UserDetails in TestDB with the below code snippet, CREATE TABLE [dbo].[UserDetails] ( [UserId] INT IDENTITY (1, 1) NOT NULL, [UserName] VARCHAR (100) NULL, [Password] VARCHAR (100) NULL, [City] VARCHAR (100) NULL, PRIMARY KEY CLUSTERED ([UserId] ASC) ); Add the below […]","og_url":"https:\/\/www.softwaretraininginchennai.com\/blog\/windows-application-crud-operation-with-ado-net\/","og_site_name":"Maria Academy","article_publisher":"https:\/\/www.facebook.com\/DotnetTrainingChennai","article_published_time":"2016-10-26T06:40:17+00:00","article_modified_time":"2017-02-10T03:05:39+00:00","og_image":[{"url":"http:\/\/www.softwaretraininginchennai.com\/blog\/wp-content\/uploads\/2016\/10\/102616_0640_WindowsAppl1.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\/windows-application-crud-operation-with-ado-net\/#article","isPartOf":{"@id":"https:\/\/www.softwaretraininginchennai.com\/blog\/windows-application-crud-operation-with-ado-net\/"},"author":{"name":"admin","@id":"https:\/\/www.softwaretraininginchennai.com\/blog\/#\/schema\/person\/e7dbda3490333ae356b6ad09076c8a6e"},"headline":"Windows Application CRUD Operation with ADO.net","datePublished":"2016-10-26T06:40:17+00:00","dateModified":"2017-02-10T03:05:39+00:00","mainEntityOfPage":{"@id":"https:\/\/www.softwaretraininginchennai.com\/blog\/windows-application-crud-operation-with-ado-net\/"},"wordCount":618,"image":{"@id":"https:\/\/www.softwaretraininginchennai.com\/blog\/windows-application-crud-operation-with-ado-net\/#primaryimage"},"thumbnailUrl":"http:\/\/www.softwaretraininginchennai.com\/blog\/wp-content\/uploads\/2016\/10\/102616_0640_WindowsAppl1.png","keywords":["Dotnet Consultant in chennai","Dotnet Course in chennai","Dotnet Windows application training","download windows application with ado.net","Free dot net demo session in USA","online dotnet training in hyderabad","sample windows appllication","windows app with ado.net architecture","windows application in .net","windows application tutorial","windows CRUD operation"],"articleSection":["information on dotnet"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.softwaretraininginchennai.com\/blog\/windows-application-crud-operation-with-ado-net\/","url":"https:\/\/www.softwaretraininginchennai.com\/blog\/windows-application-crud-operation-with-ado-net\/","name":"Windows Application CRUD Operation with ADO.net | Maria Academy","isPartOf":{"@id":"https:\/\/www.softwaretraininginchennai.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.softwaretraininginchennai.com\/blog\/windows-application-crud-operation-with-ado-net\/#primaryimage"},"image":{"@id":"https:\/\/www.softwaretraininginchennai.com\/blog\/windows-application-crud-operation-with-ado-net\/#primaryimage"},"thumbnailUrl":"http:\/\/www.softwaretraininginchennai.com\/blog\/wp-content\/uploads\/2016\/10\/102616_0640_WindowsAppl1.png","datePublished":"2016-10-26T06:40:17+00:00","dateModified":"2017-02-10T03:05:39+00:00","author":{"@id":"https:\/\/www.softwaretraininginchennai.com\/blog\/#\/schema\/person\/e7dbda3490333ae356b6ad09076c8a6e"},"breadcrumb":{"@id":"https:\/\/www.softwaretraininginchennai.com\/blog\/windows-application-crud-operation-with-ado-net\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.softwaretraininginchennai.com\/blog\/windows-application-crud-operation-with-ado-net\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.softwaretraininginchennai.com\/blog\/windows-application-crud-operation-with-ado-net\/#primaryimage","url":"http:\/\/www.softwaretraininginchennai.com\/blog\/wp-content\/uploads\/2016\/10\/102616_0640_WindowsAppl1.png","contentUrl":"http:\/\/www.softwaretraininginchennai.com\/blog\/wp-content\/uploads\/2016\/10\/102616_0640_WindowsAppl1.png"},{"@type":"BreadcrumbList","@id":"https:\/\/www.softwaretraininginchennai.com\/blog\/windows-application-crud-operation-with-ado-net\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.softwaretraininginchennai.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Windows Application CRUD Operation with ADO.net"}]},{"@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\/93","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=93"}],"version-history":[{"count":1,"href":"https:\/\/www.softwaretraininginchennai.com\/blog\/wp-json\/wp\/v2\/posts\/93\/revisions"}],"predecessor-version":[{"id":302,"href":"https:\/\/www.softwaretraininginchennai.com\/blog\/wp-json\/wp\/v2\/posts\/93\/revisions\/302"}],"wp:attachment":[{"href":"https:\/\/www.softwaretraininginchennai.com\/blog\/wp-json\/wp\/v2\/media?parent=93"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.softwaretraininginchennai.com\/blog\/wp-json\/wp\/v2\/categories?post=93"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.softwaretraininginchennai.com\/blog\/wp-json\/wp\/v2\/tags?post=93"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}