Re: Design Time Data

*Richard,*

    Scott Mitchell (4GuysFromRolla.com's Scott) wrote an excellent series of
articles for accessing data using ASP.NET via Visual Studio.  I know you're
writting a Winforms app but it would definately be worth your time to check
out these articles.  You can find them here:
http://www.asp.net/learn/data-access/

-Pete

On Nov 14, 2007 11:22 AM, R. Rogers <[email protected]> wrote:

> 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/ <http://www.richardrogers.ca/>
> (MSN) [email protected]
>