如题所示:
在pl sql developer或者别的sql edit中都能查到该字段的值但是在.net中通过以下语句执行后却显示为"". dbAdapt = New OracleDataAdapter '===== SELECT文をCommandオブジェクトへ =====
dbCommand = New OracleCommand(strSql, getConnection(sessionID))
dbCommand.CommandType = CommandType.Text '===== DataAdapterオブジェクト作成(データセットの前準備) =====
dbAdapt.SelectCommand = dbCommand
dbAdapt.Fill(dsRet)这时dsret中的该字段为空求解决办法!!!!!!!!!!!!!!!!!!!!!!
在pl sql developer或者别的sql edit中都能查到该字段的值但是在.net中通过以下语句执行后却显示为"". dbAdapt = New OracleDataAdapter '===== SELECT文をCommandオブジェクトへ =====
dbCommand = New OracleCommand(strSql, getConnection(sessionID))
dbCommand.CommandType = CommandType.Text '===== DataAdapterオブジェクト作成(データセットの前準備) =====
dbAdapt.SelectCommand = dbCommand
dbAdapt.Fill(dsRet)这时dsret中的该字段为空求解决办法!!!!!!!!!!!!!!!!!!!!!!
insert into t select 1 from dual;
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim adocn As System.Data.OracleClient.OracleConnection Dim adocmd As System.Data.OracleClient.OracleCommand
Dim adoada As System.Data.OracleClient.OracleDataAdapter
Dim dt As System.Data.DataTable adocn = New System.Data.OracleClient.OracleConnection()
adocmd = New System.Data.OracleClient.OracleCommand()
adoada = New System.Data.OracleClient.OracleDataAdapter()
dt = New System.Data.DataTable() adocn.ConnectionString = "Data Source=xsjly;User Id=jly;Password=jly;"
adocn.Open()
adocmd.Connection = adocn
adocmd.CommandType = CommandType.Text
adocmd.CommandText = "select * from t"
adoada.SelectCommand = adocmd
adoada.Fill(dt)
Me.DataGridView1.DataSource = dt
adocn.Close() End Sub
因为我的方法和你的写法一样
可以通过sql plus查询出来数据,但是通过程序就不行。
还有其他的方法么??谢谢。