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.

Re: Newbie - Getting form data to "refresh" by Bryan

Bryan
Thu Jan 18 22:23:58 CST 2007

Is the "Save" SP returning the value of the new ID?

--
Bryan Phillips
MCSD, MCDBA, MCSE
Blog: http://bphillips76.spaces.live.com



"Curt Gough" <123CGough@KCUMB.EDU> wrote in message
news:u5ZO56xOHHA.4244@TK2MSFTNGP04.phx.gbl:

> 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.


Re: Newbie - Getting form data to "refresh" by Curt

Curt
Fri Jan 19 08:07:06 CST 2007

Yes. I have it as an OUTPUT variable in the SP.

--
Curt Gough
123cgough@kcumb.edu

Remove 123 from above address to mail directly
"Bryan Phillips" <bphillips@nospam.spamcop.net.spammenot> wrote in message
news:OfrAlG4OHHA.4172@TK2MSFTNGP04.phx.gbl...
> Is the "Save" SP returning the value of the new ID?
>
> --
> Bryan Phillips
> MCSD, MCDBA, MCSE
> Blog: http://bphillips76.spaces.live.com
>
>
>
> "Curt Gough" <123CGough@KCUMB.EDU> wrote in message
> news:u5ZO56xOHHA.4244@TK2MSFTNGP04.phx.gbl:
>
>> 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.
>



Re: Newbie - Getting form data to "refresh" by Curt

Curt
Mon Jan 22 14:19:09 CST 2007

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?

--
Curt Gough
123cgough@kcumb.edu

Remove 123 from above address to mail directly
"Bryan Phillips" <bphillips@nospam.spamcop.net.spammenot> wrote in message
news:OfrAlG4OHHA.4172@TK2MSFTNGP04.phx.gbl...
> Is the "Save" SP returning the value of the new ID?
>
> --
> Bryan Phillips
> MCSD, MCDBA, MCSE
> Blog: http://bphillips76.spaces.live.com
>
>
>
> "Curt Gough" <123CGough@KCUMB.EDU> wrote in message
> news:u5ZO56xOHHA.4244@TK2MSFTNGP04.phx.gbl:
>
>> 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.
>



Re: Newbie - Getting form data to "refresh" by RobinS

RobinS
Thu Jan 25 20:22:03 CST 2007

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.
--------------------------
"Curt Gough" <123CGough@KCUMB.EDU> wrote in message
news:%23zOoVKmPHHA.4824@TK2MSFTNGP02.phx.gbl...
> 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?
>
> --
> Curt Gough
> 123cgough@kcumb.edu
>
> Remove 123 from above address to mail directly
> "Bryan Phillips" <bphillips@nospam.spamcop.net.spammenot> wrote in
> message news:OfrAlG4OHHA.4172@TK2MSFTNGP04.phx.gbl...
>> Is the "Save" SP returning the value of the new ID?
>>
>> --
>> Bryan Phillips
>> MCSD, MCDBA, MCSE
>> Blog: http://bphillips76.spaces.live.com
>>
>>
>>
>> "Curt Gough" <123CGough@KCUMB.EDU> wrote in message
>> news:u5ZO56xOHHA.4244@TK2MSFTNGP04.phx.gbl:
>>
>>> 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.
>>
>
>