Good Evening,I am attempting to learn ASP and SQL by fixing simple bugs in my existing software. I am trying to fix a customer search that returns three columns: customer name, move date and job status. I've found that the move date column displays incorrect data from a different view, whereas the other two columns are populating data from the correct view. Simple, right?Well, I began by looking at the customer search control and found that it's using a data set called 'SearchCustomerDS'. It also references a BLL file (see code below) so I tried there. <asp:ObjectDataSource ID="odsCustomers" runat="server" SelectMethod="SearchCustomerDS" TypeName="EML.EML.CustomerBLL"> <SelectParameters> <asp:ControlParameter ControlID="txtSearchString" Name="SearchString" PropertyName="Text" Type="String" /> </SelectParameters></asp:ObjectDataSource>
I located the code in the BLL (see below) that references the search, but have not been able to locate the data it is calling.Public Function SearchCustomerDS(SearchString As String) As DataSetReturn CustomerProvider.SearchCustomerDS(SearchString)End Function
I feel as though I have looked everywhere and have been unsuccessful. Perhaps I am not understanding how data sets work, but as I mentioned, I am very new to this. I'd appreciate any input!