Question

c# dataAdapter.fill()报错“至少有一个参数没有指定” 求高手帮忙！

DateTime time1 = DateTimeOne.Value;
DateTime time2 = DateTimeTwo.Value;
//取得数据集
string connstring = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Users\zjs\Desktop\Curve\DynamicCurce\DynamicCurce\bin\Debug\CurceData.mdb";
System.Data.OleDb.OleDbConnection conn1 = new System.Data.OleDb.OleDbConnection(connstring);
System.Data.OleDb.OleDbCommand command1 = new System.Data.OleDb.OleDbCommand("select * from CurceValue where CurceDate between @time1 and @time2", conn1);
System.Data.OleDb.OleDbDataAdapter ada1 = new System.Data.OleDb.OleDbDataAdapter(command1);
DataSet c_ds = new DataSet();
try
{
conn1.Open();
ada1.Fill(c_ds);
}
finally
{
conn1.Close();
command1.Dispose();
conn1.Dispose();
}
//为报表浏览器指定报表文件
this.reportViewer1.LocalReport.ReportEmbeddedResource = "report.Report1.rdlc";
//指定数据集,数据集名称后为表,不是DataSet类型的数据集
this.reportViewer1.LocalReport.DataSources.Clear();
this.reportViewer1.LocalReport.DataSources.Add(new Microsoft.Reporting.WinForms.ReportDataSource("myds", c_ds.Tables[0]));
//显示报表
this.reportViewer1.RefreshReport();

Answer 1

问题在于你没有给两个参数@time1,@time2赋值。你的那种不叫给数据库参数赋值。而是给两个变量赋值，根本就没有传到数据库端。

var para = new []
{
new SqlParameter("@time1",SqlDbType.DateTime){Value =time1},
new SqlParameter("@time2",SqlDbType.DateTime){Value = time2},
}
在command1中执行时将声明的para参数传入方法中即可。

Answer 2

没看到 你给这两个参数@time1，@time2 负值呀 ！

Answer 3

没给 @time1 、 @time2参数传值

追问

DateTime time1 = DateTimeOne.Value;
DateTime time2 = DateTimeTwo.Value;
@time1 、 @time2这样赋值不对吗？应该怎么赋值？