470,612 Members | 2,505 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,612 developers. It's quick & easy.

.net 2.0 and typed dataset ?

Hey
Will be in .net 2.0 any nice way to use stored procedures and get typed
dataset ?
Jarod

Nov 17 '05 #1
9 1280
Jarod,

Click on the generated dataset in the dataadapter part.

I hope this helps,

Cor
Nov 17 '05 #2
Check out this link http://msdn2.microsoft.com/en-us/library/04y282hb

"Jarod" <bl*****@NOSPAM.gazeta.pl> wrote in message
news:eJ**************@tk2msftngp13.phx.gbl...
Hey
Will be in .net 2.0 any nice way to use stored procedures and get typed
dataset ?
Jarod

Nov 17 '05 #3
Jarod,

In .NET 2.0 (or rather, Visual Studio .NET 2.0), you will be able to
drag your stored procedures into your design surface, and it will create
managed wrappers for them. It's definitely a nice feature.

Hope this helps.
--
- Nicholas Paldino [.NET/C# MVP]
- mv*@spam.guard.caspershouse.com

"Jarod" <bl*****@NOSPAM.gazeta.pl> wrote in message
news:eJ**************@tk2msftngp13.phx.gbl...
Hey
Will be in .net 2.0 any nice way to use stored procedures and get typed
dataset ?
Jarod

Nov 17 '05 #4
ok, we can do this by drag and drop a "select" stored procedure. how about
if we want to use stored procedures for insert and update as well? how about
our "select" stored procedure includes some logic (case when or if
statements based on some parameter etc.) ? how about if we dont want always
get same column set? do we have to generate, for each set of columns,
another dataset? i think VS.NET is not powerful enough when it cames to
dataset - dataadapter stuff. more generally .NET platform is not powerfull
enough to build an "true domain model" (kinda Business Object Layer). im
waiting for object spaces untill 2007 :/ BTW ive heard Anders Hejlsberg is
working on Object Spaces? is it true?
Nov 17 '05 #5
See inline:

how about if we want to use stored procedures for insert and update as well?

It will support that as well. VS.NET doesn't care what you want to do
with your stored procedure, they are all accessed the same way (pass
parameters, execute, get results). They are all treated the same way.

how about our "select" stored procedure includes some logic (case when or if
statements based on some pparameter etc.)?

See above. VS.NET 2005 will generate the wrapper, along with methods to
call the procedure (it will create a parameter list which mimics the stored
procedure parameter list).

how about if we dont want always get same column set? do we have to
generate, for each set of columns, another dataset?

You would have to tweak the code for this. However, this is a result of
bad design on the part of the stored procedure, not a limitation in VS.NET
2005. It's like returning object from a method, you could do it, and return
any type you like, but what use is it? It's better to have well-defined
result sets.

i think VS.NET is not powerful enough when it cames to dataset - dataadapter
stuff. more generally .NET platform is not powerfull enough to build an
"true domain model" (kinda Business Object Layer). im waiting for object
spaces untill 2007 :/

I think this is debatable. Needless to say, I strongly disagree with
business objects in a sense (espectially when there is a need for
transactions, given their nature).

BTW ive heard Anders Hejlsberg is working on Object Spaces? is it true?

No, he is not. For all intents and purposes, ObjectSpaces is dead.
Now, it is going to be LINQ, or more specifcally, DLINQ, for working with
database servers. It's in the preliminary stages, so it's hard to say how
it will work, and won't be out for a while.
--
- Nicholas Paldino [.NET/C# MVP]
- mv*@spam.guard.caspershouse.com
Nov 17 '05 #6
sorry i was talking about typed dataset's that is generated by visual
studio, when you drag and drop stored procedure.
Nov 17 '05 #7
As was I.

--
- Nicholas Paldino [.NET/C# MVP]
- mv*@spam.guard.caspershouse.com

"The Crow" <q> wrote in message
news:O3**************@TK2MSFTNGP09.phx.gbl...
sorry i was talking about typed dataset's that is generated by visual
studio, when you drag and drop stored procedure.

Nov 17 '05 #8
i think u r talking about stored procedure wrapper comimg with vs2005.

It will support that as well. VS.NET doesn't care what you want to do
with your stored procedure, they are all accessed the same way (pass
parameters, execute, get results). They are all treated the same way.
please tell me the answers applied to VS2003. how to specify typed dataset
to use custom stored procedures and take a custom action(espesially based on
return value)?on custom situations how to call paramtered version of stored
procedure and send parameter ? i wish data manuplation and business logic
were just as easy as VS thinks. its not just filling and updating
datasource. and one more question, how about retrieving particular record(s)
with only particular detail records, and travelling between records? dataset
tastes me as an huge datasource, database's on memory implementation, so i
dont like to use dataset when working with particular records. for example,
when i fill a customer and only orders of customer given in a particular
date, having 1 dataset, 2 datatables in it and using customer.Orders[0]
notation is awfull i think. but in case of datasource is completely in
memory, its perfect to be able write something like order.Parent.. hopefully
i told my thoughts clearly.
Nov 17 '05 #9
i meant "in an object oriented fashion" in my questions.
Nov 17 '05 #10

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by Linesh Gajera | last post: by
1 post views Thread by Trond | last post: by
3 posts views Thread by Freeon | last post: by
8 posts views Thread by Harry Strybos | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.