OleDbDataAdapter("SELECT tblRlSyb.* FROM tblRlSyb WHERE rlType = " + txtRlkID.Value + " ORDER BY tblRlSyb.RowOrd",oldOdcf.OleDbCon);
改成:
OleDbDataAdapter("SELECT tblRlSyb.* FROM tblRlSyb WHERE rlType = '" + txtRlkID.Value + "' ORDER BY tblRlSyb.RowOrd",oldOdcf.OleDbCon);sql语句中,字段的值要用单引号引起来!
改成:
OleDbDataAdapter("SELECT tblRlSyb.* FROM tblRlSyb WHERE rlType = '" + txtRlkID.Value + "' ORDER BY tblRlSyb.RowOrd",oldOdcf.OleDbCon);sql语句中,字段的值要用单引号引起来!
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货