G
Guest
I used the UI to create a Dataset and a DataAdapter for an Oracle Table.
This process generates the SQL for Select/Insert/Update/Delete and places it
in the ".xsd" file. My problem is that my selection criteria is pretty
variable, meaning I have a screen where the user can pick 1 or more of 6
fields and have various operators such as "=" or "Like", etc.
I have created and ObjectDataSource and bound this to my DataView.
My question is How can I alter the "Select" statement which resides in the
..xsd file as I need to construct (or believe that I do) my where clause in my
code. Can I do this?
This process generates the SQL for Select/Insert/Update/Delete and places it
in the ".xsd" file. My problem is that my selection criteria is pretty
variable, meaning I have a screen where the user can pick 1 or more of 6
fields and have various operators such as "=" or "Like", etc.
I have created and ObjectDataSource and bound this to my DataView.
My question is How can I alter the "Select" statement which resides in the
..xsd file as I need to construct (or believe that I do) my where clause in my
code. Can I do this?