Comments by marjavic (Top 15 by date)

this.mySql.sqlDataAdapter1.InsertCommand.CommandText

= " INSERT INTO statement ";

this.mySql.sqlDataAdapter1.InsertCommand.ExecuteNonQuery();

< this.mySql > is an object of class has the orcaleCommands Initialization {insertCommand , deleteCommand , updateCommand , OracleDataAdapter and my OracleConnection}


i want to override the ExecuteNonQuery() function with an action additional to it's basic function

i don't understand

i need to add an action while the function is execution like this

public override int ExecuteNonQuery()
{
// do some thing;
base.ExecuteNonQuery();
}

but i don't know where i call the override function

thanks alot Mika Wendelius for your help
i already have that solution but that's making overhead on the application couse its dupplicate evry DML operation i was needed to make it in one time.
i make the server ID secondary key so if an operation isn't succeeding i can follow it

i need solution can translate into c# code like make an event on insert command or use the same command to execute into 2 database i don't know if that possible

Thanks alot for your help,
But it also when i try to start sqlBrows service from the c# App. gives me access is denied

ds.WriteXml(Application.StartupPath + @"\reports\\aa.xml", XmlWriteMode.WriteSchema);

the ds has a new dt in evry loop it's not the same value in evry time. But when the reports are shown it was the same with the last ds value, its like reading the xml file before running the show of the report

thanks alot that is what i want ,but how could run it in visual stodio 2008

i want it with vs becouse i istall the sql via vs setup project but like that the database will not have any security an any oe deal with it so i want to make it more secure but i want to deal with the sql just via vs i want my vs project to make evry thing when i install the setup of my project on any machine its run with out the need of install any thing else,so is there any way to make my database more secure like create password on it or change the sa password via vs

where can i find SQL Server 2000 Enterprise Edition (64-bit)

if there is no way to delete it while it's using by a process
is there any way to close any process using the file in visual stodio
then i can delete the file