Database

Hint \Hint\, v. i.
     To make an indirect reference, suggestion, or allusion; to
     allude vaguely to something.

<br />
public void UpdateData()<br />
{<br />
	connDB.Open();<br />
        // I tried to intecept the RowUpdating events, but they never actually occur!<br />
	SubApt.RowUpdating += new OleDbRowUpdatingEventHandler(MyRowUpdateHandler);<br />
<br />
        // Try to find out what the status of the rows in the child table actually is.<br />
	string s = "";<br />
	foreach (DataRow thisRow in m_myDS.Tables["tblSub"].Rows)<br />
        {<br />
		s += thisRow["Key"] + " -> " + thisRow["Field1"] + " " + thisRow.RowState.ToString() + "\n";<br />
                // RowState is ALWAYS Unchanged even though some rows have a proposed value!<br />
		if (thisRow.HasVersion(DataRowVersion.Proposed))<br />
		{<br />
                // The proposed value really is the value it's supposed to be changed to, and the original value<br />
                // really is the original value<br />
			s += thisRow["Field1", DataRowVersion.Original] + " " + thisRow["Field1", DataRowVersion.Proposed] + "\n";<br />
		}<br />
	}<br />
	MessageBox.Show(s);<br />
<br />
        // the main table updates just fine<br />
	MainApt.Update(m_myDS.Tables["tblMain"]);<br />
        // but this does nothing!!! It doesn't matter which way around I update the two tables, or even if I leave<br />
        // out the main table altogether<br />
	SubApt.Update(m_myDS.Tables["tblSub"]);<br />
	connDB.Close();<br />
}<br />

<br />
m_myDS.Tables["subtable"].Rows[0]["Field1"] = 101;<br />

<br />
SQLUpdate = "UPDATE myTable SET Field1 = @Field1, Date = @Date, WHERE Key = @Key";<br />

<br />
OleDbCommand myCmd = new OleDbCommand(SQLUpdate,myConnection);<br />
myCmd.Parameters.Add("@Field1", OleDbType.VarWChar, 20, "Field1");<br />
myCmd.Parameters.Add("@Date", OleDbType.Date, 0, "Date");<br />
<br />
myApt.UpdateCommand = myCmd;<br />