search in some tables of sql

Question

0.00/5 (No votes)

See more:

C#

hi how can I search a specific string data in some tables of a database by c#?
is there any one to help me?

Posted 19-Aug-11 22:57pm

isooda

Add a Solution

Comments

RaisKazi 20-Aug-11 5:06am

Do you want to fetch records from a Database Table, matching to your input string using C#?

thatraja 20-Aug-11 14:48pm

Include the table structures in your question for the quick solution

isooda 21-Aug-11 4:25am

yes.bot I want to fetch records from some tables of database.not one table

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Keith Barrow · Answer 1 · 2011-08-19T23:08:00

Solution 1

Here you go[^]

Posted 19-Aug-11 23:08pm

Keith Barrow

Comments

RaisKazi 20-Aug-11 5:12am

Should work. 5!. Although question was not very clear.

isooda 30-Aug-11 4:43am

suppose I have 5 tables in my database.one of them "author" includes authorName & authorID.the rest of tables are diffrent subject of books.for example one of them is about computer engineering and the other one is about electronic ...
I want to get author's name by user and display all the books of him.
so if this author's name is existed in the author table I should search that 4 tables.now I mant to know how can I search that 4 tables?How can I search more than one table?I'm using C#
please help me.

Keith Barrow 30-Aug-11 12:31pm

That is not a C# question, but a SQL one. If you have more than one table you select as you would and use either a join or where clause to add the results to the "main" table.If you google for SQL Select Join Subquery you'll get thousands of examples.
One final this is that your database design sounds partially wrong: Having a table per-category is bad. It is better to have a single table of category types ("Electronics", "Computer Science" etc) and a table that maps the book to the categories as a book could both be a CS and electronics book. You should also have the same thing for authors because 1 author can have meny books, and one book can have many authors (many to many). You should google for "SQL cross-reference table" / "SQL x-ref table" or "SQL many to many relationship"