 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
.NET Forum / Windows Forms / WinForm General / January 2007Newbie - Getting form data to "refresh"
I am new to WinForms developing - used Access for many years. I have an application using DataSets from Stored Procedures in SQL Server. When users enter new data and click the Save button I can save the record fine by using another SP. But, I want the ID field to update with the new ID for that record. What can I call to make the DataSet update and display the new ID number for the record? Thanks for any help. Is the "Save" SP returning the value of the new ID? -- Bryan Phillips MCSD, MCDBA, MCSE Blog: http://bphillips76.spaces.live.com > I am new to WinForms developing - used Access for many years. I have an > application using DataSets from Stored Procedures in SQL Server. When users [quoted text clipped - 4 lines] > > Thanks for any help. Yes. I have it as an OUTPUT variable in the SP.  SignatureCurt Gough 123cgough@kcumb.edu Remove 123 from above address to mail directly > Is the "Save" SP returning the value of the new ID? > [quoted text clipped - 13 lines] >> >> Thanks for any help. Thank you for the response, but your question does not help me toward what I am seeking to do. I have answered but got no further response. If the SP is returning the new ID value, how to I get the form to update, refresh or requery to show that value? SignatureCurt Gough 123cgough@kcumb.edu Remove 123 from above address to mail directly > Is the "Save" SP returning the value of the new ID? > [quoted text clipped - 13 lines] >> >> Thanks for any help. Can you post a code snippet to reproduce the problem? -- Bryan Phillips MCSD, MCDBA, MCSE Blog: http://bphillips76.spaces.live.com > Thank you for the response, but your question does not help me toward what I > am seeking to do. I have answered but got no further response. If the SP is [quoted text clipped - 23 lines] > >> > >> Thanks for any help. How are you getting the old ID on the screen? Is it databound to a textbox, or displayed in a grid, or what? Robin S. -------------------------- > Thank you for the response, but your question does not help me toward > what I am seeking to do. I have answered but got no further response. [quoted text clipped - 21 lines] >>> >>> 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.