Insert a record by using disconnected architecture

Question

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

Iftikar Hussain · Answer

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

Sanjeeb Lenka · Answer

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/

Insert a record by using disconnected architecture

Answers (2)