Click here to Skip to main content
15,921,622 members
Home / Discussions / C#
   

C#

 
Generalcustom data in WS Pin
balkang23-Apr-05 3:29
balkang23-Apr-05 3:29 
Questionhow to update dataset from dataview ? Pin
kings_123-Apr-05 0:07
kings_123-Apr-05 0:07 
AnswerRe: how to update dataset from dataview ? Pin
Polis Pilavas23-Apr-05 5:25
Polis Pilavas23-Apr-05 5:25 
Generalhelp me!!!! Pin
SEAGames2222-Apr-05 23:59
SEAGames2222-Apr-05 23:59 
GeneralRe: help me!!!! Pin
Colin Angus Mackay23-Apr-05 0:33
Colin Angus Mackay23-Apr-05 0:33 
Generalmail api Pin
abandito22-Apr-05 23:53
abandito22-Apr-05 23:53 
GeneralSearch Pin
vuthaianh22-Apr-05 23:33
vuthaianh22-Apr-05 23:33 
GeneralRe: Search Pin
Polis Pilavas23-Apr-05 5:32
Polis Pilavas23-Apr-05 5:32 
vuthaianh wrote:
It may be a stupid question because i'm too

There's no such thing as a stupid question. I think that you would stupid if u never asked. So don't worry about that.

Dynamically constructing an SQL statement is a quite good way to do it actually. To solve the problem you are facing I would either:
(1) Force the users to fill in all the fields (which is not what you are after as u said)
(2) Check for the blank fields and just avoid inserting an "AND" operator for them into your SQL statement. Only handle the fields that were filled by the user.

Hope this helps.

Regards,
Polis

Can you practice what you teach?
GeneralRe: Search Pin
Anonymous24-Apr-05 1:44
Anonymous24-Apr-05 1:44 
GeneralRe: Search Pin
vuthaianh24-Apr-05 13:16
vuthaianh24-Apr-05 13:16 
GeneralFile/Folder properties for multiple files Pin
Anonymous22-Apr-05 17:46
Anonymous22-Apr-05 17:46 
GeneralRe: File/Folder properties for multiple files Pin
leppie22-Apr-05 20:36
leppie22-Apr-05 20:36 
GeneralRe: File/Folder properties for multiple files Pin
Anonymous23-Apr-05 4:22
Anonymous23-Apr-05 4:22 
GeneralThreading Problem Pin
ACorbs22-Apr-05 16:41
ACorbs22-Apr-05 16:41 
GeneralRe: Threading Problem Pin
S. Senthil Kumar22-Apr-05 22:25
S. Senthil Kumar22-Apr-05 22:25 
GeneralRe: Threading Problem Pin
ACorbs23-Apr-05 17:06
ACorbs23-Apr-05 17:06 
Generalcalculate grade point average for 2 students Pin
keithbg22-Apr-05 16:21
keithbg22-Apr-05 16:21 
GeneralRe: calculate grade point average for 2 students Pin
Dave Kreskowiak22-Apr-05 17:23
mveDave Kreskowiak22-Apr-05 17:23 
GeneralRe: calculate grade point average for 2 students Pin
Christian Graus22-Apr-05 17:49
protectorChristian Graus22-Apr-05 17:49 
GeneralRe: calculate grade point average for 2 students Pin
leppie22-Apr-05 20:58
leppie22-Apr-05 20:58 
GeneralRe: calculate grade point average for 2 students Pin
S. Senthil Kumar22-Apr-05 22:31
S. Senthil Kumar22-Apr-05 22:31 
GeneralRe: calculate grade point average for 2 students Pin
Christian in a nice hotel in Singapore24-Apr-05 0:13
sussChristian in a nice hotel in Singapore24-Apr-05 0:13 
Generalbyte[] to string and back again... Pin
Ian Bowler22-Apr-05 10:49
Ian Bowler22-Apr-05 10:49 
GeneralRe: byte[] to string and back again... Pin
CiNN22-Apr-05 20:32
CiNN22-Apr-05 20:32 
GeneralRe: byte[] to string and back again... Pin
leppie22-Apr-05 21:03
leppie22-Apr-05 21:03 

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.