Re: DataAdapters and Parameters

Ok. The application is for a business that heeds to check on a member's
current valid membership. It doesn't need to be in Access.
But since the checking of this validity will not be via the Internet and on
an Intranet, downtime needs to be considered. There are times when the
server goes down and we need to check a customer's membership.

I'm beginning, with .NET so please take the time to explain something better
if you know of anyway. I'm thinking that during normal "uptime" when servers
are optimal, using SQL Server and ASP.NET via our intranet. When the servers
go down, is it possible for ALL MEMBER's never accessed before to be
available with that set up?

I guess I could go with a synchronized SQL database?...
Well as of now, the SQL portion hasn't been given to me and the only thing I
have for my development is MS Access as my Backend, so I'm prototyping right
now.

Could you suggest a model for this situation?


"Sahil Malik [MVP C#]" wrote:

> > Does a parameterized DataAdapter automatically take care of this so I can
> > use the following SQL without having to worry about blank textboxes?:
>
> No. Your DataAdapter will work exactly per the SQL Statement you specify.
>
> > Perhaps a DataReader is more appropriate for this?
>
> I don't see why .. this factor is certainly not a consideration in choosing
> between dataadapter or datareader.
>
> > Presently, in my Access application, I've had to write a separate strSQL
> > for
> > each possible combination as to avoid creating a SQL statement with a
> > blank
> > parameter.
>
> So you are using MS-Access? Try Like %xx%
>
> > Additionally, since this will be an Intranet application which needs
> > downtime backup, that is why I am currently working with Access. I'm
> > hoping
> > for the user to use SQL server while the intranet is up, and have a
> > downtime
> > backup of this info in an MDB file on their local hard drive.
>
> I'm so confused. If this is an ASP.NET App, you shoudln't be using Access,
> and if there is downtime - then the webserver is down - why bother with MS
> Access?
>
> - Sahil Malik [MVP]
> ADO.NET 2.0 book -
> http://codebetter.com/blogs/sahil.malik/archive/2005/05/13/63199.aspx
> __________________________________________________________
>
>
> "jonefer" <jonefer@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
> news:279689B7-9035-40B6-AE7D-649FE62446DD@xxxxxxxxxxxxxxxx
> > I'm creating a simple search for Members, with possible 4 search
> > parameters:
> > Name, SSN, DOB, SEX, but (just beginning ASP.NET/VB.NET) I'm fearing that
> > I
> > will need to create a dataadapter for every possible combination of fields
> > entered to eliminate a blank parameter.
> >
> > Does a parameterized DataAdapter automatically take care of this so I can
> > use the following SQL without having to worry about blank textboxes?:
> >
> > SELECT * From Membership WHERE
> > Name = @txtName AND
> > SSN like @txtSSN AND
> > DOB like @txtDOB AND
> > SEX like @txtDOB
> >
> > Perhaps a DataReader is more appropriate for this?
> >
> > Presently, in my Access application, I've had to write a separate strSQL
> > for
> > each possible combination as to avoid creating a SQL statement with a
> > blank
> > parameter.
> >
> > Additionally, since this will be an Intranet application which needs
> > downtime backup, that is why I am currently working with Access. I'm
> > hoping
> > for the user to use SQL server while the intranet is up, and have a
> > downtime
> > backup of this info in an MDB file on their local hard drive.
> >
> > Thanks so much for anything to help with this...
> >
>
>
>
.

Relevant Pages

  • Re: Replacing VS .NETs SQL Server Express Edition Integration
    ... As you said you already have an existing database that contains the ... membership structure, ... Replacing VS .NET's SQL Server Express Edition Integration ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Membership functions connect to Sql Server as Process Identity, not user identity??
    ... as i said - you could just use the source of the sql provider released by MS last week and remove the impersonation/revert to self code - look out for calls to "SqlConnectionHelper.GetConnection" ... forms authentication and the membership class for everything. ... to sql server, including connection pool issues, but that's the way it ...
    (microsoft.public.dotnet.framework.aspnet.security)
  • Re: Problem after 49.71 Days
    ... Andrew J. Kelly SQL MVP ... >> Are you running the latest service pack for SQL 7 and the OS? ... > returns 7.00.961 which I believe is SP3/3a for SQL Server. ... > convince the 'powers that be' to allow some downtime. ...
    (microsoft.public.sqlserver.server)
  • Re: Use query or stored procedure
    ... Use a naming convention like GetTableNameAll, GetTableNameByID, ... >I am learning to use SQL Server and TADO. ... > I am going to write a small application to manage the data of membership, ... > OR write a stored procedure in SQL Server and pass the parameters to it? ...
    (borland.public.delphi.database.ado)
  • Re: Sql To Active Directory Challenge
    ... capability) it is much easier for SQL server to check if a user is a member ... This way you can check the group membership in SQL and only return the ... you'll not need to check the membership in your app. ... SQL stored procedures and get the apps for this group. ...
    (microsoft.public.dotnet.languages.vb)