Hi all

I am creating a web services application in Visual Studio Dot net
which links to a MS SQL database.

I need to create a form which lets the user pick his field of
choice(doesnt matter what it is..) using drop down boxes,radio buttons
etc and query the database according to what he has picked and
retrieve only those columns and rows.

The thing is, I do not want to hardcode the queries using
OleDbDataAdapter or SqlDataAdapter, but want the query to be generated
on the fly, once the user picks his fields from the form.

I'd greatly appreciate any help.

Thanks,
m

This is a forum on Microsoft Access... try another forum, possibly
something on MSSQL or .Net

Cheers,
Jason Lepack

On Feb 27, 5:36 pm, madhumita.iyen...@gmail.com wrote:

Hi all
>
I am creating a web services application in Visual Studio Dot net
which links to a MS SQL database.
>
I need to create a form which lets the user pick his field of
choice(doesnt matter what it is..) using drop down boxes,radio buttons
etc and query the database according to what he has picked and
retrieve only those columns and rows.
>
The thing is, I do not want to hardcode the queries using
OleDbDataAdapter or SqlDataAdapter, but want the query to be generated
on the fly, once the user picks his fields from the form.
>
I'd greatly appreciate any help.
>
Thanks,
m