944,133 Members | Top Members by Rank

Ad:
  • ASP Discussion Thread
  • Marked Solved
  • Views: 7619
  • ASP RSS
Jul 27th, 2005
0

ASP add, update and delete

Expand Post »
I do need some help I am building up an asp application that will access an SQL server [database] so what I want is for the admin access to add, update and delete in all the tables

I have about 13 different tables so my questions is do I have to do separate add.asp update.asp and delete.asp for all the different tables or I can have just one and do the include as like the one for database connection I am a baby in ASP so I really need some help.
Similar Threads
Reputation Points: 10
Solved Threads: 0
Light Poster
wchitamb is offline Offline
31 posts
since Jul 2005
Aug 1st, 2005
0

Re: ASP add, update and delete

solution tho no idea yet how to implement it

So i just want to create create one page , on that page with my text boxes make one combo box and put all my database table names in this combo box.Before adding the data First select my table name from combo box then click on add . In my code pass querystring for every table different i.e pass 1,2,3... like this then retrieve querystring using

a=request.querystring(----your variable in combo option---)

then make the connection with my database and put my insert statement in one variable for every table then put the if condition and write if (value come from querystring is 1 then execute my first variable in which there is the insert statement of first table else if (value come from querystring is 2 then execute my second variable in which there is the insert statement of sec. table. then do same thing for update and del button.
Reputation Points: 10
Solved Threads: 0
Light Poster
wchitamb is offline Offline
31 posts
since Jul 2005

This thread is solved

Either the thread starter or a moderator has marked this thread as solved. You can most likely trust the responses and answers given. There is most likely no reason for any further responses to be posted here. If you have a related question, please start a new thread in this forum instead.

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.
Message:
Previous Thread in ASP Forum Timeline: Can I implement a one way hash
Next Thread in ASP Forum Timeline: Database Connectivity in WML pages





About Us | Contact Us | Advertise | Acceptable Use Policy
Forum Index | Build Custom RSS Feed


Follow us on Twitter


© 2011 DaniWeb® LLC