Crystal report Line Graph+c# and Stored procedure

arthivb

Newcomer
Joined
Jun 12, 2003
Messages
2
Dear Friends,


I want dynamically create the Graph from C# application. The graph would be

timeInterval VS percentage.


timeInterval percentage Recordno

8/2/2003 10:11:00 AM 10 ABC123
8/3/2003 10:11:00 AM 20 ABC123
8/4/2003 11:11:00 AM 30 ABC123
8/5/2003 10:11:00 AM 75 ABC123
8/6/2003 10:11:00 AM 40 ABC123
8/7/2003 12:11:00 PM 25 ABC123
8/8/2003 10:11:00 AM 23 ABC123
8/9/2003 8:11:00 AM 7 ABC123

This is my stored procedure.

CREATE PROCEDURE sp_percentageGraph
(
@RecordNo INT,
@startDate varchar(40),
@endDate varchar(40)
)
AS
BEGIN


select PlugPercentage,TimeInspected from statistic where

RecordNo = @RecordNo and TimeIninterval between(@startDate) and (@endDate)
return

END
GO
I passed 3 input parametrs.
How to use this storedprocedure to my C# program and pass the parameters to

the crystal report.
The user woould change the timeinterval and recordNo.According to change the

timeinverval and Recordno we want draw the graph.


I am new to this.

If any one knows please let me know....if sample C#, Storedprocedure source

code would be greatly appreciate.

Thanks,
 
Back
Top