Click here to Skip to main content
15,868,141 members
Home / Discussions / Database
   

Database

 
GeneralRe: MS SQL Express Edition Username/Password Pin
Ian Uy13-Oct-07 18:19
Ian Uy13-Oct-07 18:19 
QuestionLogin - User - Credentials Pin
DotNetWWW13-Oct-07 5:42
DotNetWWW13-Oct-07 5:42 
AnswerRe: Login - User - Credentials Pin
Hesham Amin13-Oct-07 22:56
Hesham Amin13-Oct-07 22:56 
QuestionCPU Utilisation Goes to 100% [modified] Pin
Bad Programmer13-Oct-07 5:30
Bad Programmer13-Oct-07 5:30 
AnswerRe: CPU Utilisation Goes to 100% Pin
Bad Programmer22-Oct-07 10:01
Bad Programmer22-Oct-07 10:01 
QuestionSQL QUERY Pin
Trustapple13-Oct-07 0:17
Trustapple13-Oct-07 0:17 
AnswerRe: SQL QUERY Pin
Blue_Boy13-Oct-07 1:50
Blue_Boy13-Oct-07 1:50 
GeneralRe: SQL QUERY Pin
Trustapple13-Oct-07 4:55
Trustapple13-Oct-07 4:55 
hi,
i have three layers.

1)form.cs
2)datalayer
3)database(forget about this since it is used to open and close the connections form the ms access)

i have two text and a single combobox.

basic idea is i want a query that will search even if any one of these fields are selected.
also do the same if two are selected.
also do the same if one is selected.

the code to search will have to be on my btn click for serach event(ie is in layer form1.cs).
it will have to call my query that will be in a fn: that is in datalayer ( public DataTable refinesearch(string searchstr1, string s2, string s3)

so i think i need to use "like" condition.
something like
"select * from Employee(name of the table) where name like "string" where empid like "s2" etc........

this is my problem .i do not know the query.

thanking you and expecting your reply....






J
GeneralRe: SQL QUERY [modified] Pin
Blue_Boy13-Oct-07 5:17
Blue_Boy13-Oct-07 5:17 
GeneralRe: SQL QUERY Pin
Trustapple14-Oct-07 17:51
Trustapple14-Oct-07 17:51 
GeneralRe: SQL QUERY Pin
Blue_Boy15-Oct-07 11:32
Blue_Boy15-Oct-07 11:32 
QuestionSetting PRIMARY KEY using Alter Table Pin
Widgets13-Oct-07 0:02
Widgets13-Oct-07 0:02 
AnswerRe: Setting PRIMARY KEY using Alter Table Pin
GuyThiebaut13-Oct-07 0:40
professionalGuyThiebaut13-Oct-07 0:40 
AnswerRe: Setting PRIMARY KEY using Alter Table Pin
Mike Dimmick13-Oct-07 2:24
Mike Dimmick13-Oct-07 2:24 
GeneralRe: Setting PRIMARY KEY using Alter Table Pin
Widgets21-Oct-07 0:03
Widgets21-Oct-07 0:03 
QuestionDataGridView Filter Pin
udikantz12-Oct-07 22:13
udikantz12-Oct-07 22:13 
AnswerRe: DataGridView Filter Pin
GuyThiebaut12-Oct-07 22:35
professionalGuyThiebaut12-Oct-07 22:35 
GeneralRe: DataGridView Filter Pin
udikantz12-Oct-07 22:37
udikantz12-Oct-07 22:37 
QuestionSSRS embedded code and dynamic columns Pin
dove1112-Oct-07 9:08
dove1112-Oct-07 9:08 
AnswerRe: SSRS embedded code and dynamic columns [modified] Pin
pmarfleet12-Oct-07 9:53
pmarfleet12-Oct-07 9:53 
QuestionReg: SQL DB in Emergency Mode [modified] Very Urgent Pin
P.T.R.K12-Oct-07 7:20
P.T.R.K12-Oct-07 7:20 
AnswerRe: Reg: SQL DB in Emergency Mode [modified] Very Urgent Pin
Skanless12-Oct-07 8:49
Skanless12-Oct-07 8:49 
QuestionDynamic database pathways... Pin
new_phoenix12-Oct-07 6:59
new_phoenix12-Oct-07 6:59 
AnswerRe: Dynamic database pathways... Pin
Hesham Amin12-Oct-07 8:46
Hesham Amin12-Oct-07 8:46 
GeneralRe: Dynamic database pathways... Pin
new_phoenix15-Oct-07 10:41
new_phoenix15-Oct-07 10:41 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.