oracle中的构造函数,OracleDataAdapter

用指定的 SQL SELECT 语句初始化 OracleDataAdapter 类的新实例。Initializes a new instance of the OracleDataAdapter class with the specified SQL SELECT statement.

public:

OracleDataAdapter(System::Data::OracleClient::OracleCommand ^ selectCommand);

public OracleDataAdapter (System.Data.OracleClient.OracleCommand selectCommand);

new System.Data.OracleClient.OracleDataAdapter : System.Data.OracleClient.OracleCommand -> System.Data.OracleClient.OracleDataAdapter

Public Sub New (selectCommand As OracleCommand)

参数

selectCommand

An OracleCommand that is an SQL SELECT statement or stored procedure, and is set as the SelectCommand property of the OracleDataAdapter.

示例

The following example creates an OracleDataAdapter and sets some of its properties.

Public Sub CreateOracleDataAdapter()

Dim myOracleConnection As OracleConnection = New OracleConnection("Data Source=Oracle8i;Integrated Security=yes")

Dim myOracleCommand As OracleCommand = New OracleCommand("SELECT DeptNo, DName FROM Dept", myOracleConnection)

Dim custDA As OracleDataAdapter = New OracleDataAdapter(myOracleCommand)

custDA.MissingSchemaAction = MissingSchemaAction.AddWithKey

custDA.InsertCommand = New OracleCommand("INSERT INTO Dept (DeptNo, DName) " & _

"VALUES (:pDeptNo, :pDName)", myOracleConnection)

custDA.UpdateCommand = New OracleCommand("UPDATE Dept SET DeptNo = :pDeptNo, DName = :pDName " & _

"WHERE DeptNo = :pDeptNo", myOracleConnection)

custDA.DeleteCommand = New OracleCommand("DELETE FROM Dept WHERE DeptNo = :pDeptNo", myOracleConnection)

custDA.InsertCommand.Parameters.Add("pDeptNo", OracleType.Number, 2, "DeptNo")

custDA.InsertCommand.Parameters.Add("pDName", OracleType.VarChar, 14, "DName")

custDA.UpdateCommand.Parameters.Add("pDeptNo", OracleType.Number, 2, "DeptNo")

custDA.UpdateCommand.Parameters.Add("pDName", OracleType.VarChar, 14, "DName")

custDA.UpdateCommand.Parameters.Add("poldDeptNo", OracleType.Number, 2, "DeptNo").SourceVersion = DataRowVersion.Original

custDA.DeleteCommand.Parameters.Add("pDeptNo", OracleType.Number, 2, "DeptNo").SourceVersion = DataRowVersion.Original

End Sub

public static void CreateOracleDataAdapter()

{

OracleConnection myOracleConnection = new OracleConnection("Data Source=Oracle8i;Integrated Security=yes");

OracleCommand myOracleCommand = new OracleCommand("SELECT DeptNo, DName FROM Dept", myOracleConnection);

OracleDataAdapter custDA = new OracleDataAdapter(myOracleCommand);

custDA.MissingSchemaAction = MissingSchemaAction.AddWithKey;

custDA.InsertCommand = new OracleCommand("INSERT INTO Dept (DeptNo, DName) " +

"VALUES (:pDeptNo, :pDName)", myOracleConnection);

custDA.UpdateCommand = new OracleCommand("UPDATE Dept SET DeptNo = :pDeptNo, DName = :pDName " +

"WHERE DeptNo = :pDeptNo", myOracleConnection);

custDA.DeleteCommand = new OracleCommand("DELETE FROM Dept WHERE DeptNo = :pDeptNo", myOracleConnection);

custDA.InsertCommand.Parameters.Add("pDeptNo", OracleType.Number, 2, "DeptNo");

custDA.InsertCommand.Parameters.Add("pDName", OracleType.VarChar, 14, "DName");

custDA.UpdateCommand.Parameters.Add("pDeptNo", OracleType.Number, 2, "DeptNo");

custDA.UpdateCommand.Parameters.Add("pDName", OracleType.VarChar, 14, "DName");

custDA.UpdateCommand.Parameters.Add("poldDeptNo", OracleType.Number, 2, "DeptNo").SourceVersion = DataRowVersion.Original;

custDA.DeleteCommand.Parameters.Add("pDeptNo", OracleType.Number, 2, "DeptNo").SourceVersion = DataRowVersion.Original;

}

注解

此 OracleDataAdapter 构造函数的实现将 SelectCommand 属性设置为参数中指定的值 selectCommand 。This implementation of the OracleDataAdapter constructor sets the SelectCommand property to the value specified in the selectCommand parameter.

当你创建的实例时 OracleDataAdapter ，以下读/写属性将设置为其默认值，如表中所示。When you create an instance of OracleDataAdapter, the following read/write properties are set to their default values, as shown in the table.

属性Properties

初始值Initial value

MissingMappingAction.Passthrough

MissingSchemaAction.Add

可以通过单独调用属性来更改任何这些属性的值。You can change the value of any of these properties through a separate call to the property.

适用于