Click here to Skip to main content
Rate this: bad
good
Please Sign up or sign in to vote.
See more: ASP.NET SQL GimmeCode
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 1:43am
Edited 27-Apr-13 12:03pm
v4
Comments
ThePhantomUpvoter at 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 at 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 at 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

Rate this: bad
good
Please Sign up or sign in to vote.

Solution 1

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  
  Permalink  

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

  Print Answers RSS
0 OriginalGriff 304
1 Maciej Los 285
2 Sergey Alexandrovich Kryukov 255
3 Shweta N Mishra 216
4 PIEBALDconsult 174
0 OriginalGriff 7,660
1 Sergey Alexandrovich Kryukov 7,072
2 DamithSL 5,604
3 Manas Bhardwaj 4,986
4 Maciej Los 4,760


Advertise | Privacy | Mobile
Web04 | 2.8.1411023.1 | Last Updated 27 Apr 2013
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100