PLEASE tell me how to handle RowUpdated with/against a typed dataset

  • Thread starter Thread starter Scott F.
  • Start date Start date
S

Scott F.

I have searched and searched and searched and sear.. anyway, you get
the idea.

I am trying desperately to figure out how, in "C++/CLI" (Managed
C++/2005) to handle the RowUpdated event in my code but can not find an
answer that works. I either get the always fun "error C3767:
'FrameWorks::eclipseDataSetTableAdapters::RepairDataTableAdapter::Adapter::get':
candidate function(s) not accessible" error, or other various errors.
Apparently, my strongly typed RepairDataTableAdapter does NOT expose
anything that even looks like RowUpdated.

So, given that, I thought ok, I'll do it the hard way, and try to deal
with this with untyped .. objects. So I've tried to create an adapter
that would expose RowUpdated, but then I wanted to get the existing
insert, update, ... commands from my typed adapter so that I wouldn't
completely redo all my database code. Well, that didn't work either
because those objects are also not exposed. Not even read-only!
This is what led to the error above.

Is there SOMEONE, ANYONE out there who can tell me how the frell to
handle RowUpdated with a typed adapter? I'm begging here.

Thanks,
Scott "Cmdr. Beavis" F.
 
Hi Scott,

If you have to you could use reflection to get to the private property
Adapter.
Note that your application needs adequate permission to use reflection.
 
Humm, well, Reflection is a subject I'm still not all that up to speed
on, so maybe I'm talking out my rear here, but that seems like a lot of
work for something that SHOULD be a simple matter... as long as you
know how to deal with typed datasets properly. I guess I just can't
belive that the RowUpdated event isn't exposed via the typed ds. :/

Too bad the Typed DataSet(s) help.. isn't [helpful].

-S
Hi Scott,

If you have to you could use reflection to get to the private property
Adapter.
Note that your application needs adequate permission to use reflection.

--
Miha Markic [MVP C#]
RightHand .NET consulting & development www.rthand.com
Blog: http://cs.rthand.com/blogs/blog_with_righthand/

Scott F. said:
I have searched and searched and searched and sear.. anyway, you get
the idea.

I am trying desperately to figure out how, in "C++/CLI" (Managed
C++/2005) to handle the RowUpdated event in my code but can not find an
answer that works. I either get the always fun "error C3767:
'FrameWorks::eclipseDataSetTableAdapters::RepairDataTableAdapter::Adapter::get':
candidate function(s) not accessible" error, or other various errors.
Apparently, my strongly typed RepairDataTableAdapter does NOT expose
anything that even looks like RowUpdated.

So, given that, I thought ok, I'll do it the hard way, and try to deal
with this with untyped .. objects. So I've tried to create an adapter
that would expose RowUpdated, but then I wanted to get the existing
insert, update, ... commands from my typed adapter so that I wouldn't
completely redo all my database code. Well, that didn't work either
because those objects are also not exposed. Not even read-only!
This is what led to the error above.

Is there SOMEONE, ANYONE out there who can tell me how the frell to
handle RowUpdated with a typed adapter? I'm begging here.

Thanks,
Scott "Cmdr. Beavis" F.
Click to expand...
Click to expand...
 
Don't mix typed datasets and typed adapters.

--
Miha Markic [MVP C#]
RightHand .NET consulting & development www.rthand.com
Blog: http://cs.rthand.com/blogs/blog_with_righthand/

Scott F. said:
Humm, well, Reflection is a subject I'm still not all that up to speed
on, so maybe I'm talking out my rear here, but that seems like a lot of
work for something that SHOULD be a simple matter... as long as you
know how to deal with typed datasets properly. I guess I just can't
belive that the RowUpdated event isn't exposed via the typed ds. :/

Too bad the Typed DataSet(s) help.. isn't [helpful].

-S
Hi Scott,

If you have to you could use reflection to get to the private property
Adapter.
Note that your application needs adequate permission to use reflection.

--
Miha Markic [MVP C#]
RightHand .NET consulting & development www.rthand.com
Blog: http://cs.rthand.com/blogs/blog_with_righthand/

Scott F. said:
I have searched and searched and searched and sear.. anyway, you get
the idea.

I am trying desperately to figure out how, in "C++/CLI" (Managed
C++/2005) to handle the RowUpdated event in my code but can not find an
answer that works. I either get the always fun "error C3767:
'FrameWorks::eclipseDataSetTableAdapters::RepairDataTableAdapter::Adapter::get':
candidate function(s) not accessible" error, or other various errors.
Apparently, my strongly typed RepairDataTableAdapter does NOT expose
anything that even looks like RowUpdated.

So, given that, I thought ok, I'll do it the hard way, and try to deal
with this with untyped .. objects. So I've tried to create an adapter
that would expose RowUpdated, but then I wanted to get the existing
insert, update, ... commands from my typed adapter so that I wouldn't
completely redo all my database code. Well, that didn't work either
because those objects are also not exposed. Not even read-only!
This is what led to the error above.

Is there SOMEONE, ANYONE out there who can tell me how the frell to
handle RowUpdated with a typed adapter? I'm begging here.

Thanks,
Scott "Cmdr. Beavis" F.
Click to expand...
Click to expand...
Click to expand...
 
Don't mix typed datasets and typed adapters?! That doesn't even make
sense... you get typed adapters when you create a typed dataset, no?

Let me ask this this way; if you look at "
ms-help://MS.VSCC.v80/MS.MSDN.v80/MS.VisualStudio.v80.en/WD_ADONET/html/d6b7f9cb-81be-44e1-bb94-56137954876d.htm
" under "Retrieving Microsoft Access Autonumber Values", it talks all
about how you need to handle the RowUpdated event in order to do
Autonumber columns properly with Access tables. Is there a way to do
all of that with a typed dataset/dataAdapter?

Now, if the answer is no... well, I guess this is a topic for a
seperate thread. I tried to, again, following the help in MSDN, use
their sample code (C# is all they give, no C++/CLI so I translate as
best I can) to create the connection etc. using the OleDb* objects,
then create a SELECT command via the OleDbCommandBuilder object and the
darn thing never generated my INSERT, UPDATE, or DELETE commands. I'm
at my wit's end here.

-S
Don't mix typed datasets and typed adapters.

--
Miha Markic [MVP C#]
RightHand .NET consulting & development www.rthand.com
Blog: http://cs.rthand.com/blogs/blog_with_righthand/

Scott F. said:
Humm, well, Reflection is a subject I'm still not all that up to speed
on, so maybe I'm talking out my rear here, but that seems like a lot of
work for something that SHOULD be a simple matter... as long as you
know how to deal with typed datasets properly. I guess I just can't
belive that the RowUpdated event isn't exposed via the typed ds. :/

Too bad the Typed DataSet(s) help.. isn't [helpful].

-S
Hi Scott,

If you have to you could use reflection to get to the private property
Adapter.
Note that your application needs adequate permission to use reflection.

--
Miha Markic [MVP C#]
RightHand .NET consulting & development www.rthand.com
Blog: http://cs.rthand.com/blogs/blog_with_righthand/

I have searched and searched and searched and sear.. anyway, you get
the idea.

I am trying desperately to figure out how, in "C++/CLI" (Managed
C++/2005) to handle the RowUpdated event in my code but can not find an
answer that works. I either get the always fun "error C3767:
'FrameWorks::eclipseDataSetTableAdapters::RepairDataTableAdapter::Adapter::get':
candidate function(s) not accessible" error, or other various errors.
Apparently, my strongly typed RepairDataTableAdapter does NOT expose
anything that even looks like RowUpdated.

So, given that, I thought ok, I'll do it the hard way, and try to deal
with this with untyped .. objects. So I've tried to create an adapter
that would expose RowUpdated, but then I wanted to get the existing
insert, update, ... commands from my typed adapter so that I wouldn't
completely redo all my database code. Well, that didn't work either
because those objects are also not exposed. Not even read-only!
This is what led to the error above.

Is there SOMEONE, ANYONE out there who can tell me how the frell to
handle RowUpdated with a typed adapter? I'm begging here.

Thanks,
Scott "Cmdr. Beavis" F.
Click to expand...
Click to expand...
Click to expand...
 
Not necessarily. They are separate features though appearing in the same
project item. TableAdapters are just some sort of helpers. And while I agree
TableAdapters are useful for simple tasks only, the strong typed datasets
are fully functional, very useful and independent from TableAdapters or any
adapter.

--
Miha Markic [MVP C#]
RightHand .NET consulting & development www.rthand.com
Blog: http://cs.rthand.com/blogs/blog_with_righthand/

Scott F. said:
Don't mix typed datasets and typed adapters?! That doesn't even make
sense... you get typed adapters when you create a typed dataset, no?
Click to expand...

Not necessarily. They are separate features though appearing in the same
project item. TableAdapters are just some sort of helpers. And while I agree
TableAdapters are useful for simple tasks only, the strong typed datasets
are fully functional, very useful and independant from TableAdapters or any
adapter.
 
Back
Top