I'm trying to build a search page in Visual Web Developer, I have 5 columns in one database table which which the end user needs to able to search. I'm trying to build a DB call using the data in a text box to complete the call:
ex:SELECT * FROM ++++++++ WHERE +++++ = TEXTBOX.TEXT
Can anyone tell me how this can be achieved?

Thank's in anticipation,

Wayne

Have you considered using a Full Text Index?

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
================================================== =========
Technical Editor for:
Beginning Visual C# 2008
Professional Search Engine Optimization with ASP.NET
Professional IIS 7 and ASP.NET Integrated Programming
Wrox Blox: Introduction to Google Gears
Wrox Blox: Create Amazing Custom User Interfaces with WPF and .NET 3.0
================================================== =========

The database contains a list of lepidoptera, nearly 3000 species. I would like the end user to be able to search by, latin name, english common name, french common name or by code number. I think a full text index would be to large. Thank you for your reply.

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
================================================== =========
Technical Editor for:
Beginning Visual C# 2008
Professional Search Engine Optimization with ASP.NET
Professional IIS 7 and ASP.NET Integrated Programming
Wrox Blox: Introduction to Google Gears
Wrox Blox: Create Amazing Custom User Interfaces with WPF and .NET 3.0
================================================== =========
[/quote]

Well how is your database setup? Do you have a master table that contains the latin name, english common name, french common name and code number? Or is this split out into multiple tables?

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
================================================== =========
Technical Editor for:
Beginning Visual C# 2008
Professional Search Engine Optimization with ASP.NET
Professional IIS 7 and ASP.NET Integrated Programming
Wrox Blox: Introduction to Google Gears
Wrox Blox: Create Amazing Custom User Interfaces with WPF and .NET 3.0
================================================== =========

well.. if you want to pursued in that tech (and not try the full text index, which I suggest you try before just thinking of it), you can in fact fill the data of from and where, just asking the type of data is the user entering (If the user enters a latin name, you probably already know table and field that you need)... You can achieve that which just a combobox, filled with the type of data the user want to look at...

HTH

Gonzalo

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
^^Took that from dparsons signature and he Took that from planoie's profile
================================================== =========
My programs achieved a new certification (can you say the same?):
WORKS ON MY MACHINE
http://www.codinghorror.com/blog/archives/000818.html
================================================== =========
I know that CVS was evil, and now i got the proof:
http://worsethanfailure.com/Articles...-Hate-You.aspx
================================================== =========

All the information is in one table along with a column giving a path to the relevant insects picture and another column giving a path to that insects data. I would like the end result (after a user has selected a species) to be that the corresponding picture and data are shown to the user.
 Well how is your database setup? Do you have a master table that contains the latin name, english common name, french common name and code number? Or is this split out into multiple tables?

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
================================================== =========
Technical Editor for:
Beginning Visual C# 2008
Professional Search Engine Optimization with ASP.NET
Professional IIS 7 and ASP.NET Integrated Programming
Wrox Blox: Introduction to Google Gears
Wrox Blox: Create Amazing Custom User Interfaces with WPF and .NET 3.0
================================================== =========
[/quote]

You could write a query something like this then:

"SELECT <columns> FROM <masterTable> Where latin name like '%" + textbox1.text + "%' OR english common name like '%" + textbox1.text + "%' or french common name like '%" + textbox1.text + "%' or code number like '%" + textbox1.text + "%'"

You will obviously have to tweak it for your specific use but something like that would work.

hth.

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
================================================== =========
Technical Editor for:
Beginning Visual C# 2008
Professional Search Engine Optimization with ASP.NET
Professional IIS 7 and ASP.NET Integrated Programming
Wrox Blox: Introduction to Google Gears
Wrox Blox: Create Amazing Custom User Interfaces with WPF and .NET 3.0
================================================== =========

Good idea and thank you, but I would like to use separate text boxes for each search category.

Wayne

 well.. if you want to pursued in that tech (and not try the full text index, which I suggest you try before just thinking of it), you can in fact fill the data of from and where, just asking the type of data is the user entering (If the user enters a latin name, you probably already know table and field that you need)... You can achieve that which just a combobox, filled with the type of data the user want to look at...

HTH

Gonzalo

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
^^Took that from dparsons signature and he Took that from planoie's profile
================================================== =========
My programs achieved a new certification (can you say the same?):
WORKS ON MY MACHINE
http://www.codinghorror.com/blog/archives/000818.html
================================================== =========
I know that CVS was evil, and now i got the proof:
http://worsethanfailure.com/Articles...-Hate-You.aspx
================================================== =========
[/quote]

Thank you for that, I'll give it a go.

Wayne

 You could write a query something like this then:

"SELECT <columns> FROM <masterTable> Where latin name like '%" + textbox1.text + "%' OR english common name like '%" + textbox1.text + "%' or french common name like '%" + textbox1.text + "%' or code number like '%" + textbox1.text + "%'"

You will obviously have to tweak it for your specific use but something like that would work.

hth.

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
================================================== =========
Technical Editor for:
Beginning Visual C# 2008
Professional Search Engine Optimization with ASP.NET
Professional IIS 7 and ASP.NET Integrated Programming
Wrox Blox: Introduction to Google Gears
Wrox Blox: Create Amazing Custom User Interfaces with WPF and .NET 3.0
================================================== =========
[/quote]