Scott on Writing

Musings on technical writing...

The Next Batch of "Working with Data in ASP.NET 2.0" Tutorials are Online!

Eight new “Working with Data in ASP.NET 2.0” Tutorials are now available online at www.asp.net. These new eight tutorials show how to edit, insert, and delete data in the GridView, DetailsView, and FormView controls using the ObjectDataSource and tiered architecture examined in the previous tutorials.

An Overview of Inserting, Updating, and Deleting Data
Examining the Events Associated with Inserting, Updating, and Deleting
Handling BLL- and DAL-Level Exceptions in an ASP.NET Page
Adding Validation Controls to the Editing and Inserting Interfaces
Customizing the Data Modification Interface
Implementing Optimistic Concurrency
Adding Client-Side Confirmation When Deleting
Limiting Data Modification Functionality Based on the User

Like the previous 15, each tutorial is available in both a C# and VB version, can have its entire code downloaded as a self-extracting ZIP file, and can be downloaded as a PDF for offline viewing.

Check 'em all out - http://www.asp.net/Learn/DataAccess

posted on Thursday, July 13, 2006 7:19 AM

Feedback

# re: The Next Batch of "Working with Data in ASP.NET 2.0" Tutorials are Online! 7/15/2006 2:41 AM Matt

Scott, thanks. These tutorials are fantastic. Kudos!

# re: The Next Batch of "Working with Data in ASP.NET 2.0" Tutorials are Online! 7/17/2006 7:54 AM Pete

Keep up the great articles. I really like the trick to add a blank row in a dropdown for inserts.

# re: The Next Batch of "Working with Data in ASP.NET 2.0" Tutorials are Online! 7/17/2006 12:12 PM Paulo Jericoh

Very good !
Better than this is just putting all the features in the same tutorial form.
Congratulations.

# re: The Next Batch of "Working with Data in ASP.NET 2.0" Tutorials are Online! 7/19/2006 2:35 AM Harmen Brouwer

Hi Scott,

Thanks for the great tutorials! These were almost the only articles I could find covering data access.

I would like to point out a possible SQL error on the first page of the tutorial.
.. WHERE Categories.CategoryID =
Products.ProductID) ..
Products.ProductID should be changed to Products.CategoryID i think..

Keep up the good work :)

# re: The Next Batch of "Working with Data in ASP.NET 2.0" Tutorials are Online! 7/20/2006 5:43 AM TomSluder

Scott,

Do you know if they plan on releasing the tutorials in one "big honking" .pdf file at the conclusion of the series? I'd like to have all the information in once place for easier reference. (Easier to move to portable devices instead of 46 individual .pdf files).

TomSluder (tomsluder-at-gmail-dot-com)

# re: The Next Batch of "Working with Data in ASP.NET 2.0" Tutorials are Online! 7/20/2006 6:23 AM Scott Mitchell

Tom, at this time there are no plans to release one "big honkin'" PDF, sorry. Maybe once ALL of the tutorials are 100% done, they'll package them all up into one big PDF, but while these tutorials are still being developed and periodically fixed for typos, the more files that need to be modified, the more time consuming and error-prone it is.

Thanks

# re: The Next Batch of "Working with Data in ASP.NET 2.0" Tutorials are Online! 7/21/2006 12:08 PM BizWhisperer

Can you take some time to put a tutorial together that would integrate using the tableadapters with Enterprise Services?

# re: The Next Batch of "Working with Data in ASP.NET 2.0" Tutorials are Online! 7/24/2006 1:58 AM Johan Ramestam

Scott, I'm amazed by the amount and quality of all the work you do. Your tutorials on data access for ASP.NET 2 is by far the most comprehensive I've seen on the net!

However, in my opinion, most tutorials barely touch the subject of joining and relations within a typed dataset. I'd like to learn more about this - in depth. What design principles should I use?

Also, I'd like to mention that using sub queries in the SELECT statement (as suggested in Step 5 in "Creating a Data Access Layer") won't work in the adapter wizard. Maybe this is an Oracle issue, I don't know. Of course you can work around it by editing the query manually in the xsd file, but then you also need to add the resulting column, and you break the integration with the designer.

Keep up the *very* good work!

# re: The Next Batch of "Working with Data in ASP.NET 2.0" Tutorials are Online! 7/24/2006 9:41 AM R Sturim

Scott,

These tutorials are fantastic and are greatly appreciated out here. Keep up the great work and thanks for helping out so many of us.

Cheers,

Rich

# re: The Next Batch of "Working with Data in ASP.NET 2.0" Tutorials are Online! 7/26/2006 8:07 AM Juan Pablo Garcia

Scott,

Excelent Tutorials! now i'm developing a website and your articles help's me very much.

Only one thing... on the second tutorial when you create the Class, on the Delete method, you say:

"For example, if the page developer calls DeleteProduct passing in a ProductID for a non-existent product, the DELETE statement issued to the database will have no affect and therefore the DeleteProduct method will return false."

But in the code the Default value is "true" (System.ComponentModel.DataObjectMethodType.Delete, true) it's that correct? or i have not understood the concept?

Thanks! and follows with this Great's Tutorials!

# re: The Next Batch of "Working with Data in ASP.NET 2.0" Tutorials are Online! 7/26/2006 8:49 AM Scott Mitchell

Juan, the DataObjectMethodType attribute does not have any effect on the return value of the method, or the method's functionality at all. It simply provides metadata information that the ObjectDataSource's "Choose Data Source" wizard uses when populating its drop-down lists...

# re: The Next Batch of "Working with Data in ASP.NET 2.0" Tutorials are Online! 7/27/2006 10:53 AM Juan Pablo Garcia

Sorry!, evidently it had not understood.

With your explain, now i understand perfectly.

The value in the attribute only indicates which Method's is the default at the time of selecting the Select/Insert/Update or Delete Method on the ObjectDataSource Wizzard!

Thank you man!

# re: From Iran 7/30/2006 6:22 AM Hooman

I would like to thank you for all the tutorials you made, thinking about ASP is the only good thing happening in my life

# re: The Next Batch of "Working with Data in ASP.NET 2.0" Tutorials are Online! 8/2/2006 2:40 PM Juan Pablo

Scott, i have been practice with your samples, and i have a question:

When i change the FieldName,Type or Length on one table of the database Northwind, these changes aren't refreshed on de NorthWind.xsd that i've created on VS2005.

There anyway to refresh the .xsd on my project? or i have to change it manually?

Thanks!

# re: The Next Batch of "Working with Data in ASP.NET 2.0" Tutorials are Online! 8/8/2006 2:31 PM Will Lynn

These are great tutorials, thanks. I'm [finally] moving to .NET 2.0 from 1.1 and these are a big help! One of the problems with a lot of .NET 2.0 material online is that it's outdated (usually for Beta 1).

# re: The Next Batch of "Working with Data in ASP.NET 2.0" Tutorials are Online! 8/10/2006 6:51 AM Tom Sluder

It's been 4 weeks since the release of the tutorials up to # 23. Any idea on when the next set is to be released? I'm chomping at the bit to see what's next.

Thanks,
Tom - tomsluder@gmail.com

# re: The Next Batch of "Working with Data in ASP.NET 2.0" Tutorials are Online! 8/10/2006 10:05 AM Mike

Your whole design pattern that you push here and on MSDN is flawed, and violates a number of important OO design considerations. I urge anyone reading to consider other soultions such as Hibernate or other ORMs that provide flexibilty in creating a domain model. Much better reading can be found at:

http://www.martinfowler.com/bliki/AnemicDomainModel.html

http://www.martinfowler.com/bliki/DataModels.html

http://www.codeproject.com/aspnet/NHibernateBestPractices.asp

http://www.hibernate.org/328.html

# re: The Next Batch of "Working with Data in ASP.NET 2.0" Tutorials are Online! 9/29/2006 4:46 AM Shreekar

Excellent introduction !!!
Thanks a lot.

Title:

Name:

Url:

Enter the code you see:

Comments

Remember Me?

Add To Your Reader

My Links

Post Categories

May 2008

Comment Stats

Day	Total	% of Total
Sunday	186	6.8%
Monday	379	13.9%
Tuesday	453	16.7%
Wednesday	504	18.5%
Thursday	535	19.7%
Friday	494	18.2%
Saturday	166	6.1%
Total	2717	100.0%

Hour¹	Total	% of Total
12:00 AM	65	2.4%
1:00 AM	68	2.5%
2:00 AM	62	2.3%
3:00 AM	74	2.7%
4:00 AM	57	2.1%
5:00 AM	103	3.8%
6:00 AM	108	4.0%
7:00 AM	158	5.8%
8:00 AM	171	6.3%
9:00 AM	147	5.4%
10:00 AM	171	6.3%
11:00 AM	181	6.7%
12:00 PM	188	6.9%
1:00 PM	169	6.2%
2:00 PM	160	5.9%
3:00 PM	132	4.9%
4:00 PM	107	3.9%
5:00 PM	92	3.4%
6:00 PM	91	3.3%
7:00 PM	96	3.5%
8:00 PM	83	3.1%
9:00 PM	78	2.9%
10:00 PM	79	2.9%
11:00 PM	77	2.8%
Total	2717	100.0%

Comments by Blog Entry Date/Time

Day Entry Made	Avg.	Total
Sunday	5.54	144
Monday	5.22	339
Tuesday	4.28	419
Wednesday	7.67	637
Thursday	6.90	607
Friday	5.48	411
Saturday	5.33	160
Total	5.84	2717

Hour¹ Entry Made	Avg.	Total
12:00 AM	5.00	35
1:00 AM	1.00	2
5:00 AM	0.00	0
7:00 AM	7.00	35
8:00 AM	5.35	107
9:00 AM	6.32	278
10:00 AM	6.47	246
11:00 AM	4.41	181
12:00 PM	6.88	330
1:00 PM	3.00	111
2:00 PM	5.41	222
3:00 PM	8.64	285
4:00 PM	4.05	89
5:00 PM	5.92	154
6:00 PM	4.52	113
7:00 PM	9.67	174
8:00 PM	9.80	147
9:00 PM	5.05	111
10:00 PM	5.42	65
11:00 PM	4.57	32
Total	5.84	2717

Learn More About Comment Stats
¹ - All times GMT -8...

Blog Stats

Posts - 465
Stories - 0
Comments - 2717
Trackbacks - 568

Favorite Web Sites

My Books

My MSDN Articles