SQL Server Performance

Crystal Report in C#, Stored Procedure

Discussion in 'Non-Transact SQL Developer Performance Tuning' started by mastersql, Aug 24, 2007.

  1. mastersql New Member

    Crystal report in C# , stored procedure
    Dear Friends,
    I want to create a Crystal report in C# using Parameterised Storred Procedure
    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 would change the timeinterval and recordNo. According to change the
    timeinverval and Recordno we want my report
    I am new to this.
    If any one knows please let me know....if sample C#, Storedprocedure source
    code would be greatly appreciate.

    Thanks
    Ever Smiling
    Ashish
  2. satya Moderator

Share This Page