Tableadapter.Fill error with Date Parameter

[ACCESSDUMMY]

I'm trying to pass a date parameter into the Fill method of a tableadapter and I'm getting an error message stating "cannot convert from 'string' to 'System.DateTime?'.

Here's my code...

using MIS_Database.Schemas.Rpt3YrsDataSetTableAdapters;
using System.Data;
namespace MIS_Database.Schemas {
partial class Rpt3YrsDataSet
{
partial class sp3YrsReportDataTable
{
}

public void FillAll(string paramDate)
{
using (sp3YrsReportTableAdapter ThreeYrsReportadapt = new sp3YrsReportTableAdapter())
{
ThreeYrsReportadapt.ClearBeforeFill = true;
ThreeYrsReportadapt.Fill(this.sp3YrsReport, paramDate);
}
}
}



The build fails on the Fill line when it gets to the paramDate part. Does anyone have any suggestions on how to pass a date parameter?

 

[JurkMonkey]

Is your fill method expecting a DateTime value or a string value?

paramDate.ToString() may do what you need...

http://www.ubuntu.com/