Click here to Skip to main content
15,666,844 members
Home / Discussions / Database
   

Database

 
GeneralRe: using datagrid in vb.net [modified] Pin
Rharzkie14-Jul-07 20:23
Rharzkie14-Jul-07 20:23 
AnswerRe: using datagrid in vb.net Pin
TomGarth15-Jul-07 9:05
TomGarth15-Jul-07 9:05 
Questionrecover a database in sql 2005 server Pin
prasadbuddhika13-Jul-07 22:54
prasadbuddhika13-Jul-07 22:54 
AnswerRe: recover a database in sql 2005 server Pin
Mike Dimmick14-Jul-07 5:53
Mike Dimmick14-Jul-07 5:53 
QuestionHelp for select statement Pin
Prakash_Mishra13-Jul-07 22:29
Prakash_Mishra13-Jul-07 22:29 
AnswerRe: Help for select statement Pin
kubben14-Jul-07 1:22
kubben14-Jul-07 1:22 
GeneralRe: Help for select statement Pin
Prakash_Mishra14-Jul-07 1:37
Prakash_Mishra14-Jul-07 1:37 
AnswerRe: Help for select statement Pin
Arun.Immanuel14-Jul-07 2:37
Arun.Immanuel14-Jul-07 2:37 
Try this:

<code>string optionalFiters="";

if(TxtFname.Text!="")
  optionalFiters+="  and First_Name= '" & TxtFname.Text + "'";

if(TxtLname.Text!="")
  optionalFiters+="  and Last_Name= '" & TxtLname.Text + "'";

if(DpdownSex.SelectedItem.Text!="")
  optionalFiters+="  and Sex= '" & DpdownSex.SelectedItem.Text + "'";
</code>
Query:

<code>"select * from Cand_Information where Category= '" & DpCat.SelectedItem.Text & "'" & optionalFiters
</code>  




Regards,
Arun Kumar.A

QuestionInsert Pin
pmartike13-Jul-07 21:09
pmartike13-Jul-07 21:09 
AnswerRe: Insert Pin
pmartike13-Jul-07 22:17
pmartike13-Jul-07 22:17 
QuestionClassic ASP and MS SQL Express Edition Pin
Fayu13-Jul-07 6:06
Fayu13-Jul-07 6:06 
AnswerRe: Classic ASP and MS SQL Express Edition Pin
Paul Conrad13-Jul-07 6:11
professionalPaul Conrad13-Jul-07 6:11 
GeneralRe: Classic ASP and MS SQL Express Edition Pin
Fayu13-Jul-07 6:24
Fayu13-Jul-07 6:24 
AnswerRe: Classic ASP and MS SQL Express Edition Pin
Dave Kreskowiak13-Jul-07 6:19
mveDave Kreskowiak13-Jul-07 6:19 
GeneralRe: Classic ASP and MS SQL Express Edition Pin
Fayu13-Jul-07 6:34
Fayu13-Jul-07 6:34 
GeneralRe: Classic ASP and MS SQL Express Edition Pin
Dave Kreskowiak13-Jul-07 8:55
mveDave Kreskowiak13-Jul-07 8:55 
GeneralRe: Classic ASP and MS SQL Express Edition Pin
Fayu16-Jul-07 12:50
Fayu16-Jul-07 12:50 
AnswerDO NOT CROSSPOST Pin
leckey13-Jul-07 7:05
leckey13-Jul-07 7:05 
GeneralRe: DO NOT CROSSPOST Pin
Paul Conrad13-Jul-07 11:46
professionalPaul Conrad13-Jul-07 11:46 
GeneralRe: DO NOT CROSSPOST Pin
Sathesh Sakthivel13-Jul-07 16:21
Sathesh Sakthivel13-Jul-07 16:21 
QuestionHow to create hash clustered index in oracle? Pin
Mushtaque Nizamani12-Jul-07 23:53
Mushtaque Nizamani12-Jul-07 23:53 
AnswerRe: How to create hash clustered index in oracle? Pin
Paul Conrad13-Jul-07 11:49
professionalPaul Conrad13-Jul-07 11:49 
Questionsqlerror Pin
saravanan0512-Jul-07 23:13
saravanan0512-Jul-07 23:13 
AnswerRe: sqlerror Pin
Mike Dimmick12-Jul-07 23:45
Mike Dimmick12-Jul-07 23:45 
GeneralRe: sqlerror Pin
TomGarth15-Jul-07 9:16
TomGarth15-Jul-07 9:16 

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.