Retriving Data From 2 Views By The Value In A Textbox

i have a textbox which a user enters a numeric value 

i want it to use SqlDataSource and check if the value exists in any of the tables. 

in my text box the users would enter starting from '100000'  or '200000'

i want it to check the view that starts the # with '100000' and 2ed view starts '200000' 

With this i can check in one of the tables and make the selection.

<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:imacstestConnectionString %>"

SelectCommand="SELECT [ReportNumber] FROM [AppraisalSummaryBlue] WHERE ([ReportNumber] = @ReportNumber)">

<SelectParameters>

<asp:ControlParameter ControlID="txtReport" Name="ReportNumber" PropertyName="Text"

Type="String" />

</SelectParameters>

</asp:SqlDataSource>

 

How can i make this possible ?

i was thinking putting a second sqldatasource and have that check the second view but how can i make the textbox goto the correct selectcommand ?