Click here to Skip to main content
16,005,169 members
Home / Discussions / C#
   

C#

 
GeneralRe: Setting BackColor on TabControl Pin
LannieK15-Dec-04 10:39
LannieK15-Dec-04 10:39 
GeneralHidding Properties in property grid on run time Pin
theali15-Dec-04 8:14
theali15-Dec-04 8:14 
GeneralRe: Hidding Properties in property grid on run time Pin
leppie15-Dec-04 8:37
leppie15-Dec-04 8:37 
GeneralHidding Properties in property grid on run time Pin
Anonymous15-Dec-04 9:03
Anonymous15-Dec-04 9:03 
GeneralRe: Hidding Properties in property grid on run time Pin
Mathew Hall15-Dec-04 15:58
Mathew Hall15-Dec-04 15:58 
GeneralThank you Pin
theali15-Dec-04 23:15
theali15-Dec-04 23:15 
GeneralProblem with stored procedure/C# code Pin
ronin177015-Dec-04 7:02
ronin177015-Dec-04 7:02 
GeneralRe: Problem with stored procedure/C# code Pin
Colin Angus Mackay15-Dec-04 7:33
Colin Angus Mackay15-Dec-04 7:33 
ronin1770 wrote:
CREATE PROCEDURE spNumOfUnReadMemos
@EmpTo char(6), @NumOfUnReadMemos int OUTPUT
AS
SELECT COUNT(EmpTo) FROM tblMemoManagement WHERE
EmpTo=@EmpTo AND ReadYesNo='NO'
RETURN;
GO


No where in this stored procedure is the @NumOfUnReadMemos assigned so the output parameter will not contain anything.

You have two choices.
1. Assign the value to the output parameter
2. Access the Stored Procedure in .NET using ExecuteScalar()


ronin1770 wrote:
//retVal = int.Parse(cmdMemo.Parameters[1].Value.ToString());

I'm guessing that this is where the parser error occurred. The reason is that the value, when converted to a string, is not a number, so the parser throws an exception. It isn't a number because the stored procedure never assigned anything to the output parameter.


Do you want to know more?
WDevs.com - Member's Software Directories, Blogs, FTP, Mail and Forums


GeneralRe: Problem with stored procedure/C# code Pin
ronin177015-Dec-04 7:38
ronin177015-Dec-04 7:38 
GeneralHidden MainForm at startup Pin
andreas_farnstrand15-Dec-04 6:11
andreas_farnstrand15-Dec-04 6:11 
GeneralRe: Hidden MainForm at startup Pin
Alex Korchemniy15-Dec-04 7:33
Alex Korchemniy15-Dec-04 7:33 
GeneralRe: Hidden MainForm at startup Pin
Matt Gerrans15-Dec-04 7:48
Matt Gerrans15-Dec-04 7:48 
GeneralRe: Hidden MainForm at startup Pin
Alex Korchemniy15-Dec-04 8:16
Alex Korchemniy15-Dec-04 8:16 
GeneralRe: Hidden MainForm at startup Pin
Matt Gerrans15-Dec-04 8:50
Matt Gerrans15-Dec-04 8:50 
GeneralRe: Hidden MainForm at startup Pin
LannieK16-Dec-04 4:01
LannieK16-Dec-04 4:01 
GeneralRe: Hidden MainForm at startup Pin
Matt Gerrans16-Dec-04 9:51
Matt Gerrans16-Dec-04 9:51 
GeneralRichTextBox loosing embedded objects Pin
benjymous15-Dec-04 5:34
benjymous15-Dec-04 5:34 
GeneralRe: RichTextBox loosing embedded objects Pin
Judah Gabriel Himango15-Dec-04 7:43
sponsorJudah Gabriel Himango15-Dec-04 7:43 
GeneralTimer in Win Service not Ticking Pin
Doug Wilson15-Dec-04 1:50
Doug Wilson15-Dec-04 1:50 
GeneralRe: Timer in Win Service not Ticking Pin
Doug Wilson15-Dec-04 2:01
Doug Wilson15-Dec-04 2:01 
GeneralRe: Timer in Win Service not Ticking Pin
Stefan Troschuetz15-Dec-04 2:23
Stefan Troschuetz15-Dec-04 2:23 
GeneralRe: Timer in Win Service not Ticking Pin
thuchv8714-Sep-10 21:28
thuchv8714-Sep-10 21:28 
GeneralGDI+ VS DirectX Pin
G.Ringbom15-Dec-04 1:25
G.Ringbom15-Dec-04 1:25 
GeneralRe: GDI+ VS DirectX Pin
Daniel Turini15-Dec-04 1:40
Daniel Turini15-Dec-04 1:40 
GeneralRe: GDI+ VS DirectX Pin
Alex Korchemniy15-Dec-04 7:34
Alex Korchemniy15-Dec-04 7:34 

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.