Click here to Skip to main content
15,909,953 members
Home / Discussions / C#
   

C#

 
GeneralRe: How to Select all items in CheckedListBox with an itam in a CheckedListBox ... Pin
Shajeel21-Nov-06 20:38
Shajeel21-Nov-06 20:38 
GeneralRe: How to Select all items in CheckedListBox with an itam in a CheckedListBox ... Pin
Christian Graus21-Nov-06 19:01
protectorChristian Graus21-Nov-06 19:01 
GeneralRe: How to Select all items in CheckedListBox with an itam in a CheckedListBox ... Pin
Steve Echols21-Nov-06 19:18
Steve Echols21-Nov-06 19:18 
QuestionDateTime Formatting - lose the time Pin
Jagannatha10821-Nov-06 16:16
Jagannatha10821-Nov-06 16:16 
AnswerRe: DateTime Formatting - lose the time Pin
Jon Sagara21-Nov-06 16:46
Jon Sagara21-Nov-06 16:46 
GeneralRe: DateTime Formatting - lose the time Pin
Jagannatha10822-Nov-06 8:26
Jagannatha10822-Nov-06 8:26 
GeneralRe: DateTime Formatting - lose the time Pin
Jon Sagara22-Nov-06 9:10
Jon Sagara22-Nov-06 9:10 
GeneralRe: DateTime Formatting - lose the time Pin
Jagannatha10822-Nov-06 9:17
Jagannatha10822-Nov-06 9:17 
So what your saying is...

Change,
ALTER PROCEDURE dbo.ShortCallsDateRange
(
@FromDate DATETIME,
@ToDate DATETIME,
@CallCount INT OUTPUT
)
AS
BEGIN
SELECT @CallCount = Count(*)
FROM HD_Call
WHERE (CONVERT(DATETIME, dateraised, 101) >= @FromDate AND (CONVERT(DATETIME, dateraised, 101) < @ToDate));


SELECT call, status, assignee, dateraised, shortrequest, shortaction
FROM HD_Call
WHERE (CONVERT(DATETIME, dateraised, 101) >= @FromDate AND (CONVERT(DATETIME, dateraised, 101) < @ToDate))
END
RETURN

To

ALTER PROCEDURE dbo.ShortCallsDateRange
(
@FromDate VARCHAR,
@ToDate VARCHAR,
@CallCount INT OUTPUT
)
AS
BEGIN
SELECT @CallCount = Count(*)
FROM HD_Call
WHERE (CONVERT(VARCHAR, dateraised, 101) >= @FromDate AND (CONVERT(VARCHAR, dateraised, 101) < @ToDate));


SELECT call, status, assignee, dateraised, shortrequest, shortaction
FROM HD_Call
WHERE (CONVERT(VARCHAR, dateraised, 101) >= @FromDate AND (CONVERT(VARCHAR, dateraised, 101) < @ToDate))
END
RETURN

Sorry for being confusing.

I was not sure if I could do the convert thing with datetime variables from C# to Sproc.

I will give it a go now.

Thanks for your persistent patients.
GeneralRe: DateTime Formatting - lose the time [modified] Pin
Jon Sagara22-Nov-06 9:29
Jon Sagara22-Nov-06 9:29 
QuestionC# and networking with Ethernet Bridge... Pin
SCSUVulcan21-Nov-06 14:30
SCSUVulcan21-Nov-06 14:30 
AnswerRe: C# and networking with Ethernet Bridge... Pin
Paul Conrad21-Nov-06 15:05
professionalPaul Conrad21-Nov-06 15:05 
AnswerRe: C# and networking with Ethernet Bridge... Pin
Russell Jones21-Nov-06 21:07
Russell Jones21-Nov-06 21:07 
QuestionResources in design-time Pin
Anton Afanasyev21-Nov-06 13:56
Anton Afanasyev21-Nov-06 13:56 
QuestionThreads and KeyBoard Hook Pin
ranzask21-Nov-06 13:24
ranzask21-Nov-06 13:24 
AnswerRe: Threads and KeyBoard Hook Pin
Judah Gabriel Himango21-Nov-06 13:29
sponsorJudah Gabriel Himango21-Nov-06 13:29 
GeneralRe: Threads and KeyBoard Hook Pin
ranzask21-Nov-06 13:39
ranzask21-Nov-06 13:39 
GeneralRe: Threads and KeyBoard Hook Pin
Judah Gabriel Himango21-Nov-06 15:39
sponsorJudah Gabriel Himango21-Nov-06 15:39 
GeneralRe: Threads and KeyBoard Hook Pin
ranzask21-Nov-06 22:00
ranzask21-Nov-06 22:00 
GeneralRe: Threads and KeyBoard Hook Pin
Judah Gabriel Himango22-Nov-06 5:44
sponsorJudah Gabriel Himango22-Nov-06 5:44 
QuestionError CS1705 Pin
jimNLX21-Nov-06 10:27
jimNLX21-Nov-06 10:27 
AnswerRe: Error CS1705 Pin
George L. Jackson21-Nov-06 12:54
George L. Jackson21-Nov-06 12:54 
QuestionRemoting and controlling access to properties Pin
Wjousts21-Nov-06 7:51
Wjousts21-Nov-06 7:51 
AnswerRe: Remoting and controlling access to properties Pin
ednrgc21-Nov-06 8:46
ednrgc21-Nov-06 8:46 
AnswerRe: Remoting and controlling access to properties Pin
ednrgc21-Nov-06 8:54
ednrgc21-Nov-06 8:54 
GeneralRe: Remoting and controlling access to properties Pin
Wjousts21-Nov-06 11:04
Wjousts21-Nov-06 11:04 

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.