SQL高手请进:sql能在access里执行,在代码曝“无效的null使用”,即查不出结果出来

ReynoldCQ ReynoldCQ 墨衍会员 · AI 创作全网分发 墨衍智能分发 通过墨衍一键同步至各平台 可同步平台 CSDN微信公众号微博知乎掘金百家号博客园抖音小红书 你的文章也可以这样分发 墨衍会员 ¥399起/年,写一次发全网 我也要 + 加入社区
SQL语句:
string queryStringRgt = @"SELECT TB_YWDA.ywda_SeqNO as 顺序号, TB_YWDAJ.ywdaj_DirName as 档号, TB_YWDAJ.ywdaj_KeepPeriod as 保管期限, TB_YWDAJ.ywdaj_Year as 年度, "
+ " TB_YWDA.ywda_Responsible as 责任者, TB_YWDA.ywda_Title as 题名, TB_YWDA.ywda_PageNO as 页号, TB_YWDAJ.ywdaj_Type as 档案类别, "
+ " TB_YWDA.ywda_PageSum as 页数, TB_YWDA.ywda_CreatedTime as 成文时间, TB_YWDA.ywda_ID, TB_YWDA.ywdaj_ID FROM TB_YWDA left join TB_YWDAJ on TB_YWDA.ywdaj_ID = TB_YWDAJ.ywdaj_ID where CInt(TB_YWDA.ywdaj_ID) = '" + selectedYwdajID + "'";


数据加载代码:
OleDbCommand SQLQuery = new OleDbCommand();
DataTable data = new DataTable();

this.skinDataGridViewRgt.DataSource = null;
SQLQuery.Connection = null;
OleDbDataAdapter dataAdapter = null;
this.skinDataGridViewRgt.Columns.Clear(); // <-- clear columns
//---------------------------------
SQLQuery.CommandText = sqlQueryString;
SQLQuery.Connection = dataBase;
dataAdapter = new OleDbDataAdapter(SQLQuery);
MessageBox.Show("hah");
dataAdapter.Fill(data); //问题出在这一行
skinDataGridViewRgt.DataSource = data;


之前另一个sql语句时,都没有错误,改了之后就出现问题了,谢谢大神帮忙解决一下。
...全文
评论 8
收藏 已收藏
分享
返回顶部
ReynoldCQ
疑难问题 22,298 成员 121,727 内容