programmatic database access
- From: williamphenryjr <williamphenryjr.25zu9z@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Sun, 9 Apr 2006 05:06:49 -0500
This is a long post. If you have answers I'm ready. If you have web
links, that'd be great too. I'm a Junior/Senior in Computer Science at
Washington State University, so you can make some assumptions about
terminology I'll be familiar with based on that.
I am trying to write a class that will abstract out database access
stuff for my application. This class will be called DBUtil
I will use this class to do the gruntwork for a custom membership
provider. I will call this class CustMemProvider.
I need help with two things. First I need help with the web.config
file. Second I need help with the programmatic access of the database.
***First, the web.config stuff: My problem with the web.config file is
that I don't understand most of the naming stuff that goes on in it.
Specifically with the ' name="<what??>" ' tag. I need to know what to
name the database. Also I need to know what to name the membership
provider when it appears in the web.config membership provider tag. I
need to know what the ConnectionString should say as well. (I've seen
the fields for these tags, but never seen a good explanation of them.)
***Now on to the custom class stuff: In my DBUtil class I will have a
static string to hold the connectionString for the connection setup. I
will hard-code the query string into each individual function. These
functions will return DataSets (to make it easier to pass the DataSet
reference out to the page) or booleans.
I prefer to use email to uniquely identify users, so I'll write my own
custom validation code as well. I need help figuring out what to do
with that. I'm assuming it's a predefined interface from the required
base class, but I need to change the fields around to pass in an email
instead of the default username, and then, of course, the password.
Also, I need to see code for the setup of a connection and the running
of a query from my module.
Is there a way to make a script or something that sets up my database
and tables when it's run? I'm thinking about future installation needs.
***As an afterthought...what the heck are stored procedures and how do
I make one?
Thank you for your help.
--
williamphenryjr
--
William
www.williamphenryjr.com
--
"Obstacles are those frightful things you see when you take your eyes
off your goal."-Henry Ford
------------------------------------------------------------------------
williamphenryjr's Profile: http://www.hightechtalks.com/m268
View this thread: http://www.hightechtalks.com/t361805
.
- Follow-Ups:
- Re: programmatic database access
- From: Chris Fulstow
- Re: programmatic database access
- Prev by Date: Re: How to return class member as string?
- Next by Date: Add/Remove programs list
- Previous by thread: Revisit Object.Equals
- Next by thread: Re: programmatic database access
- Index(es):
Relevant Pages
|
