Updating Oracle Datasets

[Parveen]

I am having trouble setting the update command of my oracle adapter to the name of an Oracle
stored procedure. My data adapter is a global variable that I use in multiple functions.
But the following line of code

g_Da.UpdateCommand.CommandType = CommandType.StoredProcedur

Generates this error
System.NullReferenceException: Object reference not set to an instance of an object

Does anyone know why? Can someone tell me how I can successful set the update command of my
data adapter to my stored procedure

Thanks for your help

Parveen

[Armin Zingler]

"Parveen" <an*******@discussions.microsoft.com> schrieb

I am having trouble setting the update command of my oracle adapter
to the name of an Oracle stored procedure. My data adapter is a
global variable that I use in multiple functions. But the following
line of code:

g_Da.UpdateCommand.CommandType = CommandType.StoredProcedure

Generates this error:
System.NullReferenceException: Object reference not set to an
instance of an object.

Does anyone know why? Can someone tell me how I can successful set
the update command of my data adapter to my stored procedure?

Either you didn't create a DataAdapter, or you didn't create an
UpdateCommand.

--
Armin

http://www.plig.net/nnq/nquote.html
http://www.netmeister.org/news/learn2quote.html

[Herfried K. Wagner [MVP]]

* "=?Utf-8?B?UGFydmVlbg==?=" <an*******@discussions.microsoft.com> scripsit:

I am having trouble setting the update command of my oracle adapter to the name of an Oracle
stored procedure. My data adapter is a global variable that I use in multiple functions.
But the following line of code:

g_Da.UpdateCommand.CommandType = CommandType.StoredProcedure

Generates this error:
System.NullReferenceException: Object reference not set to an instance of an object.

Are you sure you assigned something to the 'UpdateCommand' property?

--
Herfried K. Wagner [MVP]
<http://www.mvps.org/dotnet>

[Armin Zingler]

"Herfried K. Wagner [MVP]" <hi***************@gmx.at> schrieb

g_Da.UpdateCommand.CommandType = CommandType.StoredProcedure

Generates this error:
System.NullReferenceException: Object reference not set to an
instance of an object.

Are you sure you assigned something to the 'UpdateCommand'
property?

"yes, but it does not work:"

g_da.UpdateCommand = Something

--
Armin

[Cor]

Parveen, dont take attention to it, this is just about the word "something"

Hi Armin,

Are you sure you assigned something to the 'UpdateCommand'
property?

g_da.UpdateCommand = Something

I think this would be a very big error.

I would like it if there was in VB a statement as
If x Is Something (with an uppercase)

And therefore the message from Herfried with a lowercase is in my eyes very
correct.

:-))

Cor

[Armin Zingler]

"Cor" <no*@non.com> schrieb

Parveen, dont take attention to it, this is just about the word
"something"

Thx. :)

Are you sure you assigned something to the 'UpdateCommand'
property?

g_da.UpdateCommand = Something

I think this would be a very big error.

I would like it if there was in VB a statement as
If x Is Something (with an uppercase)

And therefore the message from Herfried with a lowercase is in my
eyes very correct.

:-))

:)

Won't there be the IsNot operator in the next version?

if x IsNot Nothing then
--
Armin

[Cor]

Hi Armin,

if x IsNot Nothing then

I am one of the few, but I hope not because this is also then possible

if Not x IsNot Nothing then

brrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrr

I keep going in this newsgroup for

if x Is Something

Cor

[Armin Zingler]

"Cor" <no*@non.com> schrieb

Hi Armin,

if x IsNot Nothing then

I am one of the few, but I hope not because this is also then
possible

if Not x IsNot Nothing then

brrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrr

I keep going in this newsgroup for

if x Is Something

But then this is also possible:

If not not x is something then

brrrrrrrr

;-)
--
Armin

[Cor]

Hi Parveen,

Probably you have only to add this line
g_Da = New OracledataAdapter
before line

g_Da.UpdateCommand.CommandType = CommandType.StoredProcedure

Or more probably put the new direct in your clobal g_Da something as
private g_DA as New OracledataAdapter

I hope this helps?

Cor

[Herfried K. Wagner [MVP]]

* "Armin Zingler" <az*******@freenet.de> scripsit:

I keep going in this newsgroup for

if x Is Something

But then this is also possible:

If not not x is something then

Why not both, 'Something' and 'IsNot':

\\\
If x IsNot Something Then...
///

--
Herfried K. Wagner [MVP]
<http://www.mvps.org/dotnet>

[Herfried K. Wagner [MVP]]

* "Armin Zingler" <az*******@freenet.de> scripsit:

Won't there be the IsNot operator in the next version?

if x IsNot Nothing then

Yes.

--
Herfried K. Wagner [MVP]
<http://www.mvps.org/dotnet>

[Cor]

Hi Herfried,

I think because IsNot is again a new keyword.
And if you can avoid them you should do that.

(I know the answer Something is also new, but "something" is a natural word
and IsNot, if you have read something before from me, you know the rest of
my explanation)

Cor

Why not both, 'Something' and 'IsNot':

[Herfried K. Wagner [MVP]]

* "Cor" <no*@non.com> scripsit:

I think because IsNot is again a new keyword.
And if you can avoid them you should do that.
Mhm... I like new keywords if they make sense.
(I know the answer Something is also new, but "something" is a natural word
and IsNot, if you have read something before from me, you know the rest of
my explanation)

Yep -- I would prefer 'Something' too.

--
Herfried K. Wagner [MVP]
<http://www.mvps.org/dotnet>

[Parveen]

Ok...so what do you guys mean when you ask me if I set my UpdateCommand to something?

Wasn't I doing that when I did....

g_Da.UpdateCommand.CommandText = "PCD_HRLY_CODE_ENF_Update"
g_Da.UpdateCommand.CommandType = CommandType.StoredProcedure

The project's blowing up on the first line...do u guys know how i can fix this or can you explain
what you meant by your advice earlier?

Hope I won't cause another controversy!! ;)

Parveen

[Cor]

Hi Parveen,

This was an Off Thread discussion not about the message itself, but about
the answer.
At the start of this OT I did wrote that this was not about your problem.

I did gave an answer before I did that so have a look at that.

But in this newsgroups is Oracle never a topic.

If my answer does not fit you can try it in the newsgroup

Microsoft.public.dotnet.framework.adonet

There is Miha active, with him you have the best change for Oracle problems
I think.

Cor

g_Da.UpdateCommand.CommandText = "PCD_HRLY_CODE_ENF_Update"
g_Da.UpdateCommand.CommandType = CommandType.StoredProcedure

The project's blowing up on the first line...do u guys know how i can fix this or can you explain what you meant by your advice earlier?

[Parveen]

I get past that error message if I add the following line of code before doing anything with the update statement:

myDa.UpdateCommand = New OracleCommand

Thanks for your advice....it led me in the right direction!!

[Parveen]

Yes I know that it was an off thread discussion...and you did mention that...which is totally fine with me

[Herfried K. Wagner [MVP]]

* "=?Utf-8?B?UGFydmVlbg==?=" <an*******@discussions.microsoft.com> scripsit:

Ok...so what do you guys mean when you ask me if I set my UpdateCommand to something?

Wasn't I doing that when I did....

g_Da.UpdateCommand.CommandText = "PCD_HRLY_CODE_ENF_Update"
g_Da.UpdateCommand.CommandType = CommandType.StoredProcedure

What result to you get if you run this code before the 1st line?

\\\
MsgBox((g_Da Is Nothing).ToString())
MsgBox((g_Da.UpdateCommand Is Nothing).ToString())
///

--
Herfried K. Wagner [MVP]
<http://www.mvps.org/dotnet>

[Parveen]

Herfreid,
It works when I insert the following line of code before doing anything with the UpdateCommand:

myDa.UpdateCommand = New OracleCommand

Thanks for your help! :)

Parveen

[Herfried K. Wagner [MVP]]

* "=?Utf-8?B?UGFydmVlbg==?=" <an*******@discussions.microsoft.com> scripsit:

It works when I insert the following line of code before doing anything with the UpdateCommand:

myDa.UpdateCommand = New OracleCommand

That's what I expected.

--
Herfried K. Wagner [MVP]
<http://www.mvps.org/dotnet>