retrieving data from a database (sql server)

**PRR** · Jun 22 '09, 05:00 AM

In order to retrieve data from database you need to connect to database (ADO.NET). You need Sqlconnection, Sqlcommand objects along with Datareader or dataadapter.
The following articles will be quite helpful
How to use DB
How to use DB Part2

**Curtis Rutland** · Jun 24 '09, 03:56 PM

If you are new to using Databases in your .NET programs, check out the two links that PRR provided (one of those articles is written by me ;) )

But I would also suggest learning to use LINQ to SQL.

LINQ to SQL: .NET Language-Integrated Query for Relational Data

http://msdn.microsoft.com/en-us/library/bb425822.aspx

The resource cannot be found.

http://weblogs.asp.net/scottgu/archive/2007/05/19/using-linq-to-sql-part-1.aspx

It is amazingly easy to use, and very powerful.

**PRR** · Jun 25 '09, 11:30 AM

Very well written articles... Perhaps you should consider writing article on LINQ to SQL :)

**Curtis Rutland** · Jun 25 '09, 01:27 PM

Maybe one day soon, but I'm still learning it as well. It is amazing though, it can really streamline your project. Try it out if you can, just set up a test project and start playing around with the objects it creates.

retrieving data from a database (sql server)

retrieving data from a database (sql server)

Comment

Comment

Comment

Comment