problem a storing data in oracle database

Question

0.00/5 (No votes)

See more:

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."

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

VB

sql = "select * from shift_detail";
        ds = New DataSet
        da = New OracleDataAdapter(sql, cn)
        da.Fill(ds, &quot;save&quot;)
        cn.Close()
        Dim cb As New OracleCommandBuilder(da)
        Dim dsNewRow As DataRow

        dsNewRow = ds.Tables(&quot;save&quot;).NewRow()

        dsNewRow.Item(&quot;shift_no&quot;) = newno(&quot;Select max(shift_no) from shift_detail&quot;)
        dsNewRow.Item(&quot;shift_nm&quot;) = shift_name
        dsNewRow.Item(&quot;edate&quot;) = dt
        dsNewRow.Item(&quot;status&quot;) = &quot;R&quot;
        dsNewRow.Item(&quot;code&quot;) = shift_code


        ds.Tables(&quot;save&quot;).Rows.Add(dsNewRow)
        da.Update(ds, &quot;save&quot;)

Posted 30-Aug-12 20:25pm

Avi Mali

Updated 30-Aug-12 20:33pm

Mehdi Gholam

v2

Add a Solution

Comments

ZurdoDev 31-Aug-12 8:33am

You need to find which line of code is give you the first error. It's just telling you something is not set yet or you are trying to access a column that is not there.

Avi Mali 31-Aug-12 9:02am

when my debugger is going to ds.Tables("save").Rows.Add(dsNewRow) line that time firs error is occur. My all column names are correct.

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Banerjee Tanmoy · Answer 1 · 2013-01-09T19:23:00

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