Re: How To Return Record Number From AddNew

On 27/08/2007 in message <uw3PF5L6HHA.5316@xxxxxxxxxxxxxxxxxxxx> Bob Barrows [MVP] wrote:

PS. Why are you using classic ADO in a .Net application? You should be
using ADO.Net. You should post ADO.Net questions to this group:
microsoft.public.dotnet.framework.adonet

It's historical, I moved to C# from VB6 and converted what I was used to. It also seems to me that ADO.NET is geared towards using Datasets/Data Adaptors and although I did try I could never get the results I wanted, it's much simpler to me to hand code these things.

After going through the VS2005 help file I have found a comment that I need Access 2000 or later to support the @@IDENTITY property. I do have Office XP which includes Access 2000 and the equivalent versions of Word and Excel. I tried it once and found it was the first of the MSFT bloatware, silly help windows popping up all over the place, and Word in an SDI style so if you are working on 10 documents you have 10 instances of Word running, ridiculous. I un-installed it and haven't considered "upgrading" again. I guess I could just try Access 2000, or perhaps put the SQL server desktop engine on the PC.

I'll keep reading and thinking, in the meantime many thanks for your very prompt responses :-)

--
Jeff Gaines
.

Relevant Pages

  • Re: Component with XML island
    ... MVP .Net France ... "Bob Barrows " wrote: ... so the .asp groups deal with server-side code. ... > on a scripting newsgroup, or one of the groups in the .xml hierarchy. ...
    (microsoft.public.inetserver.asp.general)
  • Re: value of checked box!?
    ... Bob Barrows wrote: ... was one of the major computer news sites -- ZDNet perhaps? ... Microsoft MVP -- ASP/ASP.NET ... Please reply to the newsgroup. ...
    (microsoft.public.inetserver.asp.db)
  • Re: value of checked box!?
    ... Bob Barrows wrote: ... was one of the major computer news sites -- ZDNet perhaps? ... Microsoft MVP -- ASP/ASP.NET ... Please reply to the newsgroup. ...
    (microsoft.public.inetserver.asp.general)
  • Re: Component with XML island
    ... MVP .Net France "Bob Barrows " wrote:> As you are talking about client-side components and functionality, ... > still off-topic on an ASP newsgroup, which is mainly focused on server-side> technology. ... The email account listed in my From>>> header is my spam trap, so I don't check it very often. ...
    (microsoft.public.inetserver.asp.general)
  • Re: dynamic table content?
    ... Bob Barrows wrote:> I suppose you could open the specified file using fso and> response.write its contents: ... > CONST ForReading = 1 ... > pagename = request.quesrystring> ... Microsoft MVP -- ASP/ASP.NET ...
    (microsoft.public.inetserver.asp.general)