Crystal report Line graph and C# , stored procedure

  • Thread starter Thread starter Joe
  • Start date Start date
J

Joe

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,
Joe
 
Back
Top