Tutorial on displaying datasets from a SQL Server database using C#

Question

I am using Visual Studio 2008 and I am a beginner.

I am connecting to a SQL Server 2008 database.

I would like to display data from a table.

How do I do this? Can someone please show me an easy tutorial?

D'Arcy Rittich · Accepted Answer · 2010-09-28 19:49:02Z

1

An easy way to get started is with LINQ To SQL.

Use this tutorial to set up LINQ To SQL for your database. You only need to follow the Create LINQ to SQL Classes section.

Then, you access the data like this:

using (var db = new MyDbDataContext())
{
    var myRecord= db.MyTable.FirstOrDefault();
    Console.WriteLine(myRecord.MyColumn.ToString());
}

answered Sep 28, 2010 at 19:49

D'Arcy Rittich

172k41 gold badges298 silver badges287 bronze badges

Sign up to request clarification or add additional context in comments.

5 Comments

Alex Gordon Over a year ago

thank you. how can i bind one of the the controls to the dataset?

Alex Gordon Over a year ago

MyDbDataContext the compiler is not recognizing this word

Alex Gordon Over a year ago

Error 1 The type or namespace name 'DbDataContext' could not be found (are you missing a using directive or an assembly reference?) C:\Documents and Settings\agordon\Local Settings\Application Data\Temporary Projects\WpfApplication1\Window1.xaml.cs 29 33 WpfApplication1

D'Arcy Rittich Over a year ago

Umm, MyDB is example text, as is all other code starting with "My". You'll need to replace MyDB with whatever you named your model, etc.

Alex Gordon Over a year ago

what is the default? DataClasses1?

Collectives™ on Stack Overflow

Tutorial on displaying datasets from a SQL Server database using C#

1 Answer 1

5 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

5 Comments

Your Answer

Sign up or log in

Post as a guest

Related