 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
.NET Forum / Windows Forms / WinForm General / February 2007Output parameter in Typed Dataset
I am using Typed Datasets in VS2005 based on SQL Stored Procedures. When I do an Insert (using an Insert Procedure), I have set the SP to return a new ID number. However, I don't know how to reference that returned value to populate the Identity field on my Windows form. I'm pretty new to VB.NET - actually to almost all VB (came from VBA in Access 2003). So, speak slowly and use small words and sentences. Thanks for any help.  SignatureCurt Gough 123cgough@kcumb.edu Remove 123 from above address to mail directly Did you figure out how to resolve this yet? Robin S. ------------------------ >I am using Typed Datasets in VS2005 based on SQL Stored Procedures. When I >do an Insert (using an Insert Procedure), I have set the SP to return a >new ID number. However, I don't know how to reference that returned value >to populate the Identity field on my Windows form. I'm pretty new to >VB.NET - actually to almost all VB (came from VBA in Access 2003). So, >speak slowly and use small words and sentences. Thanks for any help. No. Not yet, Robin. The books and online documentation I find offer little help, too. It is frustrating. Thanks for responding. SignatureCurt Gough 123cgough@kcumb.edu Remove 123 from above address to mail directly > Did you figure out how to resolve this yet? > [quoted text clipped - 6 lines] >>VB.NET - actually to almost all VB (came from VBA in Access 2003). So, >>speak slowly and use small words and sentences. Thanks for any help. Okay, I'll look at it and see if I can figure it out. Maybe strongly typed datasets don't allow you to pick up an output parameter? So you're using stored procs to select, insert, etc., and you're using typed datasets, right? Did you specify any info about an output parameter in the typed dataset definition? Robin S. Ts'i mahnu uterna ot twan ot geifur hingts uto. ----------------------------------------------- > No. Not yet, Robin. The books and online documentation I find offer > little help, too. It is frustrating. Thanks for responding. [quoted text clipped - 9 lines] >>>to VB.NET - actually to almost all VB (came from VBA in Access 2003). >>>So, speak slowly and use small words and sentences. Thanks for any help. No, I didn't, mainly because I'm not sure how to retrieve it, or how to even reference it. SignatureCurt Gough 123cgough@kcumb.edu Remove 123 from above address to mail directly > Okay, I'll look at it and see if I can figure it out. Maybe strongly typed > datasets don't allow you to pick up an output parameter? [quoted text clipped - 21 lines] >>>>to VB.NET - actually to almost all VB (came from VBA in Access 2003). >>>>So, speak slowly and use small words and sentences. Thanks for any help. Well, you *can* add an output parameter to a strongly typed dataset. Assuming you have a strongly typed dataset, click on the table adapter that was generated. Then over in the properties, pick your Insert command (for example) and click on the (...) next to Parameters. On that screen, you can change the parameter's direction. Presumably if you do that, it will have some method in the generated code that gets that output parameter. Take a look at it and see where you get from there. Robin S. ------------------------------------------- > No, I didn't, mainly because I'm not sure how to retrieve it, or how to > even reference it. [quoted text clipped - 25 lines] >>>>>Access 2003). So, speak slowly and use small words and sentences. >>>>>Thanks for any help.
Free MagazinesGet these publications absolutely FREE for up to 12 months. There are no hidden fees and no obligation. Simply choose a title, complete the application form and submit it. Read more ...
|
Reply to this Message
|
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.