Re: How to read an SQL Server into a ASP page and then change, add, delete and write it back to SQL Server

From: Jeff Cochran (jcochran.nospam_at_naplesgov.com)
Date: 06/10/04 

Date: Thu, 10 Jun 2004 12:02:15 GMT

On 10 Jun 2004 01:20:10 -0700, belindacur@yahoo.com (Belinda) wrote:

>I need to read a SQL Server table into a Web Page and within the Web
>Page to permit my users to make changes to the records, delete or add
>new records and then save the entire contents back to the SQL Server
>table back.

That's an extremely ineficient design. Send *everything* to the web
page, then send *everything* back, even for just changing a single
phone number?

>The functionality I am looking is almost the same as In the SQL
>Enterprise Manager whereby I can choose a table open the table and
>then return all rows and I can maintain the same and save it back to
>the SQL Server table. I want almost a similar web interface to such a
>functionality.

Then it's *not* the same. You change a row in the Enterprise Manager
and it changes just that data in the table.

>Even if not a generic functionality as the SQL Enterprise Manager
>table maintenance appreciate if somebody can share the code with a
>sample how I can do it in ASP pages + T-SQL if need be.

Pull up a list of records that match a criteria (reduce the amount of
data sent), then when a single record is clicked on to change, pull
the full record into a form. Edit it and do an UPDATE on that record
by clicking a "Save Changes" button. Simpler, faster and infinitely
expandable. Plenty of sample code on the internet for each portion of
this.

Jeff