C# codetry
{
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