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]