Use query or stored procedure

From: Alan (NOSPAMalan_pltse_at_yahoo.com.au)
Date: 12/20/04 

Date: Mon, 20 Dec 2004 11:11:08 +1100

I am learning to use SQL Server and TADO.
I am going to write a small application to manage the data of membership,
which component is better to use if I add a new member to the table
Membership ?

Should I use the TADOQuery to embed the SQL statement like:
INSERT INTO Membership values (......)

OR write a stored procedure in SQL Server and pass the parameters to it ?

Relevant Pages

  • Re: Disabling ASP.net 2.0 Membership
    ... There are two primary reasons for creating a custom membership provider. ... as a FoxPro database, an Oracle database, or other data sources. ... custom connection string so that I can use the Commerce Server SQL Server ... An error has occurred while establishing a connection to the server. ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Finding a developer/tutor, value of MVP qualification.
    ... look for a SQL Server developer not an Access developer ... that the task they need it to do probably requires an upgrade to SQL Server ... The application is a membership database. ... Do we really, really need an MVP? ...
    (microsoft.public.access.adp.sqlserver)
  • Re: Replacing VS .NETs SQL Server Express Edition Integration
    ... You could write a custom membership provider. ... You could add the tables you need to your existing database table. ... As for configuring ASP.NET 2.0 membership to connect SQL Server 2000, ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: SBS 2003 Premium, and a WebServer?
    ... supports a large membership database (this site was upgraded from SBS 2000.) ... web site for the membership which could use the LAN's SQL Server? ... What would be the SQL Licensing position? ...
    (microsoft.public.windows.server.sbs)
  • asp.net membership and sql server objects -- help needed
    ... membership and how it relates to sql server users and objects. ... and for members of the role "managers" to have access to spManagers1 ... where I give a username and password to access the sqlserver database ...
    (microsoft.public.dotnet.framework.aspnet)