Click here to Skip to main content
15,900,461 members
Home / Discussions / C#
   

C#

 
QuestionHow can I access to an item in a solution folder ? Pin
Mohammad Dayyan20-Sep-08 11:32
Mohammad Dayyan20-Sep-08 11:32 
AnswerRe: How can I access to an item in a solution folder ? Pin
Caio Kinzel Filho20-Sep-08 14:55
Caio Kinzel Filho20-Sep-08 14:55 
GeneralRe: How can I access to an item in a solution folder ? Pin
Mohammad Dayyan21-Sep-08 3:35
Mohammad Dayyan21-Sep-08 3:35 
GeneralRe: How can I access to an item in a solution folder ? Pin
Caio Kinzel Filho21-Sep-08 7:20
Caio Kinzel Filho21-Sep-08 7:20 
Questionsending messages to gtalk Pin
Mogaambo20-Sep-08 11:14
Mogaambo20-Sep-08 11:14 
GeneralAttempt to bump a post. Pin
Pete O'Hanlon20-Sep-08 11:29
mvePete O'Hanlon20-Sep-08 11:29 
GeneralRe: Attempt to bump a post. Pin
Paul Conrad20-Sep-08 11:59
professionalPaul Conrad20-Sep-08 11:59 
QuestionADO CommandText with parameter values. Pin
AndrusM20-Sep-08 10:57
AndrusM20-Sep-08 10:57 
I need to get sql command text where parameters are replaced by values.

I tried code below but displayed sql statement contains parameter names,
not actual values.

How to obtain command where parameters are replaced by their values ?

Andrus.

static IDataReader ExecuteReader(string command
                , out IDbConnection connection
                , CommandBehavior behavior
                , params IDbDataParameter[] dataParams)
{
            connection = ...
            connection.Open();
            IDbCommand cmd = new SqlCommand(command, connection as 
SqlConnection);
            foreach (IDbDataParameter p in dataParams)
                cmd.Parameters.Add(p);
            // How to display replaced parameter values ?
            MessageBox.Show(cmd.CommandText);
            return cmd.ExecuteReader(behavior | 
CommandBehavior.CloseConnection);
} 


Andrus

AnswerRe: ADO CommandText with parameter values. Pin
Giorgi Dalakishvili20-Sep-08 11:34
mentorGiorgi Dalakishvili20-Sep-08 11:34 
AnswerRe: ADO CommandText with parameter values. Pin
snifozao27-Oct-10 13:49
snifozao27-Oct-10 13:49 
QuestionDetect MouseNotMove event Pin
baranils20-Sep-08 10:43
baranils20-Sep-08 10:43 
AnswerRe: Detect MouseNotMove event Pin
Mark Salsbery20-Sep-08 11:00
Mark Salsbery20-Sep-08 11:00 
AnswerRe: Detect MouseNotMove event Pin
Anthony Mushrow20-Sep-08 11:01
professionalAnthony Mushrow20-Sep-08 11:01 
GeneralRe: Detect MouseNotMove event Pin
baranils20-Sep-08 11:22
baranils20-Sep-08 11:22 
GeneralRe: Detect MouseNotMove event Pin
Anthony Mushrow20-Sep-08 13:55
professionalAnthony Mushrow20-Sep-08 13:55 
GeneralRe: Detect MouseNotMove event Pin
baranils21-Sep-08 6:49
baranils21-Sep-08 6:49 
QuestionRe: Detect MouseNotMove event Pin
Mark Salsbery21-Sep-08 7:08
Mark Salsbery21-Sep-08 7:08 
AnswerRe: Detect MouseNotMove event Pin
baranils21-Sep-08 7:20
baranils21-Sep-08 7:20 
GeneralRe: Detect MouseNotMove event Pin
Mark Salsbery21-Sep-08 7:39
Mark Salsbery21-Sep-08 7:39 
QuestionRe: Detect MouseNotMove event Pin
baranils21-Sep-08 7:26
baranils21-Sep-08 7:26 
AnswerRe: Detect MouseNotMove event Pin
Mark Salsbery21-Sep-08 7:46
Mark Salsbery21-Sep-08 7:46 
GeneralRe: Detect MouseNotMove event Pin
baranils21-Sep-08 10:42
baranils21-Sep-08 10:42 
GeneralRe: Detect MouseNotMove event Pin
Mark Salsbery21-Sep-08 14:31
Mark Salsbery21-Sep-08 14:31 
GeneralRe: Detect MouseNotMove event Pin
baranils21-Sep-08 10:54
baranils21-Sep-08 10:54 
GeneralRe: Detect MouseNotMove event Pin
Mark Salsbery21-Sep-08 14:37
Mark Salsbery21-Sep-08 14:37 

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.