C#

Sarafian wrote:

The original question said about rows.

Sarafian wrote:

The only way I can think except from triggers is to have a column something like just updated. Then query for those and just before finishing set the columns to false.

<br />
<br />
string file = "......";<br />
<br />
private void InsertAudio()<br />
<pre>
<small>
{  // creation of queries, source, connections, etc....  

   OleDbCommand cmd = new OleDbCommand(sql, conexion);
   int resultSet;

            try
            {
                conexion.Open();
                resultSet = cmd.ExecuteNonQuery();

                if (resultSet > 0) SearchIDofCreatedRow();
                    
            }
            catch (OleDbException ode)
            {
                MessageBox.Show(ode.ToString(), "Error de Conexion con base de datos");
            }
            finally  {conexion.Close();}
}
</small>
</pre><br />
<br />
<br />
private void SearchIDofCreatedRow()<br />
<pre>
<small>
{
// creation of queries, source, connections, etc....  

   OleDbCommand cmd = new OleDbCommand("SELECT ID FROM audios WHERE file='" + file + "'", conexion);

            try
            {
                conexion.Open();
                int ID = Convert.ToInt32(cmd.ExecuteScalar());
                AddCategoryList(ID);
            }

//catch/finally.....
}
</small>
</pre><br />
<br />
private void AddCategoryList(int ID)<br />
<pre>
<small>
{
//
//Insert into the second table with the retrieved data....
//
}
</small>
</pre> <br />
<br />
daniel sovino

Eddymvp wrote:

Is this possible to do?

gigo2k6 wrote:

i ve a small question how is the following problem posible

gigo2k6 wrote:

How is the following posible
MyTable[1].FunctionFromMyObject();

MyObject mo2=(MyObject)MyTable[1];
mo2.SomeFunction();

gigo2k6 wrote:

this was not what i want.