Web Development

In a vB.NET 2010 web form application, I am changing an existing web page. I want the user to be able to select various customers
based upon if the first name, last name, or middle names are selected. The idea is for the user to select one, two, and/or three
of the parameters and hit the search key.

The problem is the results only return data based upon only one parameter. If data for more than one paramter is selected, the  selection
criteria is ignored.
When I run the sql in sql server management studio, I get the results I want.

Thus can you tell me what I can do to solve the problem?

The code that is having the error is listed below;
<%@ Page Title="" Language="VB" MasterPageFile="~/MasterPage.master" AutoEventWireup="false" CodeFile="Support.aspx.vb" Inherits="letters_Support" %>
<asp:Content ID="Content1" ContentPlaceHolderID="MPHead" Runat="Server">
</asp:Content>
<asp:Content ID="Content2" ContentPlaceHolderID="MPContent" Runat="Server">
<asp:Panel runat="server" ID="pnlSupport">
   <h3 style="text-align: center; border-style:none; ">Support Page</h3>

      <table style="width: 100%;">
          <tr>
            <td>
               Last Name:
            </td>
            <td>
               <asp:TextBox ID="lname" runat="server"></asp:TextBox>
            </td>
            <td>
                First Name:
            </td>
            <td>
               <asp:TextBox ID="fname" runat="server"></asp:TextBox>
            </td>
            <td>
                 Middle Name:
            </td>
            <td>
               <asp:TextBox ID="mname" runat="server"></asp:TextBox>
            </td>
             <td>
                Search by Name:
            </td>
            <td>
               <asp:Button ID="btnSearch" runat="server" Text="Search" />
            </td>
        </tr>
    </table>
    <br />
      <asp:GridView ID="GridViewSupport" runat="server" AutoGenerateColumns="False"
        PageSize="25"
        GridLines="Both"
        EnableSortinAndPagingCallbacks="true"
        HeaderStyle-CssClass="ui-widget-header"
        PagerStyle-CssClass="ui-widget ui-widget-content"
        Width="100%"
        EmptyDataText="No records were selected."
        DataSourceID="sqlTEST" AllowPaging="True" AllowSorting="True" >
        <Columns>
            <asp:BoundField DataField="lastName" HeaderText="Last Name" SortExpression="lastName" ItemStyle-HorizontalAlign="Center" ItemStyle-CssClass="ui-widget-content" ControlStyle-CssClass="text required ui-widget-content ui-corner-all"/>
            <asp:BoundField DataField="firstName" HeaderText="First Name" SortExpression="firstName" ItemStyle-HorizontalAlign="Center" ItemStyle-CssClass="ui-widget-content" ControlStyle-CssClass="text required ui-widget-content ui-corner-all"/>
            <asp:BoundField DataField="middleName" HeaderText="Middle Name" SortExpression="middleName" ItemStyle-HorizontalAlign="Center" ItemStyle-CssClass="ui-widget-content" ControlStyle-CssClass="text required ui-widget-content ui-corner-all"/>
        </Columns>
    </asp:GridView>
    <asp:SqlDataSource ID="sqlTEST" runat="server"
    ConnectionString="<%$ ConnectionStrings:sqlTEST %>" SelectCommand="SELECT [lastName]
            ,[firstName]
            ,[middleName]
            ,[suffix]
            ,a.[userid]
            from [TEST].[dbo].[Identity]
              where ([lastName] like  '%' + @lname  + '%' and
                   [firstName] like'%' + @fname + '%' and
           [middleName]  like'%' + @mname + '%')
           or ([lastName] like  '%' + @lname  + '%' and
                   [firstName] like'%' + @fname + '%'  and
                   @mname is null)
           or ([lastName] like  '%' + @lname  + '%' and
                   [middleName] like'%' + @mname + '%'  and
                   @fname is null)
               or ([firstName] like  '%' + @fname  + '%' and
                   [middleName] like'%' +  @mname + '%' and
                   @lname is null)
               or ([lastName] like  '%' + @lname  + '%' and
                   @fname is null and
                   @mname is null)
        or (@lname is null and
                   [firstName] like'%' +  @fname + '%' and
                   @mname is null)
                or (@lname is null and
                   @fname is null and
                   [middleName] like'%' +  @mname + '%')
               or (@fname is null and @lname is null and @mname is null)
          order by  [lastName], [firstName], [middleName]"
        CancelSelectOnNullParameter="false"  >
    <SelectParameters>
        <asp:ControlParameter ControlID="lname" Name="lname" PropertyName="Text" ConvertEmptyStringToNull="true" />
        <asp:ControlParameter ControlID="fname" Name="fname" PropertyName="Text" ConvertEmptyStringToNull="true" />
        <asp:ControlParameter ControlID="mname" Name="mname" PropertyName="Text" ConvertEmptyStringToNull="true" />
    </SelectParameters>
</asp:SqlDataSource>
  </asp:Panel>
</asp:Content>

jQuery(document).ready(function($){
                var count =$("#jform_params_foreignmanuf :selected").length;
                  $("#jform_params_manucounter").val(count);
              });

{

        protected $type = 'Manulist';


        protected function getOptions()
        {

         $db= JFactory::getDbo();
         $query = $db->getQuery(true);
        $query->select('*');
        $query->from('#__virtuemart_manufacturers_en_gb');
        $db->setQuery($query);
         $items = $db->loadObjectList();
         $options = array();
         if ($items)
         {
          foreach($items as $item)
          {
            $options[] = JHtml::_('select.option', $item->virtuemart_manufacturer_id , $item->mf_name,$item->slug);
          }
         }
         $options = array_merge(parent::getOptions(), $options);
         JHtml::_('script', JUri::root() . 'modules/mod_manufacturers/js/js.js');
          

        }


}

<?php

defined('JPATH_PLATFORM') or die;
JFormHelper::loadFieldClass('Text');
class JFormFieldManulist extends JFormFieldText
{

        protected $type = 'Countermanu';


        protected function getOptions()
        {

        $doc = JDocument::getDocument();
       $js = '
             jQuery(document).ready(function($){
                 var count = $("#jform_params_foreignmanuf :selected").length;
                 $("#jform_params_manucounter").val(count);
             });
      ';
       $doc->addScriptDeclaration($js);
        JHtml::_('script', JUri::root() . 'modules/mod_manufacturers/js/js.js');

        }


}

$(this).contents().find("body").on('click', function (e) {
var ClickedElement = $(e.target);

}