Skip to content

Searcharticlesvideosblogsforumsinterview questionsarticles

Tech
Articles
Blogs
News
Videos
Interviews
Forums
Books
Events
- Jobs
- Stories

Article
Blog
Video
Ebook
Interview Question

Loading

Upcoming Events

23 NOV
AI Agents Conference 2026 - 3rd Edition

Our Training Programs

AI & Machine Learning
Mastering Large Language Models
Mastering Prompt Engineering
Certified Vibe Coder
Github Copilot Training
Generative AI for Beginners
n8n Automation & AI Agents Training

About Us Contact Us Privacy Policy Terms Brand Guidelines Partners C# Tutorials Consultants Ideas Report A Bug FAQs Sitemap Stories CSharp TV DB Talks Web3 Universe Jumpstart Blockchain

©2026 C# Corner.

All contents are copyright of their authors.

Insert a record by using disconnected architecture

Home
Forums
Learn iOS Programming

Insert a record by using disconnected architecture

Sreekanth Reddy

Sreekanth Reddy

13yAsked Jul 10, 2013, 9:56 AM7.9kLearn iOS Programming

Hai friends, please provide me code for inserting a record into data grid view in windows form in disconnected architecture.....

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Sign in to answer this question

It is the same account you read, post and publish with — and you will come straight back to this page.

Sign in Create an account

Iftikar Hussain13y ago
Hi,
You can do like this

public partial class Form1 : Form
{
public Form1()
{
InitializeComponent();
FillData();
}

void FillData()
{
// 1
// Open connection
using (SqlConnection c = new SqlConnection(connectionString))
{
c.Open();
// 2
// Create new DataAdapter
using (SqlDataAdapter da = new SqlDataAdapter("SELECT * FROM EmployeeIDs", c))
{
// 3
// Use DataAdapter to fill DataTable
DataSet ds = new DataSet();
da.Fill(ds);

// 4
// Render data onto the screen
// dataGridView1.DataSource = ds.Tables[0]; // fill your datagrid
}
}
}
}

Regards,
Iftikar
0
Sanjeeb Lenka13y ago
The architecture of ADO.net in which data retrieved from database can be accessed even when connection to database was closed is called as disconnected architecture. Disconnected architecture of ADO.net was built on classes connection, dataadapter, commandbuilder and dataset and dataview.

check this link with explanation

http://www.programcall.com/3/adonet/disconnected-architecture-in-adonet.aspx

http://helpingdotnet.blogspot.in/2011/10/connected-and-disconnected-architecture.html

for gridview insert using connected and disconnected check below link

http://sudhakardasoju.wordpress.com/2012/06/22/filling-gridview-using-disconnected-and-connected-connection/
0