Click here to Skip to main content
15,888,351 members
Home / Discussions / C#
   

C#

 
QuestionPop-Out like window Pin
Programm3r22-Nov-07 22:23
Programm3r22-Nov-07 22:23 
Questionhow to export an html image file into pdf format Pin
chithra.r22-Nov-07 21:53
chithra.r22-Nov-07 21:53 
AnswerRe: how to export an html image file into pdf format Pin
dan!sh 22-Nov-07 22:00
professional dan!sh 22-Nov-07 22:00 
AnswerRe: how to export an html image file into pdf format Pin
pmarfleet22-Nov-07 22:04
pmarfleet22-Nov-07 22:04 
QuestionHow to pass multiple parameter SqlParameter in one? Pin
TheShihan22-Nov-07 21:37
TheShihan22-Nov-07 21:37 
AnswerRe: How to pass multiple parameter SqlParameter in one? Pin
N a v a n e e t h22-Nov-07 21:54
N a v a n e e t h22-Nov-07 21:54 
GeneralRe: How to pass multiple parameter SqlParameter in one? Pin
TheShihan22-Nov-07 22:41
TheShihan22-Nov-07 22:41 
AnswerRe: How to pass multiple parameter SqlParameter in one? Pin
pmarfleet22-Nov-07 21:56
pmarfleet22-Nov-07 21:56 
TheShihan wrote:
I've got a query which looks similar to this: "...FROM xy WHERE ID=@Id AND NAME IN (@Names)".


I don't think you can do this.

One way you could do this without dynamically constructing a SQL statement to execute is to split your comma-separated list and load the items into a table variable. You can then JOIN your table xy to your table variable to find the records in this table where the name is in the list.

Paul Marfleet

"No, his mind is not for rent
To any God or government"
Tom Sawyer - Rush


AnswerRe: How to pass multiple parameter SqlParameter in one? Pin
Joe22-Nov-07 23:08
Joe22-Nov-07 23:08 
Questionho to add right-click to a "Console" object ? Pin
carabutnicolae123422-Nov-07 21:34
carabutnicolae123422-Nov-07 21:34 
AnswerRe: ho to add right-click to a "Console" object ? Pin
leppie22-Nov-07 21:58
leppie22-Nov-07 21:58 
AnswerRe: ho to add right-click to a "Console" object ? Pin
Andrei Ungureanu22-Nov-07 22:03
Andrei Ungureanu22-Nov-07 22:03 
GeneralRe: ho to add right-click to a "Console" object ? Pin
carabutnicolae123422-Nov-07 23:45
carabutnicolae123422-Nov-07 23:45 
Questionupdating database Pin
Nitin.raj22-Nov-07 21:30
Nitin.raj22-Nov-07 21:30 
AnswerRe: updating database Pin
Andrei Ungureanu22-Nov-07 21:34
Andrei Ungureanu22-Nov-07 21:34 
GeneralRe: updating database Pin
Nitin.raj22-Nov-07 21:50
Nitin.raj22-Nov-07 21:50 
GeneralRe: updating database Pin
Andrei Ungureanu22-Nov-07 21:58
Andrei Ungureanu22-Nov-07 21:58 
GeneralRe: updating database Pin
Andrei Ungureanu22-Nov-07 22:07
Andrei Ungureanu22-Nov-07 22:07 
QuestionGenerics question Pin
calendarw22-Nov-07 21:04
calendarw22-Nov-07 21:04 
AnswerRe: Generics question Pin
Andrei Ungureanu22-Nov-07 21:15
Andrei Ungureanu22-Nov-07 21:15 
GeneralRe: Generics question Pin
calendarw22-Nov-07 21:39
calendarw22-Nov-07 21:39 
GeneralRe: Generics question Pin
Andrei Ungureanu22-Nov-07 21:45
Andrei Ungureanu22-Nov-07 21:45 
GeneralRe: Generics question Pin
calendarw22-Nov-07 21:57
calendarw22-Nov-07 21:57 
GeneralRe: Generics question Pin
Andrei Ungureanu22-Nov-07 22:12
Andrei Ungureanu22-Nov-07 22:12 
GeneralRe: Generics question Pin
calendarw22-Nov-07 22:14
calendarw22-Nov-07 22:14 

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.