how to edit and update datagridview in window forms, while changes should reflect in oledb database

Question

how to edit datagridview in window application while the database is access.
and the changes should be reflect in database also.

like i displayed some tabe from access database in datagridview. then i want to changes values in datagridview and the new values sud be update in database.

pls someone suggest.

i am looking for this code for a while and have tried almost every technique
thanks in advance

Suthish Nair · Answer

what problem you facing now?

ram kumar · Answer

no , it is still not solved.

Suthish Nair · Answer

Please accept the post as answer, if your query is resolved. Thank You.

Sam Hobbs · Answer

Ram: you need to read the articles; using sample code without reading the articles can be a waste of time. In the case of my article, your data can be the sample data and the article provides instructions for easily and quickly developing a program to do what you need, but you do have to read the article.

Suthish Nair · Answer

Ram, Sams link already saying how to connect to DataSource. Rakesh code shows how to do the operations with tables. What problem your facing. Be specific which area you facing the issue.

ram kumar · Answer

yes, i have check that out, bt couldnt get that as it does nt has any sample. and too i couldnt get the navigation menu. in tht

Sam Hobbs · Answer

Database Table Update in a DataGridView without Writing Code

ram kumar · Answer

dear mr. jha , first of all thanks for your kind help u porvided to me . i tried a lot but couldnot get the thing working . i just need a datagridview having edit and delete options and that sud affect the database , that too in window. may i have your email pls . want to have some discussion regrading this . or a working demo , i can pay a little for this as this is very important for me . thanks.

Rakesh Jha · Answer

Hi ram, I am attaching the source file.

ram kumar · Answer

i couldnt get the design part of the sample like will i have to take any textbox also. its showing error with txtipno. i guess its a text box . i have just taken a datagridview and a single update button .thts it . please explain some design part of gv tht code too. it will be great helpful to me . i guess i am quiet near to the result. thanks.

ram kumar · Answer

i couldnt get the design part of the sample like will i have to take any textbox also. its showing error with txtipno. i guess its a text box . please explain some design part of gv tht code too. it will be great helpful to me . i guess i am quiet near to the result. thanks.

Rakesh Jha · Answer

Hi ram, sorry for late response. i am attaching access database file

Sam Hobbs · Answer

Have you looked at the articles listed in the list at the right side of this window?

ram kumar · Answer

i tried it but couldnt get it correctly ., may i have the hjhmhome.mdb database file to understand it more thoroughly. or can u pls upload its working sample with database. pls my now my job depends on it. thanks and waiting ur reply

Rakesh Jha · Answer

hi ram, here is example which will help you to work on access database in windows form with datagridview. 1. first add this namespace using System.Data.OleDb; 2. now write following code for display record in datagridview protected DataSet ObjDS = new DataSet(); protected String sConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\HJHMHome.mdb" ; private void DischargeForm_Load( object sender, EventArgs e) { using (OleDbConnection ObjCon = new OleDbConnection(sConnectionString)) { using (OleDbDataAdapter ObjAdapter = new OleDbDataAdapter( "SELECT * FROM Investigation Order by ColOrder" , ObjCon)) { ObjCon.Open(); ObjDS.Clear(); ObjAdapter.Fill(ObjDS, "Investigation" ); dgvInvestigation.DataSource = ObjDS.Tables[0]; ObjCon.Close(); } } } 3. Update DataGridView on btnUpdate click if (ObjDS.HasChanges()) { DataTable dtChanged = new DataTable(); String ObjInvestigation = String .Empty; String ObjInvestData = String .Empty; dtChanged = ObjDS.Tables[0].GetChanges(); foreach (DataRow dr in dtChanged.Rows) { for ( int iColCntr = 1; iColCntr { ObjInvestigation = String .Empty; ObjInvestData = String .Empty; if (dr[ "Col" + iColCntr + "Name" , DataRowVersion.Current].ToString() != dr[ "Col" + iColCntr + "Name" , DataRowVersion.Original].ToString()) ObjInvestigation = "UPDATE Investigation SET Col" + iColCntr + "Name = '" + dr[ "Col" + iColCntr + "Name" , DataRowVersion.Current].ToString().Replace( "'" , "''" ) + "' WHERE Col" + iColCntr + "Name = '" + dr[ "Col" + iColCntr + "Name" , DataRowVersion.Original].ToString().Replace( "'" , "''" ) + "' AND Col" + iColCntr + "Value = '" + dr[ "Col" + iColCntr + "Value" , DataRowVersion.Original].ToString() + "'" ; if (dr[ "Col" + iColCntr + "Blank" , DataRowVersion.Current].ToString() != dr[ "Col" + iColCntr + "Blank" , DataRowVersion.Original].ToString()) ObjInvestData = "INSERT INTO InvestData(IPNo, InvColID, InvData) SELECT '" + txtIPNo.Text.Replace( "'" , "''" ) + "','" + dr[ "Col" + iColCntr + "Value" , DataRowVersion.Current].ToString() + "','" + dr[ "Col" + iColCntr + "Blank" , DataRowVersion.Current].ToString() + "'" ; if (! String .IsNullOrEmpty(ObjInvestigation)) if (! String .IsNullOrEmpty(ObjInvestData)) ObjInvestData = ObjInvestData + "; " + ObjInvestigation; else ObjInvestData = ObjInvestigation; if (! String .IsNullOrEmpty(ObjInvestData)) { using (OleDbCommand ObjCommand = new OleDbCommand(ObjInvestData, ObjCon)) { ObjCommand.CommandTimeout = 99999; ObjCommand.CommandType = CommandType.Text; if (ObjCon.State == ConnectionState.Open) ObjCon.Close(); ObjCon.Open(); if ( Convert .ToInt32(ObjCommand.ExecuteScalar()) >= 0) ObjDS.AcceptChanges(); ObjCon.Close(); } } } } }

how to edit and update datagridview in window forms, while changes should reflect in oledb database

Insert Link

Embed YouTube Video

Table Options

Insert Image

Answers (15)