类型不匹配表达式

debugcn 发表于 Dev

Vignesh VerWisH

这是我尝试执行但出错的代码：

string g = dateTimePicker1.Value.ToString("dd-MM-yyyy");
string h = dateTimePicker2.Value.ToString("dd-MM-yyyy");

//string sql2 = @"select Loanno,PName,Duedate,sum(Rec) as rec,sum(Loanamt) as amt from Due where Duedate between [@date1] and [@date2] group by PName order by Loanno asc";

string sql2 = @"select Due.Loanno,Due.PName,Due.Duedate,sum(Due.Rec) as rec,sum(Due.Loanamt) as amt from Due  inner join Party_Det on Due.Loanno=Party_Det.Loanno where Due.Duedate between [@date1] and [@date2] group by Due.Loanno,Due.PName,Due.Duedate";

OleDbCommand cmd2 = new OleDbCommand(sql2, con);
cmd2.Parameters.AddWithValue("@date1", g);
cmd2.Parameters.AddWithValue("@date2", h);
cmd2.ExecuteNonQuery();

DataTable dt=new DataTable();
OleDbDataAdapter da = new OleDbDataAdapter(cmd2);
da.Fill(dt);

dataGridView1.DataSource = dt;
con.Close();

萨加尔·埃里亚斯·杰基（Saagar Elias Jacky）

尝试这个

string sql2 = @"select Due.Loanno, Due.PName, Due.Duedate, sum(Due.Rec) as rec,sum(Due.Loanamt) as amt from Due  inner join Party_Det on Due.Loanno=Party_Det.Loanno where Due.Duedate between @date1 and @date2 group by Due.Loanno,Due.PName,Due.Duedate";
OleDbCommand cmd2 = new OleDbCommand(sql2, con);

cmd2.Parameters.AddWithValue("@date1", dateTimePicker1.Value.Date);
cmd2.Parameters.AddWithValue("@date2", dateTimePicker2.Value.Date);

cmd2.ExecuteNonQuery();
DataTable dt=new DataTable();
OleDbDataAdapter da = new OleDbDataAdapter(cmd2);

da.Fill(dt);
dataGridView1.DataSource = dt;
con.Close();

添加：为什么需要使用Party_det表联接？您没有使用该表中的任何字段。确保Loanno两个表中的列具有相同的数据类型。

本文收集自互联网，转载请注明来源。

如有侵权，请联系[email protected] 删除。