Resending

"R. Rogers" <[email protected]> Wed, 14 Nov 2007 11:43:01 -0500
Newsgroups gmane.comp.windows.devel.dotnet.winforms
Message-ID <003901c826dd$6c0ae3a0$6800a8c0@Speedster>
Strange with the formatting, hopefully this shows up better now:

So far in my relatively simple winforms app, I've 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's 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 'Data' ?
'Add new Data Source'.

I've now got an associated "data module" (Delphi speak). I thought I'd be
able to create connections and commands at design time, but this isn't 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]

Richard Rogers
http://www.RichardRogers.ca/
(Home) 416-787-4777
(Cell) 416-723-7427
(MSN) [email protected]