error in reportviewer date parameters

Question

0.00/5 (No votes)

See more:

When i linked my stored procedure to reportviewer in C# i get this error:

argument 1 cannot convert string to System.datetime
argument 2 cannot convert string to System.datetime

C#

this.WaybillsTableAdapter.Fill(this.DataSet1.Waybills, textBox3.Text, textBox4.Text, textBox1.Text);

textbox3 parameter is stardate
textbox4 parameter is enddate

anybody have a idea how to fix this?

This is my stored procedure:

SQL

create proc GenerateInvoice
@StartDate date ,
@EndDate date ,
@ReceiverName varchar(30) 

AS

SELECT         Waybills.SenderName, Waybills.SenderAddress, Waybills.SenderContact, Waybills.ReceiverName, Waybills.ReceiverAddress, 
                         Waybills.ReceiverContact, Waybills.UnitDescription, Waybills.UnitWeight, Waybills.DateReceived, Waybills.Payee, 
                          Payments.Amount, Payments.PaymentDate, Cycle.CycleNumber, Cycle.StartDate, Cycle.EndDate
FROM            Waybills CROSS JOIN
                         Payments CROSS JOIN
                         Cycle
WHERE Waybills.ReceiverName = @ReceiverName
AND (Waybills.DateReceived BETWEEN (@StartDate) AND (@EndDate))

go

Posted 16-Sep-12 2:45am

GoggatjieLiesl

Updated 16-Sep-12 4:49am

Sandeep Mewara

v2

Add a Solution

2 solutions

Add a Solution

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

Sandeep Mewara · Answer 1 · 2012-09-16T04:53:00

textbox3 parameter is stardate
textbox4 parameter is enddate
Even though the parameters are of date, but they are being passed through a textbox text. Thus, they are mere strings (and not date even if it is of date format)

You need to convert the string into datetime and then pass on to SP. Use Convert.ToDateTime() or DateTime.Parse() for it.
Try:

C#

this.WaybillsTableAdapter.Fill(this.DataSet1.Waybills, Convert.ToDateTime(textBox3.Text), Convert.ToDateTime(textBox4.Text), textBox1.Text);

BTW, above one is a quick fix. You should first check the text and see if correctly converted into DateTime. Further, may be you can try to use datepicker control instead of a textbox for date fields.

Maciej Los · Answer 2 · 2012-09-16T06:03:00

Sandeep Mewara answer is good and i would like to turn your atention for your SP.

SQL

create proc GenerateInvoice
@StartDate date ,
@EndDate date ,
@ReceiverName varchar(30)

As far as i know the date input parameter is only avalible for MS SQL Server 2012. In other (previous) versions, you need to use DateTime. More at: http://msdn.microsoft.com/en-us/library/ms186724.aspx[^]

The where condition is more readible for:

SQL

WHERE (Waybills.ReceiverName = @ReceiverName) AND (Waybills.DateReceived BETWEEN @StartDate AND @EndDate)

error in reportviewer date parameters

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0

error in reportviewer date parameters

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0

Existing Members

...or Join us