发表于 2009-1-5 19:48
| 
ORACLE 浣跨敤SELECT 甯﹀弬鏁扮殑闂
鍙戝竷: 2008-11-29 17:09 | 浣滆: 缃戠粶杞浇 | 鏉ユ簮: 缃戠粶杞浇 | 鏌ョ湅: 25娆
浣跨敤OracleDataAdapter.Fill鐨勬柟娉曘佷互涓嬫槸SQL鏂囪繍琛岀殑鎯呭喌銆
SQL鏂囷細
select ColA as TitleA, :ColB as TitleB from TableName;
鈥:ColB鏄弬鏁般
鈻DO.NET鐨勫満鍚堬紙System.Data.OracleClient锛夛細
銉讳唬鐮侊細
command.CommandText = "select ColA as TitleA, :ColB as TitleB from TableName"
command.Parameters.Add("ColB", OracleType.VarChar, 20).Value= "2008"
Dim da As OracleDataAdapter = New OracleDataAdapter(command)
Dim dt As DataTable = New DataTable("Test")
da.Fill(dt)
銉荤粨鏋滐細
銆銆鎴愬姛
鈻DP.NET鐨勫満鍚堬紙Oracle.DataAccess.Client锛夛細
銉讳唬鐮侊細
command.CommandText = "select ColA as TitleA, :ColB as TitleB from TableName"
command.Parameters.Add("ColB", OracleDbType.Varchar2, 20, "2008",ParameterDirection.Input)
Dim da As OracleDataAdapter = New OracleDataAdapter(command)
Dim dt As DataTable = New DataTable("Test")
da.Fill(dt)
銉荤粨鏋滐細
渚嬪锛歄RA-01036: 闈炴硶鐨勫彉閲忓悕/缂栧彿銆
鈥诲啀鐝剧挵澧
銉籓racle 10g鍜孫DP.NET 10g
- Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 -32bit Production
- Oracle Data Provider for .NET 2.0 10.2.0.2.21 Production
銉籓racle 11g鍜孫DP.NET 11g
- Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 -64bit Production
- Oracle Database 11g Release 1 Client (11.1.0.6.0) for Microsoft Windows 32bit
- Oracle Data Provider for .NET 2.0 11.1.0.6.20 Production
杩欐槸ODP.NET鐨勯棶棰橈紝鍦ㄤ娇鐢ㄦ椂瑕佹敞鎰忋
