.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

"secondary" search criteria

Posted By:      Posted Date: October 15, 2010    Points: 0   Category :ASP.Net

I have an asp.net web page that searches an SQL table based on a number of parameters, including city name (which is contained in a field called "City"). The results of this search are returned in a list of records grouped and ordered by city name.

Here's a random example of how the search results would be rendered on the web page:

  • New York:

    • record 1
    • record 2
    • record 3
  • Capetown:

    • record 4
    • record 5
    • record 6

This is working fine. But now I need to also include any records whose location is "nearby" the city. This is determined by 2 fields in the table, Alt_Locale1 and Alt_Locale2. For example, let's say that there's a record 7 which has "New York" as its "Alt_Locale1" value.

The results should look like this:

  • New York:

    • record 1
    • record 2
    • record 3
    • Nearby Results:

      • record 7
  • Capetown:

    • record 4
    • record 5
    • record 6

So, I need to revise my code behind to take the results of a query and check to see if the "City" values in any of the returned records match any values in "Alt_Locale1" and "Alt_Lo

View Complete Post

More Related Resource Links

Looking for suggestions or ideas how to setup to capture search criteria and present to user if they

Requirements call for the ability to save search values so that they can select them at later times to return the results without having to re-enter the values. They have the ability to search on 4 different types of data (Date, Time and Lat/Long), so they would like to capture what was entered and ONLY if they chose to save those values, it will be saved and next time they login, if they are searching, they can pick an old search and submit it again.   Im thinking that i add a checkbox next to each button, if they check it, it saves the data into a table with there values and username. Next time they login and go tothe search page, if there are any records for them in the table, i present them with a link that displays all the values stored and if they select one, it will run the search again and present them with the results.. does that sound like the right way to handle this request? 

Multible search criteria with empty field option

I have a gridview with two textboxes (first name & last name) and a linkbutton to search results inside the gridview.I have made select parameters as well and the search works if i write in both textboxes. However, if I leave one textbox blank, i don't get any results.------------------------------First Name: <asp:TextBox ID="txtSearch_FName" Width="100px" runat="server"></asp:TextBox>&nbsp;&nbsp;&nbsp;Last Name: <asp:TextBox ID="txtSearch_LName" Width="100px" runat="server"></asp:TextBox> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<asp:LinkButton ID="LinkButton1" Text="Find" runat="server" OnClientClick="return check();" /><asp:GridView ID="GridView1" runat="server" AllowPaging="True" AllowSorting="True" AutoGenerateColumns="False" DataKeyNames="ID" DataSourceID="Searching" CellPadding="4" PageSize="15" GridLines="Vertical" onrowcreated="GridView1_RowCreated" Width="100%"><PagerSettings Mode="NumericFirstLast" /><HeaderStyle BackColor="#666666" /><AlternatingRowStyle BackColor="#f4f4f4" /><FooterStyle BackColor="#666666" />  &

Need To create Stored Procedure for a Search Criteria


Hi all,

I need to create a stored procedure for a search criteria same as the linkedin.com is having with it under job search module. but i don't understand from where should i start. i am not getting any clue for that. please help.....

i am working on SQL Server 2005.

Does anybody know anything about converting search criteria to Binary to improve performance?

Does anybody know anything about converting search criteria to Binary to improve performance?
Mr Shaw

Search Crawls Double-Take Replication Secondary


We have a multi-site, hub and spoke replication model using Double-Take software for file share services throughout the company.  All remote sites replicate into a single server as a secondary copy.  Sites are relatively well connected within a hosted MPLS cloud (T1+).  Users do not typically access the secondary copy of the file share sets.  Each site has a dedicated share established for its respective double-take replication set on the DT Hub Server.


We would like to use SharePoint 2010 search to crawl the replicated set at the hub and apply aliases for each spoke within the search application to mask the results. 

ASP.NET Search Engine with MS Access for optional search criteria




I am creating a simple search engine similiar to:  


I have a text box for the last name and a dropdown list for the club name. If one value is entered, it will search for just one value, and ignore the blank value in the other. If there are 2 values it will search for 2 values, and no values should pull no results.

Using VS 2005 and Access 2003-2005.  My statement works fine in access but in the accessdatasource there are issues with the @ symbol in VS 2005, the ? symbol works, but generates multiple parameters, when I only need 2.

This statement works fine in the access query: (I do believe the statement is correct), but then again im using a drop down list, does that change the rules? Such as dropdownlist.selecteditem.text = ???

MS SQL Server: Search All Tables, Columns & Rows For Data or Keyword Query

If you need to search your entire database for specific data, this query will come in handy.

So when a client needs a custom report or some sort of custom development using Great Plains, most of the time I will have to track down the data in the system by running this query and find the table(s) it is in.

SharePoint Gets Search Analytics

Microsoft's SharePoint Portal Server 2003 was sold into a large number of organizations based solely on the strength of the search tool. Organizations hungered for a way to find the data they had generated.

Using SharePoint Search feature in ASP.Net Application

Integrating ASP.Net application in to MOSS 2007 to utilize SharePoint Enterprise Search Feature can be done by using Business Data Search.

Get more then google search from here

Just make it home page and enjoy more then google search you not only get google result and prizes for searching but also free ebooks and link from here like orkut,facebook,twitter,yahoomail etc...


Adding Search Refinements in SharePoint 2010

I have been playing around with SharePoint 2010 Search this morning. I love the new UI. The search refinements panel is just begging to be messed with. In my case I wanted to add the file extension JPG as an Image Type refiner.

Search Engines and Multilanguage Websites - using .resx


I have a website (asp.net 3.5+c# +linq ) having thopition to change languages (2) by the user, Am using the search engine like in the example of:


this search will find any searched word in all the pages and return the link in the default language of the site, but problem for the second language , because by default the site language is English and the user have the option to change to other language.

and as I understood that the .resx files can not be searched like the aspx by the search engines.

I looked in many blogs and discussion boards for similar  case but unfortunately no clues on this issue .
The only same case posted :


and also I could not find any clue to move on, 

 Kindly requsted to guide me for the soultio

Thanks for your time and wish you all the best
your help is always appreciated


how to make a dropdownlist looks like google search box


dear all...

any idea how to do that ?

Thnx in advance

Membership Search user


Is there a membership function to search a username Like this:   LIKE '%UserName%' ?

This is not working.

MembershipUser User = Membership.GetUser("%" + TextBox1.Text + "%");

Thank you.

Search for a string in my datasource dynamically


I am displaying an Rssfeed on my page by using XmlDataSource and Datalist controls.

I want the user to be able to limit the information that is returned to my datalist.  To do this I have a textbox on the form that allows the user to enter their search criteria.

I need to be able to dynamically create a query string utilizing the information that the user entered in the textbox.  I am also using a drop down list and allowing the user to select whether they want to search in the title, description, or all parts of the xml file.

I am having trouble figuring out how to reference the data contained in my textbox in my query string.  Where the query string says 'asp', I want to replace 'asp' with the content from my sSearch variable.  Can anyone tell me how to reference my variable in the query string???

string sSearch = txtSearch.Text;
        string SQuery = "";

        if (DropDownList2.SelectedIndex == 0)
            SQuery = "[contains(title), 'asp')]";

search in mysql database, mvc



I have set up a mysql connection in visual studio 2010 and now i have a connection and dont really know where to go next.

I want to be able to search the data and get the result in a view.

using asp.net mvc

Active Directory and .NET: paging the search result

Hi everybody!

I have a question about Active Directory in .NET
For my project I need to fetch results from Active Directory search page by page, because later I would need to bind it to the pageable DataGrid.

I tried to use .NET library DirectoryServices for that, but paging provided by this library is transparent to the user and is used only to increase the efficiency of searching, when results are too big. I.e. I cannot tell the DirectorySearcher to give me first page, then the next or previous page, it returns me all resulting pages in one bundle.

However, what I need is to explicitely get page after page directly from the AD searcher and to be able to go at least one page forward or backward.

The solution with copying all results to the DataBase and then do the paging is not accepeted by the clent, since it is too inefficient. And since it's a Web app, I cannot keep results in memory either.

I found some hints about COM Interface, but I could not find good and detailed examples or explanations. I aslo found this line of code: DirectoryServices.Interop.IDirectorySearch.ExecuteSearch(), but I don't know which libraries should i add to be able to compile this code.

If somebody could help me out with that problem, any suggestion is welcome, 'cause this issue is eating me alive :)

Thank you!
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend