Procedure or function 'ProcedureName ' expects parameter 'DateParameter', which was not supplied

Question

I am using Crystal Report and assigning a procedure with parameters as its data source. I'm getting this error:

Error:

Procedure or function 'sp_sale_report ' expects parameter '@SDate', which was not supplied

Code :

ReportDocument rprt = new ReportDocument();

rprt.Load(@"C:\Users\Zia Khan\Documents\Visual Studio 2015\Projects\lol\lol\Report\CrystalReport2.rpt");

SqlCommand cmd = new SqlCommand("sp_Sale_Report", con);
cmd.CommandType = CommandType.StoredProcedure;

cmd.Parameters.AddWithValue("@SaleID", dateTimePicker1.Value.ToShortDateString());

SqlDataAdapter sda = new SqlDataAdapter(cmd);

DataSet ds = new DataSet();
sda.Fill(ds, "Data_Table1");

rprt.SetDataSource(ds);
crystalReportViewer1.ReportSource = rprt;

Answer 1

You are passing the parameter @SaleID only. It should be @SDate.

Change to this:

cmd.Parameters.AddWithValue("@SDate", dateTimePicker1.Value.ToShortDateString());