Search DB with category

Question

1.00/5 (1 vote)

See more:

HI,
I will write a search page that whit user input(code or name) this search can fill grid ordered.of course this search depended on dropdownlist_category.
i will sql select command for this search
i have one table person and other category

Posted 27-Apr-13 0:43am

behnamhaji

Updated 27-Apr-13 11:03am

Kenneth Haugland

v4

Add a Solution

Comments

[no name] 27-Apr-13 6:44am

Thank you for updating us on your plans. Please come back if you have an actual question or run into any problems.

OriginalGriff 27-Apr-13 6:55am

What ThePhantomUpvoter measn is that this is not a good question - we cannot work out from that little what you are trying to do.
Remember that we can't see your screen, access your HDD, or read your mind.
So tell us what you have tried, where you are stuck and we will try to help. At present there isn't a question here we can help you with.
Use the "Improve question" widget to edit your question and provide better information.

OriginalGriff 27-Apr-13 7:29am

No, don't tell us what you want to do - we understand that part.
Do tell us what is stopping you doing it.
Until you do, we don't know what help you need!

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)

RedDk · Answer 1 · 2013-04-27T10:15:00

TABLE (TSQL)?:

CREATE TABLE [cpqaAnswers].[cpqa].[tbl_BH_personPlus](
   [person][nvarchar](27),
      [other][nvarchar](28)
   )

SELECT (TSQL)?:

SELECT [person], [other] FROM [cpqaAnswers].[cpqa].[tbl_BH_personPlus]

BULK INSERT (TSQL)?:

BULK INSERT [cpqaAnswers].[cpqa].[tbl_BH_personPlus]
   FROM 'C:\users\BH\DT\gems_(td).txt'

gems_(td).txt:

OriginalGriff	eighthours
OriginalGriff	ninehours
ThePhantomUpVoter	ninehhours