[Hi,
I need a single web page, running on IIS, where I can do some table maintenance. By that, I mean:
Display records
Add records
Edit records
Delete records
My SQL Server table, users, has 3 columns:
username
password
status
all are varchar 50
When I visit the page, I want to see a listing of users, and status, sorted alphabetically by username.
There should be an "add new user" button or link, and next to each user, an edit button or link, and a delete button or link.
When I click to ADD, I just want a simple form where I can add username and password to the table, using regular, clear text input box, and a hidden field for status, value is ACTIVE.
After adding record, the page should return to the display mode, and I should see the new user.
When I edit, I want to be able to edit both username and password, both in regular, clear text input box. After the DB update, return to the page in display mode.
When I delete, the page will ask me for verification. I can either cancel, and return to display mode with no changes, or accept, and return to display mode minus the selected user.
The database is MS SQL Server, 8.0. My other pages link to the db using an SQL OLE DB connection. I'm not sure if this is ASP, or ASP.NET, I think the latter, but it looks the same to me.][1]
I include a file, [login to view URL], for my connection. In it, it creates MM_cn_STRING, which is used like this in another page:
MM_fldUserAuthorization="userID"
MM_redirectLoginSuccess="[login to view URL]"
MM_redirectLoginFailed="[login to view URL]"
MM_flag="[login to view URL]"
set MM_rsUser = [login to view URL](MM_flag)
[login to view URL] = MM_cn_STRING
[
Pretty simple, right?
][1]
## Deliverables
This is all on one page, and I'll add my own connection string to the script. ? Please comment your code very liberally.
* * *This broadcast message was sent to all bidders on Friday Dec 12, 2008 11:16:04 AM:
Hi, How do I tell if it is ASP or ASP.NET? Does it matter? It all looks the same to me. Tx, George