Hello,

I have an OLEDB DataAdapter and cannot create a Dataset to use with the
adapter because the SelectCommand contains a parameter. Is there a work
around for this?

Any Help is appreciated.

Thank You

Chris - I'm not sure what you mean - in the designer or with code? Using
parameterized queries is definitely not an issue in code. Can you tell me a
little more aobut the problem.

--
W.G. Ryan MVP (Windows Embedded)

TiBA Solutions
www.tibasolutions.com | www.devbuzz.com | www.knowdotnet.com
"Chris" <(E-Mail Removed)> wrote in message
news:494FA9CB-FC29-4895-BEC9-(E-Mail Removed)...
> Hello,
>
> I have an OLEDB DataAdapter and cannot create a Dataset to use with the
> adapter because the SelectCommand contains a parameter. Is there a work
> around for this?
>
> Any Help is appreciated.
>
> Thank You

Hi,

I'm trying to do this in the designer. I can graphically create the
DataAdapter using the wizard. I can build the Select Query using the Query
Builder and placing a ?
in the criteria field for the appropriate field. This all seems to work
fine, however once I try to graphically build the dataset using the wizard,
it throws an error because the parameter value is empty and will not let me
create a dataset.

Thanks



"W.G. Ryan eMVP" wrote:

> Chris - I'm not sure what you mean - in the designer or with code? Using
> parameterized queries is definitely not an issue in code. Can you tell me a
> little more aobut the problem.
>
> --
> W.G. Ryan MVP (Windows Embedded)
>
> TiBA Solutions
> www.tibasolutions.com | www.devbuzz.com | www.knowdotnet.com
> "Chris" <(E-Mail Removed)> wrote in message
> news:494FA9CB-FC29-4895-BEC9-(E-Mail Removed)...
> > Hello,
> >
> > I have an OLEDB DataAdapter and cannot create a Dataset to use with the
> > adapter because the SelectCommand contains a parameter. Is there a work
> > around for this?
> >
> > Any Help is appreciated.
> >
> > Thank You
>
>
>

In the designer you can set a default value for the dataadapter.
(better late than never)
thanks
kes

"Chris" wrote:

> Hi,
>
> I'm trying to do this in the designer. I can graphically create the
> DataAdapter using the wizard. I can build the Select Query using the Query
> Builder and placing a ?
> in the criteria field for the appropriate field. This all seems to work
> fine, however once I try to graphically build the dataset using the wizard,
> it throws an error because the parameter value is empty and will not let me
> create a dataset.
>
> Thanks
>
>
>
> "W.G. Ryan eMVP" wrote:
>
> > Chris - I'm not sure what you mean - in the designer or with code? Using
> > parameterized queries is definitely not an issue in code. Can you tell me a
> > little more aobut the problem.
> >
> > --
> > W.G. Ryan MVP (Windows Embedded)
> >
> > TiBA Solutions
> > www.tibasolutions.com | www.devbuzz.com | www.knowdotnet.com
> > "Chris" <(E-Mail Removed)> wrote in message
> > news:494FA9CB-FC29-4895-BEC9-(E-Mail Removed)...
> > > Hello,
> > >
> > > I have an OLEDB DataAdapter and cannot create a Dataset to use with the
> > > adapter because the SelectCommand contains a parameter. Is there a work
> > > around for this?
> > >
> > > Any Help is appreciated.
> > >
> > > Thank You
> >
> >
> >