Scott on Writing

Musings on technical writing...

Four New "Working with Data in ASP.NET 2.0" Tutorials Now Available

My Working with Data in ASP.NET 2.0 tutorials have been updated to include the four newest tutorials, which illustrate working with database data directly from an ASP.NET web page. The previous 46 tutorials (as well as all tutorials following these four) looked at working with data through a layered architecture. But for one-off projects or prototyping, it may be preferable to use a SqlDataSource and avoid building the architecture. These four new tutorials illustrate various facets of working with the SqlDataSource control:

  • Querying Data with the SqlDataSource Control [VB | C#]
  • Using Parameterized Queries with the SqlDataSource [VB | C#]
  • Inserting, Updating, and Deleting Data with the SqlDataSource [VB | C#]
  • Implementing Optimistic Concurrency with the SqlDataSource [VB | C#]

Like the previous tutorials in the series, all tutorials are available in C# and VB, include the complete code download as a self-extracting ZIP, and are available in PDF format. Also, the layout of the tutorial homepage has been revamped and a new style has been applied for the individual tutorials.

There are more tutorials to be released in the upcoming weeks, including tutorials on working with binary data (images, PDFs, etc.), caching, and much more!

posted on Wednesday, February 21, 2007 9:02 AM

Feedback

# re: Four New "Working with Data in ASP.NET 2.0" Tutorials Now Available 2/21/2007 3:44 PM Andrew McCallum

I haven't seen anything in your tutorials which talk about database transactions. Where/how does the data access layer begin and end transactions?

# re: Four New "Working with Data in ASP.NET 2.0" Tutorials Now Available 2/22/2007 7:53 AM Scott Mitchell

Andrew, I have four upcoming tutorials on transactions. One talking about different ways of using transactions through Typed DataSets and then three that take that logic and implement batch data modification interfaces.

This should hit the ASP.NET website by April Fools day (April 1st, 2007). If you are in desperate need for this material, email me (mitchell@4guysfromrolla.com) and I can send you an advance copy.

Thanks

# re: Four New "Working with Data in ASP.NET 2.0" Tutorials Now Available 3/2/2007 7:20 AM Tom Sluder

Scott, I was wondering if you were planning any tutorials on sub-headings and sub-totaling (other than in the footer) in GridViews?

# re: Four New "Working with Data in ASP.NET 2.0" Tutorials Now Available 3/2/2007 9:29 AM Scott Mitchell

Tom, there are no such tutorials planned. Sorry!

For similar content on the ASP.NET 1.x DataGrid, though, check out the following:
http://aspnet.4guysfromrolla.com/articles/072603-1.aspx
http://datawebcontrols.com/faqs/DataLists/GroupingByCategory.shtml
http://aspnet.4guysfromrolla.com/articles/073003-1.aspx

Thanks!

# re: Four New "Working with Data in ASP.NET 2.0" Tutorials Now Available 4/24/2007 12:13 PM Master Shake

Unreadable! Time to switch to Rails where you can get work done in 1/3 of the time and your code doesn't look like poo.

Title:  
Name:  
Url:
Protected by Clearscreen.SharpHIPEnter the code you see:
Comments   

Add To Your Reader

My Links

Archives

Post Categories

 

I am a Microsoft MVP for ASP.NET.
I am an ASPInsider.
<May 2008>
SMTWTFS
27282930123
45678910
11121314151617
18192021222324
25262728293031
1234567

Comment Stats

DayTotal% of Total
Sunday 1866.8%
Monday 37913.9%
Tuesday 45316.7%
Wednesday 50418.5%
Thursday 53519.7%
Friday 49418.2%
Saturday 1666.1%
Total 2717100.0%

Hour1Total% of Total
12:00 AM 652.4%
1:00 AM 682.5%
2:00 AM 622.3%
3:00 AM 742.7%
4:00 AM 572.1%
5:00 AM 1033.8%
6:00 AM 1084.0%
7:00 AM 1585.8%
8:00 AM 1716.3%
9:00 AM 1475.4%
10:00 AM 1716.3%
11:00 AM 1816.7%
12:00 PM 1886.9%
1:00 PM 1696.2%
2:00 PM 1605.9%
3:00 PM 1324.9%
4:00 PM 1073.9%
5:00 PM 923.4%
6:00 PM 913.3%
7:00 PM 963.5%
8:00 PM 833.1%
9:00 PM 782.9%
10:00 PM 792.9%
11:00 PM 772.8%
Total 2717100.0%

Comments by Blog Entry Date/Time

Day Entry MadeAvg.Total
Sunday 5.54144
Monday 5.22339
Tuesday 4.28419
Wednesday 7.67637
Thursday 6.90607
Friday 5.48411
Saturday 5.33160
Total 5.842717

Hour1 Entry MadeAvg.Total
12:00 AM 5.0035
1:00 AM 1.002
5:00 AM 0.000
7:00 AM 7.0035
8:00 AM 5.35107
9:00 AM 6.32278
10:00 AM 6.47246
11:00 AM 4.41181
12:00 PM 6.88330
1:00 PM 3.00111
2:00 PM 5.41222
3:00 PM 8.64285
4:00 PM 4.0589
5:00 PM 5.92154
6:00 PM 4.52113
7:00 PM 9.67174
8:00 PM 9.80147
9:00 PM 5.05111
10:00 PM 5.4265
11:00 PM 4.5732
Total 5.842717

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


Blog Stats

Favorite Web Sites

My Books

My MSDN Articles