本文介绍了在oracle数据库中存储数据的问题的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
尊重所有,
我正在尝试使用我的vb.net应用程序在oracle中插入值但是当我运行我的应用程序时,我收到以下错误消息
Respected all,
I am trying to insert values in oracle using my vb.net application but when i run my application then i got following error message
"Object reference not set to an instance of an object."
如果我使用新关键字dim dsNewRow As New DataRow那么我得到了以下错误消息
if i use new keyword to "dim dsNewRow As New DataRow" then i got following error message
"Error 2 'System.Data.DataRow.Protected Friend Sub New(builder As System.Data.DataRowBuilder)' is not accessible in this context because it is 'Protected Friend'."
我能做什么请帮助我
以下是我的代码
what i can do please help me
Following is my code
sql = "select * from shift_detail";
ds = New DataSet
da = New OracleDataAdapter(sql, cn)
da.Fill(ds, "save")
cn.Close()
Dim cb As New OracleCommandBuilder(da)
Dim dsNewRow As DataRow
dsNewRow = ds.Tables("save").NewRow()
dsNewRow.Item("shift_no") = newno("Select max(shift_no) from shift_detail")
dsNewRow.Item("shift_nm") = shift_name
dsNewRow.Item("edate") = dt
dsNewRow.Item("status") = "R"
dsNewRow.Item("code") = shift_code
ds.Tables("save").Rows.Add(dsNewRow)
da.Update(ds, "save")
推荐答案
Public Function InsertData(ByVal SQLString As String) As Integer
strErrorMessage = ""
Dim objCmd As OracleCommand = New OracleCommand
Try
NoofRowsAffected = objCmd.ExecuteNonQuery
Return NoofRowsAffected
Catch ex As Exception
strErrorMessage = "Message :" & ex.Message
Return Nothing
Finally
If Not IsNothing(objCmd) Then
objCmd.Parameters.Clear()
objCmd.Dispose()
objCmd = Nothing
End If
End Function
这篇关于在oracle数据库中存储数据的问题的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!