C#3.5+ORACLE8i和VB6.0+ORACLE8i

最新推荐文章于 2023-10-07 20:27:19 发布

donghaima

最新推荐文章于 2023-10-07 20:27:19 发布

阅读量803

点赞数

CC 4.0 BY-SA版权

分类专栏： SQL 文章标签： oracle vb c# dataset textbox security

本文链接：https://blog.youkuaiyun.com/donghaima/article/details/3021554

SQL 专栏收录该内容

30 篇文章

订阅专栏

本文提供了使用Oracle进行数据插入及更新的示例代码，包括不带事务和带事务的两种情况，采用C#和VB.NET两种语言实现。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

OracleConnection oracleConnection = new OracleConnection(@"Data Source=lys;Persist Security Info=True;User ID=system;Password=manager;Unicode=True");

try
{
oracleConnection.Open();

//OracleCommand oracleCommand = new OracleCommand("insert into test2 (name) values ('" + TextBox1.Text.Trim() + "')", oracleConnection);
//oracleCommand.ExecuteNonQuery();

    DataSet dataSet = new DataSet();
    OracleDataAdapter oracleDataAdapter = new OracleDataAdapter("SELECT * FROM TEST2", oracleConnection);
    OracleCommandBuilder oralceCommandBuilder = new OracleCommandBuilder(oracleDataAdapter);
    oracleDataAdapter.Fill(dataSet);

DataRow newDataRow = dataSet.Tables[0].NewRow();

newDataRow["name"] = "一寸血";

    dataSet.Tables[0].Rows.Add(newDataRow);
    oracleDataAdapter.Update(dataSet);
}
finally
{
    oracleConnection.Close();
}

//带事务的

OracleConnection oracleConnection = new OracleConnection(@"Data Source=lys;Persist Security Info=True;User ID=system;Password=manager;Unicode=True");
try
{

oracleConnection.Open();

    //OracleCommand oracleCommand = new OracleCommand("insert into test2 (name) values ('" + TextBox1.Text.Trim() + "')", oracleConnection);
    //oracleCommand.Transaction= oracleConnection.BeginTransaction();
    //oracleCommand.ExecuteNonQuery();
    //oracleCommand.Transaction.Commit();

DataSet dataSet = new DataSet();

    OracleDataAdapter oracleDataAdapter = new OracleDataAdapter("SELECT * FROM TEST2", oracleConnection);
    oracleDataAdapter.SelectCommand.Transaction = oracleConnection.BeginTransaction();
    OracleCommandBuilder oralceCommandBuilder = new OracleCommandBuilder(oracleDataAdapter);
    oracleDataAdapter.Fill(dataSet);

DataRow newDataRow = dataSet.Tables[0].NewRow();
newDataRow["name"] = TextBox1.Text.Trim();

    dataSet.Tables[0].Rows.Add(newDataRow);
    oracleDataAdapter.Update(dataSet);
    oracleDataAdapter.SelectCommand.Transaction.Commit();

}
finally
{
oracleConnection.Close();
}

Dim oConn As New ADODB.Connection
Dim oRs As New ADODB.Recordset

oConn.ConnectionTimeout = 0
oConn.Open "Provider=MSDAORA.1;Password=manager;User ID=system;Data Source=lys;Persist Security Info=True"
oConn.CommandTimeout = 0

oRs.CursorLocation = adUseClient
oRs.Open "SELECT * FROM TEST2", oConn, adOpenKeyset, adLockPessimistic
oRs.AddNew
oRs("NAME") = Trim(Text1.Text)
oRs.Update

oRs.Close
oConn.Close
Set oRs = Nothing
Set oConn = Nothing

'带事务
Dim oConn As New ADODB.Connection
Dim oRs As New ADODB.Recordset

oConn.ConnectionTimeout = 0
oConn.Open "Provider=MSDAORA.1;Password=manager;User ID=system;Data Source=lys;Persist Security Info=True"
oConn.CommandTimeout = 0
oConn.BeginTrans

On Error GoTo ErrorHandler
oRs.CursorLocation = adUseClient
oRs.Open "SELECT * FROM TEST2", oConn, adOpenKeyset, adLockPessimistic
oRs.AddNew
oRs("NAME") = Trim(Text1.Text)
oRs.Update
oConn.CommitTrans

oRs.Close
oConn.Close
Set oRs = Nothing
Set oConn = Nothing
Exit Sub

ErrorHandler:
oConn.RollbackTrans
End Sub