日期:2014-05-17 浏览次数:21202 次
try 
{ 
oracleConnection1.Open(); 
System.Data.OracleClient.OracleDataAdapter   ora_adp   =   new   System.Data.OracleClient.OracleDataAdapter( "select   *   from   clientregiste ",oracleConnection1); 
  OracleCommandBuilder   objCommandBuilder= 
new   System.Data.OracleClient.OracleCommandBuilder(ora_adp); 
ora_adp   .DeleteCommand   =   objCommandBuilder.GetDeleteCommand(); 
ora_adp   .InsertCommand   =   objCommandBuilder.GetInsertCommand();//如果只是删除操作后更新, 
此句和下面一句可以不要 
ora_adp   .UpdateCommand   =   objCommandBuilder.GetUpdateCommand();// 
DataSet   dstobj   =   new   DataSet(); 
ora_adp.Fill(dstobj, "originally "); 
System.Data.DataRow   row   =   dstobj.Tables[ "originally "].Rows[1]; 
row.Delete(); 
dstobj.AcceptChanges(); 
ora_adp.Update(dstobj, "originally "); 
oracleConnection1.Close(); 
} 
catch(Exception   ora_err) 
{ 
Label1.Text   =   ora_err.Message; 
} 
finally 
{ 
oracleConnection1.Close(); 
}
------解决方案--------------------
试试下面的,再不行的话就得用常规办法了.
  Dim AccessConn As New System.Data.OleDb.OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;" & _
   "Data Source=C:\Test Files\db1 XP.mdb")
       AccessConn.Open()
       'New table
       Dim AccessCommand As New System.Data.OleDb.OleDbCommand("SELECT * INTO [tbl1] FROM [Text;DATABASE=C:\Documents and Settings\...\My Documents\My Database\Text].[tbl1.txt]", AccessConn)
       'Existing table
       'Dim AccessCommand As New System.Data.OleDb.OleDbCommand("INSERT INTO [tbl1] (F1, F2, F3)  SELECT F1, F2, F3 FROM [Text;DATABASE=C:\Documents and Settings\...\My Documents\My Database\Text].[tbl1.txt]", AccessConn)
       AccessCommand.ExecuteNonQuery()
       AccessConn.Close()
  The schema.ini file would look something like following:
[tbl1.txt]
ColNameHeader=False
Format=TabDelimited
CharacterSet=ANSI