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

16y24.6kLearn iOS Programming

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

15 Replies

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

Suthish Nair16y ago
what problem you facing now?
16y ago
no , it is still not solved.
Suthish Nair16y ago
Please accept the post as answer, if your query is resolved. Thank You.
Sam Hobbs16y ago
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 Nair16y ago
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.
16y ago
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 Hobbs16y ago
Database Table Update in a DataGridView without Writing Code
16y ago
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 Jha16y ago
Hi ram,
I am attaching the source file.
16y ago
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.
16y ago
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 Jha16y ago
Hi ram,
sorry for late response. i am attaching access database file
Sam Hobbs16y ago
Have you looked at the articles listed in the list at the right side of this window?
16y ago
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 Jha16y ago
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 < 6; 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();
}
}
}
}
}