Where can I find from this book the information on
how to dump the TextBox values to a database?

TIA,
Jeffrey

__________________
C. Jeffrey Wang

In the standard version of the book there are two chapters devoted to this: Data Binding in ASP.NET 2.0 and Data Management in ADO.NET.

I assume the Special Edition has the same or similar chapters.

Cheers,

Imar


---------------------------------------
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Everyone is unique, except for me.
Author of ASP.NET 2.0 Instant Results and Beginning Dreamweaver MX / MX 2004
Want to be my colleague? Then check out this post.

Thanks.

I reviewed these two chapters quickly again. If I understand correctly, the initial aspx pages in these two chpaters are based on the database schema, e.g. GridView, then the users edit or update the database directly. I am wondering if I can prepare a web page with some text boxes for end users, who know nothing about the database, to provide their desired information only, then the submitted aspx file can update/insert these online data to the database.

TIA,
Jeffrey

How do you see this?

Are you talking about dynamic SQL that adapts to what users enter? Or do you as a page developer know the schema?

The Data Management with ADO.NET chapter shows how to manually write code to update a database using objects like the SqlConnection, SqlCommand and parameters.

If this isn't what you're after, can you please elaborate?

Imar


---------------------------------------
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Everyone is unique, except for me.
Author of ASP.NET 2.0 Instant Results and Beginning Dreamweaver MX / MX 2004
Want to be my colleague? Then check out this post.

Yes, let me elaborate my question.

As an example, I have 4 tables: Voucher, Vendor, Request, and Received, and I want to prepare a web page with some 20+ textboxes
and labels. After the users fill the textboxes and click submit
button, I'd like the aspx page populate the users' textboxes values to my 4 tables, respectively.

Instead of using GridView, DetailsView, etc. of VS 2005 to display each table to a user, is there a new server control or format tool to link a textbox value to a specific database table. I know in VS 2003, we can write codes-behind to populate the tables. My question is: in VS 2005 we need the same coding, or ASP.NET 2.0 has a better tool to accomplish these tasks quickly for users who know nothing about the database tables?

TIA,
Jeffrey

Users usually don't know about the database structure. The GridView and other databound controls and any home grown solutions (should) all shield the user from technical details.

If the GridView, DetailsView etc don't fit your solution, I think you need to write your own code using the objects I mentioned earlier.

Cheers,

Imar

---------------------------------------
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Everyone is unique, except for me.
Author of ASP.NET 2.0 Instant Results and Beginning Dreamweaver MX / MX 2004
Want to be my colleague? Then check out this post.

Thanks.

One more question. If I create some database Views, I should be able to use GridView, DetailsView, etc. to dump user's data to the Views.
Am I right?

TIA,
Jeffrey

It depends. Some views are updateable, others aren't. This depends on the underlying queries of the views.

Imar

---------------------------------------
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Everyone is unique, except for me.
Author of ASP.NET 2.0 Instant Results and Beginning Dreamweaver MX / MX 2004
Want to be my colleague? Then check out this post.