Design Time Data

Hello,

So far in my relatively simple winforms app, I $B!G (Bve been doing all database
work in code. I do all the following in code:
- Instantiate a SqlConnection and connect
- Instantiate a SqlCommand and a whole bunch of SqlParameter objects to call
a stored procedure

This is working well, but is time consuming. I like the fact that I have a
lot of control this way and can use the SQL Server optimized classes.
The only downside is it $B!G (Bs time consuming and code maintenance might become
a burden.

I would like it if VS would at least be able to setup the parameters for the
stored proc.
To move in that direction, I started a new project, and clicked on  $B!F (BData $B!G (B
 $B"* (B  $B!F (BAdd new Data Source $B!G (B.

I $B!G (Bve now got an associated  $B!H (Bdata module $B!I (B (Delphi speak). I thought I $B!G (Bd
be able to create connections and commands at design time, but this isn $B!G (Bt
so. The only components I see under the data section are:
- Dataset
- DataGridView
- BindingSource
- BindingNavigator

I expected to see SqlConnection, SqlCommand, etc.
Could someone enlighten me, with perhaps a weblink or two?

Much appreciated!

Richard Rogers
http://www.RichardRogers.ca/
(MSN) [email protected]