Home › ASP.NET Wiki (Beta) › Data Access

Data Access

Rate It (68) Thank you for your feedback!

There's a lot of great information on the net about accessing data in common data access patterns with ASP.NET 2.0.

Videos

SQL Server Videos - If you're just learning about SQL Server, start with these beginner videos.
How Do I: Access Data with LINQ to SQL - We've got lots of videos that will walk you step by step through using LINQ against a database.
How Do I: Create Data-Driven Web Sites?
Databinding to User Interface Controls

Tutorials

From ScottGu's blog: Scott Mitchell recently finished writing his multi-part Working with Data in ASP.NET 2.0 tutorial series for the www.asp.net site. This tutorial series contains more than 75 data tutorials (and over 750 pages of content!). There are VB and C# versions available for all of the tutorials, and the articles can optionally be downloaded in PDF format. If you haven't read the tutorials yet, I'd highly recommend you check them out here.

Data Access Guides

Data Access Application Block - patterns & practices group
The Data Access Application Block is a component of Enterprise Library which reduces the amount of custom code that you need to create, test, and maintain when building data access layers in .NET applications.

And more to come! Also, check out the SQL Server Videos at http://www.asp.net/learn/sql-videos/.

Revision number 2, Monday, February 04, 2008 8:00:00 AM by scott@elbandit.co.uk

Revision History
Article Updates
Comments

Comments

You must Login to comment.

Mon, Jun 16, 2008 8:44 PM by srihari2net	ok..gud one
Wed, Sep 24, 2008 9:55 PM by zac.hall	brutal!
Sat, Sep 27, 2008 2:26 AM by uniquesaiful	This tutorial helps a lot
Thu, Oct 23, 2008 10:42 AM by priyasadiwala	Linq article is nice

In This Section

Revision #2 Sat, May 10, 2008 9:07 PM by SGWellens	Connecting to SAP data from ASP.NET Here is a good articlefor connecting toSAP from ASP.NET.... You will need to download the SAP.Net.Setup2003.msi file from the SAP site first. http://help.sap.com/saphelp_nw2004s/helpdata/en/51/d5470940fd564b888f4beb9523fa6c/content.htm
Revision #3 Thu, Oct 16, 2008 8:35 AM by Jürgen Gutsch	Connection String The connection string specifies information about how to initialize a connection to a data store. It contains keyword/value pairs. the first pair is always the Provider or Driver. The following pairs will correspond with the data required to initialize the
Revision #2 Tue, Oct 14, 2008 7:13 PM by mbanavige	Dynamic Data ASP.NET Dynamic Data is a web application scaffolding framework that shipped with Service Pack 1 of .NET 3.5. Using either LINQ to SqL or LINQ to entities, it exposes tables in a database by encoding it in the URI of the ASP.NET web service. The data table
Revision #3 Sat, Oct 11, 2008 8:24 AM by PaulSpencer	LINQ From MSDN: "The LINQ Project is a codename for a set of extensions to the .NET Framework that encompass language-integrated query, set, and transform operations. It extends C# and Visual Basic with native language syntax for queries and provides class
Revision #5 Mon, Feb 4, 2008 8:00 AM by vik20000in	Data Binding Nearly all the controls in ASP.NET have properties that can be databound to. Articles Jesse Liberty has a fine article on Data Binding in ASP.NET 2.0 over on O'Reilly from 2005. John Papa talks about Data-Bound Controls in his MSDN Article from 2005. Tutorials
Revision #3 Mon, Feb 4, 2008 8:00 AM by vik20000in	DataSource Controls FromScottGu:Scott Mitchell is also writing some great data articles on using the ASP.NET 2.0 DataSource controls for the excellent www.4GuysFromRolla.com ASP.NET site. If you don't visitwww.4GuysFromRolla.com, I highly recommend checking it out (it has
New Mon, Feb 4, 2008 8:00 AM by shanselman	Data-centric UI Controls Both the GridView and ListView are new Data Controls in Visual Studio 2008. Scott Guthrie has a great introduction that uses the ListView Control. He builds a product catalog from scratch with complete control over the CSS and HTML. Watch Kashif Alam's Webcast
Revision #2 Mon, Feb 11, 2008 3:27 PM by mbanavige	Web Services A Web service is defined by the W3C as "a software system designed to support interoperable Machine to Machine interaction over a network." Web services are frequently just Web APIs that can be accessed over a network, such as the Internet, and executed
Revision #5 Sun, Sep 7, 2008 12:45 PM by ssg31415926	Active Directory & LDAP There are many questions that come up regularly in the forums. These recipes address some of those questions. RecipesAccessing Active DirectoryHow to query Active Directory without hard-coding the domain name - in C# and VB.Net Testing your directory access