Hello,

Is there a way to make the data form wizard create windows forms using
sqlConnection, sqlDataAdapter and sqlCommand instead of OleDBConnection,
OleDbDataAdapter since all my projects deal with SQL 2k server? Thank you in
advance.

Yes it is possible.

When the wizard asks you for "new connection" - just tab over to the
provider and select SQL Server instead of what is selected.

- Sahil Malik
Independent consultant
You can reach me thru my blog -
http://www.dotnetjunkies.com/weblog/sahilmalik

"Henry" <(E-Mail Removed)> wrote in message
news:%(E-Mail Removed)...
> Hello,
>
> Is there a way to make the data form wizard create windows forms using
> sqlConnection, sqlDataAdapter and sqlCommand instead of OleDBConnection,
> OleDbDataAdapter since all my projects deal with SQL 2k server? Thank you
in
> advance.
>
>

Thanks for the reply but that did not do it. I do not have a connection
established and when I try to establish one the wizard gives me the OLE DB
type only.


"Sahil Malik" <(E-Mail Removed)> wrote in message
news:%23CkK4%(E-Mail Removed)...
> Yes it is possible.
>
> When the wizard asks you for "new connection" - just tab over to the
> provider and select SQL Server instead of what is selected.
>
> - Sahil Malik
> Independent consultant
> You can reach me thru my blog -
> http://www.dotnetjunkies.com/weblog/sahilmalik
>
> "Henry" <(E-Mail Removed)> wrote in message
> news:%(E-Mail Removed)...
> > Hello,
> >
> > Is there a way to make the data form wizard create windows forms using
> > sqlConnection, sqlDataAdapter and sqlCommand instead of OleDBConnection,
> > OleDbDataAdapter since all my projects deal with SQL 2k server? Thank
you
> in
> > advance.
> >
> >
>
>

Professional ADO.NET - David Sceppa - Chapter #2 - Everyone loves a wizard.
(Something like that).

- Sahil Malik
Independent Consultant
You can reach me thru my blog - http://dotnetjunkies.com/WebLog/sahilmalik/



"Henry" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Thanks for the reply but that did not do it. I do not have a connection
> established and when I try to establish one the wizard gives me the OLE DB
> type only.
>
>
> "Sahil Malik" <(E-Mail Removed)> wrote in message
> news:%23CkK4%(E-Mail Removed)...
> > Yes it is possible.
> >
> > When the wizard asks you for "new connection" - just tab over to the
> > provider and select SQL Server instead of what is selected.
> >
> > - Sahil Malik
> > Independent consultant
> > You can reach me thru my blog -
> > http://www.dotnetjunkies.com/weblog/sahilmalik
> >
> > "Henry" <(E-Mail Removed)> wrote in message
> > news:%(E-Mail Removed)...
> > > Hello,
> > >
> > > Is there a way to make the data form wizard create windows forms using
> > > sqlConnection, sqlDataAdapter and sqlCommand instead of
OleDBConnection,
> > > OleDbDataAdapter since all my projects deal with SQL 2k server? Thank
> you
> > in
> > > advance.
> > >
> > >
> >
> >
>
>

I found the answer. According to MS documentation Data Forms use OLE DB data
objects only. Thanks for your help.

"Sahil Malik" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Professional ADO.NET - David Sceppa - Chapter #2 - Everyone loves a
wizard.
> (Something like that).
>
> - Sahil Malik
> Independent Consultant
> You can reach me thru my blog -
http://dotnetjunkies.com/WebLog/sahilmalik/
>
>
>
> "Henry" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
> > Thanks for the reply but that did not do it. I do not have a connection
> > established and when I try to establish one the wizard gives me the OLE
DB
> > type only.
> >
> >
> > "Sahil Malik" <(E-Mail Removed)> wrote in message
> > news:%23CkK4%(E-Mail Removed)...
> > > Yes it is possible.
> > >
> > > When the wizard asks you for "new connection" - just tab over to the
> > > provider and select SQL Server instead of what is selected.
> > >
> > > - Sahil Malik
> > > Independent consultant
> > > You can reach me thru my blog -
> > > http://www.dotnetjunkies.com/weblog/sahilmalik
> > >
> > > "Henry" <(E-Mail Removed)> wrote in message
> > > news:%(E-Mail Removed)...
> > > > Hello,
> > > >
> > > > Is there a way to make the data form wizard create windows forms
using
> > > > sqlConnection, sqlDataAdapter and sqlCommand instead of
> OleDBConnection,
> > > > OleDbDataAdapter since all my projects deal with SQL 2k server?
Thank
> > you
> > > in
> > > > advance.
> > > >
> > > >
> > >
> > >
> >
> >
>
>