Modifying Existing Data

[MikeY]

Hi everyone,

Using C#, Windows forms. I am trying to learn how to modify existing data
with in MSDE table/fields. If anyone could help me out with my code, I would
appreciate it. My code is as follows:

private void btnEmpModify_Cl ick(object sender, System.EventArg s e)
{
DataTable thisTable = dsModifyRecord. Tables["Employee"];
//THIS IS WHERE I'M GETTING LOST
DataRow thisRow = thisTable?????? ?????????

thisRow["EmplNumber "] = txtBoxEmplNumbe r.Text;
thisRow["EmpFName"] = txtBoxEmpFName. Text;
thisRow["EmpLName"] = txtBoxLNName.Te xt;
thisRow["DateModifi ed"] = DateTime.Now.To String();
thisRow["EmployeeNo tes"] = txtBoxEmpNotes. Text;

//& GETTING LOST HERE
dsModifyRecord. Tables["EMPLOYEE"]??????????????
sqlDataAdapter1 .Update(dsModif yRecord, "Employee") ;
}

Thank you all in advance.

MikeY

[Chris Capel]

thisRow = thisTable.Rows[indexOfRowToMod ify];

Keep in mind that data shown in any databound control should be in the same
order as in the table, so there's a direct mapping of row indices.

Chris

"MikeY" <mi*******@yaho o.ca> wrote in message
news:eM******** ******@TK2MSFTN GP12.phx.gbl...

Hi everyone,

Using C#, Windows forms. I am trying to learn how to modify existing data
with in MSDE table/fields. If anyone could help me out with my code, I would appreciate it. My code is as follows:

private void btnEmpModify_Cl ick(object sender, System.EventArg s e)
{
DataTable thisTable = dsModifyRecord. Tables["Employee"];
//THIS IS WHERE I'M GETTING LOST
DataRow thisRow = thisTable?????? ?????????

thisRow["EmplNumber "] = txtBoxEmplNumbe r.Text;
thisRow["EmpFName"] = txtBoxEmpFName. Text;
thisRow["EmpLName"] = txtBoxLNName.Te xt;
thisRow["DateModifi ed"] = DateTime.Now.To String();
thisRow["EmployeeNo tes"] = txtBoxEmpNotes. Text;

//& GETTING LOST HERE
dsModifyRecord. Tables["EMPLOYEE"]??????????????
sqlDataAdapter1 .Update(dsModif yRecord, "Employee") ;
}

Thank you all in advance.

MikeY

[MikeY]

Hi Chris,

Thank you for information.
However this is still a little fuzzey. I will look for an example. Where it
is being fuzzy is that if at run time, if I don't know what row I will be
modifying, then how do I write the syntex for that particular row ahead of
time.

Txs again
MikeY

"Chris Capel" <ch***@nowhere. com> wrote in message
news:e2******** ******@TK2MSFTN GP12.phx.gbl...

thisRow = thisTable.Rows[indexOfRowToMod ify];

Keep in mind that data shown in any databound control should be in the same order as in the table, so there's a direct mapping of row indices.

Chris

"MikeY" <mi*******@yaho o.ca> wrote in message
news:eM******** ******@TK2MSFTN GP12.phx.gbl...

Hi everyone,

Using C#, Windows forms. I am trying to learn how to modify existing data with in MSDE table/fields. If anyone could help me out with my code, I

would

appreciate it. My code is as follows:

private void btnEmpModify_Cl ick(object sender, System.EventArg s e)
{
DataTable thisTable = dsModifyRecord. Tables["Employee"];
//THIS IS WHERE I'M GETTING LOST
DataRow thisRow = thisTable?????? ?????????

thisRow["EmplNumber "] = txtBoxEmplNumbe r.Text;
thisRow["EmpFName"] = txtBoxEmpFName. Text;
thisRow["EmpLName"] = txtBoxLNName.Te xt;
thisRow["DateModifi ed"] = DateTime.Now.To String();
thisRow["EmployeeNo tes"] = txtBoxEmpNotes. Text;

//& GETTING LOST HERE
dsModifyRecord. Tables["EMPLOYEE"]??????????????
sqlDataAdapter1 .Update(dsModif yRecord, "Employee") ;
}

Thank you all in advance.

MikeY