-----------------------------------------------------------

New Message on MumbaiUserGroup

-----------------------------------------------------------
From: MS_BJAIN
Message 1 in Discussion

Hi,
 
Application : Access and ASP.NET
Access : 
 
 tbl_Order : OrderId AutoNumber,
                 OrderDate Datetime,
                 Quantity Number

>From ASP.NET, I send INSERT statement to store value in the tbl_order table. As 
>OrderID is AutoNumber,  I don`t know what`s last number.
 
For Eg. Insert into tbl_order(orderdate, quantity) values('21-Dec-2003', 100).
 
Access auto-generate OrderID. 
 
How do an ASP.NET application/interface know OrderID generated for this row.?
 
As application  would be used by many users at the same time, I can`t use max 
function. 
 
Thank you.
 
NRI�s, Free Money transfer to India. Click here. 

-----------------------------------------------------------

To stop getting this e-mail, or change how often it arrives, go to your E-mail 
Settings.
http://groups.msn.com/MumbaiUserGroup/_emailsettings.msnw

Need help? If you've forgotten your password, please go to Passport Member Services.
http://groups.msn.com/_passportredir.msnw?ppmprop=help

For other questions or feedback, go to our Contact Us page.
http://groups.msn.com/contact

If you do not want to receive future e-mail from this MSN group, or if you received 
this message by mistake, please click the "Remove" link below. On the pre-addressed 
e-mail message that opens, simply click "Send". Your e-mail address will be deleted 
from this group's mailing list.
mailto:[EMAIL PROTECTED]

Reply via email to