Wrox Programmer Forums
| Search | Today's Posts | Mark Forums Read
BOOK: Beginning ASP.NET 3.5 : in C# and VB BOOK ISBN: 978-0-470-18759-3
This is the forum to discuss the Wrox book Beginning ASP.NET 3.5: In C# and VB by Imar Spaanjaars; ISBN: 9780470187593
Welcome to the p2p.wrox.com Forums.

You are currently viewing the BOOK: Beginning ASP.NET 3.5 : in C# and VB BOOK ISBN: 978-0-470-18759-3 section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old December 1st, 2008, 05:30 PM
Authorized User
 
Join Date: Aug 2008
Location: , , .
Posts: 14
Thanks: 0
Thanked 0 Times in 0 Posts
Default Add/Update/Delete Database records MANUALLY

Hey everyone -

I am busily reading my way through this book, and am enjoying learning all the new toys that .NET 3.5 has to offer.

However, I am an old ASP3 coder and really enjoyed writing the code on my own for querying the database to populate the drop down list and multi line text fields, etc... Not to mention to add, edit or delete database records.

This book really dwells on the new gridview, detail view, and other 'built-in' controls.

Can anyone direct me to any how-tos or other books that detail how to do these things on your own without the use of these controls?

MUCH appreciated - thanks!
JN
 
Old December 1st, 2008, 06:04 PM
Imar's Avatar
Wrox Author
Points: 70,322, Level: 100
Points: 70,322, Level: 100 Points: 70,322, Level: 100 Points: 70,322, Level: 100
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jun 2003
Location: Utrecht, Netherlands.
Posts: 17,089
Thanks: 80
Thanked 1,576 Times in 1,552 Posts
Default

Hi there,

You could check out the ADO.NET Quick Starts here:

http://www.dotnetjunkies.ddj.com/qui...sOverview.aspx

Alternatively, get a copy of

- Professional ADO.NET 2: Programming with SQL Server 2005, Oracle, and MySQL
- Professional ASP.NET 3.5: In C# and VB (Chapter 8 deals with ADO.NET in an ASP.NET context)

While I understand your desire to write code yourself (I come from an classic ASP background myself), make sure you always make the right balance between "then" and "now". Back then, it was necessary to write a lot of code yourself in order to get anything done. Nowadays, with smart controls like the ListView, that's often no longer necessary.

I think you'll be interested in controls like the ObjectDataSource (discussed in the Pro ASP.NET book as well). They give you all the fancy features on the front-end (design time support, inserting, updating and so on) while they target your custom entities that use custom written ADO.NET code.

You may also want to take a look at my articles on N-Layer design that show a lot of custom written code (I don't dwell on simple front end controls alone :)).

The first series, on ASP.NET 2.0 can be found here:

http://imar.spaanjaars.com/QuickDocId.aspx?ID=416

The second series targeting ASP.NET 3.5 (part 1 was published last week, the rest will come in the next months) can be found here:

http://imar.spaanjaars.com/QuickDocId.aspx?ID=476.

Cheers,

Imar


---------------------------------------
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Everyone is unique, except for me.
Author of Beginning ASP.NET 3.5 : in C# and VB, ASP.NET 2.0 Instant Results and Dreamweaver MX 2004
Want to be my colleague? Then check out this post.
The Following User Says Thank You to Imar For This Useful Post:
jminatel (December 14th, 2008)
 
Old December 14th, 2008, 10:18 AM
Authorized User
 
Join Date: Aug 2008
Location: , , .
Posts: 14
Thanks: 0
Thanked 0 Times in 0 Posts
Default Thanks Imar!

Thanks much for the notes Imar!

I am working through the Database sections of the book now and finding the built-in controls quite adaptable in fact!

I do have an issue on p.406, but I'll post a separate question on that.

Thanks again -
JN




Similar Threads
Thread Thread Starter Forum Replies Last Post
how to EDIT,delete,add,items in my database zedekiah BOOK: Beginning ASP 3.0 2 May 15th, 2008 08:16 AM
delete records in database shoakat Classic ASP Databases 9 October 26th, 2004 08:31 PM
Using Asp to Add/Delete Tables in a SQL database? morpheus Classic ASP Databases 2 April 23rd, 2004 07:59 AM
How to Add/Delete/Update multiple records in DB? mmwaikar ADO.NET 1 September 20th, 2003 11:41 AM
Update or add multiple table records rosenzl VB.NET 3 June 12th, 2003 01:59 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.