G
Guest
I am new to asp.net and am having a hard time with what i would usually do
with a recordset. I have a simple query that returns a record - how can i
get that record value into a variable after i execute the query:
select Max(DailyPOnumber) + 1 as MaxPO from tblPurchaseOrders
i used to be able to do something similar to
MaxNo=rs("MaxNo")
any help would be appreciated
with a recordset. I have a simple query that returns a record - how can i
get that record value into a variable after i execute the query:
select Max(DailyPOnumber) + 1 as MaxPO from tblPurchaseOrders
i used to be able to do something similar to
MaxNo=rs("MaxNo")
any help would be appreciated