public int UpdateDataTable1(string sql, System.Data.DataTable dt, System.Data.OracleClient.OracleDataAdapter sda)
{
int i = 0;
try
{
System.Data.OracleClient.OracleCommandBuilder builder = new System.Data.OracleClient.OracleCommandBuilder(sda);
sda.UpdateCommand = builder.GetUpdateCommand();
if (dt.GetChanges() != null)
{
i = sda.Update(dt);
dt = GetDataTable(sql);
}
}
catch (Exception ex)
{
MessageBox.Show("Error:" + ex.Message.ToString());
return(-1);
}
return(i);
}