.net/oracle multiple select parameter problem

[rosie2006]

Environment: .net2.0 over oracle

Problem? a simple select statement within a DetailsView that gets two parameter values from a GridView SelectedValue.

It might be valuable to understand that to pull a single record from this particular table requires two parameters.

What follows defies understanding.

The desired query:
<asp:SqlDataSou rce .....
SelectCommand=" select * from tbl where col1 = :x AND col2 = :y"
....
<asp:ControlPar ameter ControlID="Grid View1" Name="x" PropertyName="S electedValue" Type="String" />
<asp:ControlPar ameter ControlID="Grid View1" Name="y" PropertyName="S electedValue" Type="String" />
....
</asp:SqlDataSour ce>

Returns nothing, no response, nada, zero - though the values are plainly visible in GridView1.

A modification to try to see what's happening:
<asp:SqlDataSou rce .....
SelectCommand=" select * from tbl where col1 = :x OR col2 = :y"
....
<asp:ControlPar ameter ControlID="Grid View1" Name="x" PropertyName="S electedValue" Type="String" />
<asp:ControlPar ameter ControlID="Grid View1" Name="y" PropertyName="S electedValue" Type="String" />
....
</asp:SqlDataSour ce>

Changing the AND to OR returns just what the query asks for - way much more than the one record desired, but it works.

Another modification to try figure out what's happening:
<asp:SqlDataSou rce .....
SelectCommand=" select * from tbl where col1 = 'x' or col2 = 'y'"
....
</asp:SqlDataSour ce>

Hard coding the values returns the desired record.

Why do the multilple selectparameter s (AND) cause the query to get lost in .net?

Hard coding it in code-behind also works, but bypasses all the .net classes and makes for a ton of coding when updating, deleting and inserting and all their parameters need to be coded in. It would be good to just see .net to it's job.

This is just one query of hundreds in this application and all work if a single select parameter is used (can be used). The problem appears only when more than one select parameter is needed to return a record. Then you get nothing.

I am stumped.

If this is not the correct forum, please give directions.

[rengaraj]

What is the table structure?
What is the data type of the two columns in the Oracle table?