Crystal Reprot Error

Question

2.50/5 (2 votes)

See more:

, +

-3 down vote favorite

I'm working on my app which creates a Crystal Report. However, when i run the application I get the following error:

The number of parameters does not match number of values for stored procedure

Can anyone help me solve this?

Here is the stored procedure...

SQL

ALTER procedure [dbo].[spcustomer]
    @ContactName nvarchar(30),
    
as

   select * 
   from Customers 
   where ContactName=@ContactName

...and here is the function...

C#

public static CrystalReport1 getcutomer(string ContactName)
{
    Database db = DatabaseFactory.CreateDatabase("myconn");

    DataSet ds = db.ExecuteDataSet("spcustomer", new object[] { ContactName}));
    ds.Tables[0].TableName = "Customers";
    CrystalReport1 report = new CrystalReport1();
    report.SetDataSource(ds);

    return report;
}

The code to execute the report is...

C#

protected void Button1_Click(object sender, EventArgs e)
{
    CrystalReportViewer1.ReportSource = ClassLibrary4.Class1.getcutomer(TextBox1.Text);
    CrystalReportViewer1.DataBind();
}

here i want to know that

i have also other columns in table customer i,e ContactTitle,Address and city
then how i write in store procedure according to this and i seaerch through name in crystal report when i enter name then their contacttitle address and city is appear in report???how i do this...

Posted 24-Mar-13 2:35am

ariesareej

Updated 24-Mar-13 3:46am

Prasad Khandekar

v2

Add a Solution

1 solution

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Prasad Khandekar · Answer 1 · 2013-03-24T04:00:00

Hello,

You can write the stored procedure as shown below

SQL

CREATE PROCEDURE spcustomer
    @ContactName    NVARCHAR(30) = NULL,
    @ContactTitle   NVARCHAR(40) = NULL,
    @Address        NVARCHAR(80) = NULL,
    @City           NVARCHAR(30) = NULL
AS
    SELECT * 
    FROM customers c
    WHERE (c.ContactName = @ContactName OR @ContactName IS NULL)
          AND (c.ContactTitle = @ContactTitle OR @ContactTitle IS NULL)
          AND (c.Address = @Address OR @Address IS NULL)
          AND (c.City = @City OR @City IS NULL);

NotePlease not that passing and empty string to this procedure may not return rows as empty string is not same as NULL value.

Here is a code snippet depicting one of the possible way for calling the report

C#

public static CrystalReport1 getcutomer(string ContactName, string strTitle, string strAddress, string strCity)
{
    string[] arrParams = new string[4];
    arrParams[0] = (String.IsNullOrEmpty(ContactName) ? null : ContactName);
    arrParams[1] = (String.IsNullOrEmpty(strTitle) ? null : strTitle);
    arrParams[2] = (String.IsNullOrEmpty(address) ? null : strAddress);
    arrParams[3] = (String.IsNullOrEmpty(strCity) ? null : strCity);

    Database db = DatabaseFactory.CreateDatabase("myconn");
 
    DataSet ds = db.ExecuteDataSet("spcustomer",  arrParams);
    ds.Tables[0].TableName = "Customers";
    CrystalReport1 report = new CrystalReport1();
    report.SetDataSource(ds);
 
    return report;
}

Crystal Reprot Error

1 solution

Solution 1

Add your solution here

Preview 0

Crystal Reprot Error

1 solution

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us