none
Multiple tables Search in ASP.net 2.0 RRS feed

  • Question

  • hello everyone,

    i have a Database for a DataCenter, the database including many tabels with Relations

    and i should to control (Add, edit, Delete) this Database from Asp.net 2.0 web Application.

    i want to make a search in a cusotmers table in the DB.

    The customers tables including many rows like (CustID, CustFirstName, CustSecondName, ...)

    in the ASP.net 2.0 search form i have some textboxes ( first name, second name, ... )

    and i have a radiobutton ( male, female)

    and i have button ( search)

    example:

    textbox1 = first name = "Jack"

    textbox2 = secondname = " "

    textbox3 = third name = " Petter"

    radiobutton1 = gender = " male"

     

    now i need when i click search button to retrive all the returned data into a dataview on the form.

    please i need help

    thanks all

     

    P.S : if i want to search in the internet or in MSDN about this topic which Keywords i should to use, thx

     

    Monday, June 11, 2007 2:32 PM

All replies

  • If it is SQL Server database, I believe you could use full-text search capabilities of it. But it would require from you to build full-text search indexes on a server. Then it allows you to search on any words in a table(s) without specifying columns

    Tuesday, June 12, 2007 10:39 AM
    Moderator