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

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

what problem you facing now?

no , it is still not solved.

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

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.

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.

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

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.

Hi ram,
I am attaching the source file.

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.

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.

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

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

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

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();
}
}
}
}

}