display data to reports via a stored proceedure

Peter Dzuya

Hi All. Still new to C#.

I have a code as shown below that I used to obtain data from a stored procedure query that throws an error "Procedure or function 'RptLedgerByDate' has too may arguments specified".

public bool LoadReport()

{

SqlConnection conReport = new SqlConnection(ConfigurationManager.ConnectionStrings["makConnection"].ToString());

SqlCommand cmdReport = new SqlCommand();

cmdReport.Connection = conReport;

cmdReport.CommandType = CommandType.StoredProcedure;

cmdReport.CommandText = "RPTLedgerByDate";

cmdReport.Parameters.AddWithValue("@glCode", GlCode);

cmdReport.Parameters.AddWithValue ( "@fromDate", FromDate );

cmdReport.Parameters.AddWithValue ( "@toDate", ToDate );

SqlDataReader drReport;

DataSet dsReport = new dsReports();

conReport.Open();

drReport = cmdReport.ExecuteReader();

dsReport.Tables[0].Load(drReport);

drReport.Close();

conReport.Close();

if (!(dsReport.Tables[0].Rows.Count > 0))

{

MessageBox.Show("No Available Report Data to Display.",

"SMIS 2015", MessageBoxButtons.OK, MessageBoxIcon.Information);

isReady = false;

this.Close();

}

I shall be glad if I get assisted. Thanks

6 Replies

Know the answer? Post it — somebody with the same question will find it here.

Pankaj Kumar Choudhary11y ago
Accepted answer
hello @Peter in your SP [RPTLedgerByDate]( @fromDate datetime, @toDate datetime )
you are defined two argument but passing three arguments

cmdReport.Parameters.AddWithValue("@glCode", GlCode);
cmdReport.Parameters.AddWithValue ( "@fromDate", FromDate );
cmdReport.Parameters.AddWithValue ( "@toDate", ToDate );

in your Sp you do no define @glCode it may be possible that error was occur due to this

@glCode
Pankaj Kumar Choudhary11y ago
It is my Pleasure @Peter that i helped you.......
Peter Dzuya11y ago
Thank you so much @Pankaj. I added @glCode in the SP and it worked. Thanks once more.
Vergel Aranas11y ago
Hi, try to use microsoft report viewer. Create a view then use that in your dataset. Very easy to create a report very accurate. Visit this tutorial. https://www.youtube.com/watch?v=ociTNFwKii0, https://www.youtube.com/watch?v=nQvWNAldA1E.
Peter Dzuya11y ago
Hi Pankaj. Thanks for your prompt rescue. I have tested the SP and that it is very much okay. here below is an extract. USE [StockManagement] GO /****** Object: StoredProcedure [dbo].[RPTLedgerByDate] Script Date: 01/04/2015 19:32:56 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO ALTER PROCEDURE [dbo].[RPTLedgerByDate]( @fromDate datetime, @toDate datetime ) AS BEGIN -- SET NOCOUNT ON added to prevent extra result sets from -- interfering with SELECT statements. SET NOCOUNT ON; SELECT [Date],[ReceiptNo],[Details],[Debit],[Credit] FROM [StockManagement].[dbo].[Ledger] WHERE [Date] >= @fromDate and [Date] <= @toDate; RETURN END I get an error in the c# code when I debug. Thanks.
Pankaj Kumar Choudhary11y ago
Hello @Peter it may be possible that there is difference b/w no of arguments in stored procedure in Db and no of parameters that your are passing from application.

So first check your SP in DB and for this you can use this query

EXEC SP_HelpText 'STOREDProcedure Name'
and check that there is no of argument are same as no of parameters which your passing or not.