Click here to Skip to main content
15,892,005 members
Home / Discussions / ASP.NET
   

ASP.NET

 
AnswerRe: How to use "User Controls" in Web Form? Pin
viivekk3-Jul-08 19:29
viivekk3-Jul-08 19:29 
GeneralRe: How to use "User Controls" in Web Form? Pin
nguyenhh5-Jul-08 8:02
nguyenhh5-Jul-08 8:02 
QuestionSql Injection Pin
ngrj3-Jul-08 16:24
ngrj3-Jul-08 16:24 
AnswerRe: Sql Injection Pin
Mark Churchill3-Jul-08 16:52
Mark Churchill3-Jul-08 16:52 
GeneralRe: Sql Injection Pin
ngrj3-Jul-08 17:06
ngrj3-Jul-08 17:06 
QuestionWizard sidebar Pin
kjosh3-Jul-08 13:52
kjosh3-Jul-08 13:52 
Questionhow to generate query at runtime ......... help plzz Pin
dream_liner_7e73-Jul-08 10:37
dream_liner_7e73-Jul-08 10:37 
AnswerRe: how to generate query at runtime ......... help plzz Pin
Christian Graus3-Jul-08 10:58
protectorChristian Graus3-Jul-08 10:58 
dream_liner_7e7 wrote:
asp.net or vs2005 wizard support to generate query on the fly.


ASP.NET should have nothing to do with SQL. Wizards in VS sure don't. Yes, you CAN write code that uses controls that try to magically generate SQL, but situations like this are where they hit their limits, and using them is always a nasty option.

I'd do something like this: say one of your possible things to search for is a name. I'd write a proc that does something like


AND (tb1.Name == @Name OR @Name = '')

In other words, you pass empty strings for things you don't want to look for, and write a proc that deals with them

This was a SQL question, you should ask those in the SQL forum

Christian Graus

Please read this if you don't understand the answer I've given you. If you're still stuck, ask me for more information.

AnswerRe: how to generate query at runtime ......... help plzz Pin
dream_liner_7e73-Jul-08 11:18
dream_liner_7e73-Jul-08 11:18 
Questioncan't align the asp:listItems to left Pin
gottimukkala3-Jul-08 6:22
gottimukkala3-Jul-08 6:22 
AnswerRe: can't align the asp:listItems to left Pin
Sherin Iranimose3-Jul-08 6:58
Sherin Iranimose3-Jul-08 6:58 
QuestionHow do add controls from 'codebehind' ? Pin
tina->newcoder3-Jul-08 6:11
tina->newcoder3-Jul-08 6:11 
AnswerRe: How do add controls from 'codebehind' ? Pin
Sherin Iranimose3-Jul-08 6:18
Sherin Iranimose3-Jul-08 6:18 
GeneralRe: How do add controls from 'codebehind' ? Pin
tina->newcoder3-Jul-08 6:23
tina->newcoder3-Jul-08 6:23 
GeneralRe: How do add controls from 'codebehind' ? Pin
Sherin Iranimose3-Jul-08 6:33
Sherin Iranimose3-Jul-08 6:33 
GeneralRe: How do add controls from 'codebehind' ? Pin
tina->newcoder3-Jul-08 6:55
tina->newcoder3-Jul-08 6:55 
GeneralRe: How do add controls from 'codebehind' ? Pin
Christian Graus3-Jul-08 7:34
protectorChristian Graus3-Jul-08 7:34 
GeneralRe: How do add controls from 'codebehind' ? Pin
Sherin Iranimose3-Jul-08 20:50
Sherin Iranimose3-Jul-08 20:50 
GeneralRe: How do add controls from 'codebehind' ? Pin
tina->newcoder3-Jul-08 23:59
tina->newcoder3-Jul-08 23:59 
GeneralRe: How do add controls from 'codebehind' ? Pin
Sherin Iranimose4-Jul-08 1:04
Sherin Iranimose4-Jul-08 1:04 
QuestionLiveLink Pin
kenexcelon3-Jul-08 5:35
kenexcelon3-Jul-08 5:35 
AnswerRe: LiveLink Pin
matthews_3019-Feb-09 9:36
matthews_3019-Feb-09 9:36 
QuestionDate Format Problem Pin
lav naphade3-Jul-08 4:54
lav naphade3-Jul-08 4:54 
AnswerRe: Date Format Problem Pin
Sherin Iranimose3-Jul-08 4:59
Sherin Iranimose3-Jul-08 4:59 
GeneralRe: Date Format Problem Pin
lav naphade3-Jul-08 5:49
lav naphade3-Jul-08 5:49 

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.