Click here to Skip to main content
15,897,891 members
Home / Discussions / C#
   

C#

 
QuestionSetForegroundWindow Pin
sucil20-Jan-10 0:24
sucil20-Jan-10 0:24 
AnswerRe: SetForegroundWindow Pin
daxfrost20-Jan-10 0:31
daxfrost20-Jan-10 0:31 
QuestionExport datagrid to excel or csv Pin
codenoobie19-Jan-10 23:55
codenoobie19-Jan-10 23:55 
AnswerRe: Export datagrid to excel or csv Pin
sanforjackass20-Jan-10 1:01
sanforjackass20-Jan-10 1:01 
GeneralRe: Export datagrid to excel or csv Pin
codenoobie20-Jan-10 1:24
codenoobie20-Jan-10 1:24 
QuestionXmlSerializer - usage within constructors Pin
lukeer19-Jan-10 23:07
lukeer19-Jan-10 23:07 
AnswerRe: XmlSerializer - usage within constructors Pin
Covean19-Jan-10 23:51
Covean19-Jan-10 23:51 
QuestionReturning a parameter from a stored proc Pin
jamesc6919-Jan-10 22:31
jamesc6919-Jan-10 22:31 
Hi,

I have a stored proc that at the end executes the following line:

Select @ID

In my C# I have the following to try and grab it:

SqlParameter AgentID = new SqlParameter("@ID", SqlDbType.Int, 4);
            AgentID.Direction = ParameterDirection.ReturnValue;
            sqlCmd.Parameters.Add(AgentID);

int NewAgentID = 0;
            try
            {
                  sqlCon.Open();
                  sqlCmd.ExecuteScalar();
                  sqlCon.Close();
                  NewAgentID = int.Parse(sqlCmd.Parameters["@ID"].Value.ToString());
                  return NewAgentID;
            }

In debug this seems to set NewAgentID to -1, however it should be a legitimately returned variable from the stored proc, any ideas what is wrong?
AnswerRe: Returning a parameter from a stored proc Pin
Bardy8519-Jan-10 23:05
Bardy8519-Jan-10 23:05 
GeneralRe: Returning a parameter from a stored proc Pin
J a a n s19-Jan-10 23:15
professionalJ a a n s19-Jan-10 23:15 
GeneralRe: Returning a parameter from a stored proc Pin
jamesc6920-Jan-10 22:55
jamesc6920-Jan-10 22:55 
GeneralDisable CD burning Pin
Member 321910419-Jan-10 22:20
Member 321910419-Jan-10 22:20 
GeneralRe: Disable CD burning Pin
Eddy Vluggen20-Jan-10 0:27
professionalEddy Vluggen20-Jan-10 0:27 
GeneralRe: Disable CD burning Pin
Member 321910420-Jan-10 7:01
Member 321910420-Jan-10 7:01 
GeneralRe: Disable CD burning Pin
Dave Kreskowiak20-Jan-10 7:36
mveDave Kreskowiak20-Jan-10 7:36 
GeneralRe: Disable CD burning Pin
Member 321910420-Jan-10 15:21
Member 321910420-Jan-10 15:21 
GeneralRe: Disable CD burning Pin
Dave Kreskowiak20-Jan-10 18:33
mveDave Kreskowiak20-Jan-10 18:33 
GeneralRe: Disable CD burning Pin
Member 321910421-Jan-10 16:52
Member 321910421-Jan-10 16:52 
GeneralRe: Disable CD burning Pin
Eddy Vluggen20-Jan-10 12:07
professionalEddy Vluggen20-Jan-10 12:07 
GeneralRe: Disable CD burning Pin
Member 321910420-Jan-10 15:26
Member 321910420-Jan-10 15:26 
GeneralRe: Disable CD burning Pin
Eddy Vluggen21-Jan-10 8:57
professionalEddy Vluggen21-Jan-10 8:57 
GeneralRe: Disable CD burning Pin
Member 321910421-Jan-10 16:50
Member 321910421-Jan-10 16:50 
GeneralRe: Disable CD burning Pin
Eddy Vluggen21-Jan-10 21:57
professionalEddy Vluggen21-Jan-10 21:57 
GeneralRe: Disable CD burning Pin
harold aptroot20-Jan-10 5:42
harold aptroot20-Jan-10 5:42 
QuestionSwitching to Embedded programming? Pin
ppayal19-Jan-10 21:59
ppayal19-Jan-10 21:59 

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.