首页 诗词 字典 板报 句子 名言 友答 励志 学校 网站地图
当前位置: 首页 > 教程频道 > .NET > C# >

多步 OLE DB 操作产生异常。如果可能,请检查每个 OLE DB 状态值

2012-01-26 
多步 OLE DB 操作产生错误。如果可能,请检查每个 OLE DB 状态值。OleDbConnectionMyConnnewOleDbConnection

多步 OLE DB 操作产生错误。如果可能,请检查每个 OLE DB 状态值。
OleDbConnection   MyConn   =   new   OleDbConnection( "Provider=Microsoft.Jet.OLEDB.4.0;   "+connectionString);
                //MyConn.Open();
                OleDbDataAdapter   MyAdapter   =   new   OleDbDataAdapter();
                OleDbCommand   MyCmd   =   new   OleDbCommand(dlstr,   MyConn);
                MyAdapter.SelectCommand   =   MyCmd;
                DataSet   myDataSet   =   new   DataSet();
                int   startdata   =   datasize   *   (Int32.Parse(pagenum)   -   1);
                MyAdapter.Fill(myDataSet,   startdata,   datasize,   "result ");


以上是我的代码,我看了别的帖子,说这个错误是因为字段不够长,可是我没有理解,什么字段呀?

[解决办法]
dlstr打印出来
[解决办法]
"select para_cd,para_drpt,amt_vlu,para_typ,null as apply_dt from sysconf where para_typ= '83 ' and subcd_flg= '0 ' union select incentive_cd as para_cd,incentive_drpt as para_drpt,apply_point as amt_vlu, ' ' as para_typ,apply_dt from icapplypoint where ic_num= ' " + Session[ "ic_num "].ToString() + " ' ";
===================================================
上下的5个字段数据类型都兼容么?
para_cd,para_drpt,amt_vlu,para_typ,null as apply_dt
incentive_cd as para_cd,incentive_drpt as para_drpt,apply_point as amt_vlu, ' ' as para_typ,apply_dt

热点排行