Winforms - how to access the database

[Fritjolf]

Hi.

I want to start developing .net 3.5 applications using WinForms.
I'm quite new to VS and C#, but not to programming...

The questions are:
1.
How do I access the data? What are the best practices? Do I use a
Dataset, do I use Linq to sql to read the data and then stuff the data
into objects? or is it done another way?

2.
How do I bind the fields on the forms to persistent database fields
from the source? And if you databind the fields to persistent database
fields, can you detect changes in the fields the same millisecond it's
done så you can enable/disable ie. a save button... ? In other words,
can you monitor the dataset state?

I would REALLY appreciate an extensive reply and most certainly links
to tutorials or other documentation. I've been googling for days. I
can't find a "best practices" tutorial. I can't find much at all when
it comes to reading data and winforms. Only short tutorials reading a
value or two in the simplest way.

I want to know how to build a professional robust way of reading and
presenting data in a WinForms application.

Replies will be greatly appreciated!!!

Thanx in advance,

Fritjolf

 

[PvdG42]

Hi.

I want to start developing .net 3.5 applications using WinForms.
I'm quite new to VS and C#, but not to programming...

The questions are:
1.
How do I access the data? What are the best practices? Do I use a
Dataset, do I use Linq to sql to read the data and then stuff the data
into objects? or is it done another way?

2.
How do I bind the fields on the forms to persistent database fields
from the source? And if you databind the fields to persistent database
fields, can you detect changes in the fields the same millisecond it's
done så you can enable/disable ie. a save button... ? In other words,
can you monitor the dataset state?

I would REALLY appreciate an extensive reply and most certainly links
to tutorials or other documentation. I've been googling for days. I
can't find a "best practices" tutorial. I can't find much at all when
it comes to reading data and winforms. Only short tutorials reading a
value or two in the simplest way.

I want to know how to build a professional robust way of reading and
presenting data in a WinForms application.

Replies will be greatly appreciated!!!

Thanx in advance,

Fritjolf

Have you tried searching MSDN for something like "data access best
practices"??

I just did and came up with numerous interesting-looking articles like:

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

Just one of many examples.