在oracle数据库中存储数据的问题 [英] problem a storing data in oracle database

问题描述

尊重所有，

我正在尝试使用我的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")

推荐答案

试试这个，它可能有所帮助

Try this, it might help

 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数据库中存储数据的问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！