OleDbCommand的参数问题求解！

SwnKai 2003-12-12 04:23:00

偶有一段代码如下：
OleDbConnection oleDbCon=new OleDbConnection(ConnectionStr);
oleDbCon.Open();
OleDbCommand oleDbCom=new OleDbCommand();
oleDbCom.CommandText="SELECT * FROM ?";
oleDbCom.Parameters.Add( "@TableName", OleDbType.VarChar).Value = TableName;
oleDbCom.Connection=oleDbCon;
oleDbCom.ExecuteReader();
oleDbCon.Close();

但是报错：ORA-00903: 表名无效

...全文

48 9 打赏收藏转发到动态举报

写回复

用AI写文章

9 条回复

切换为时间正序

请发表友善的回复…

发表回复

SwnKai 2003-12-12

打赏
举报

可是偶表"..."+TableName 的形式啊
偶要通过参数[oleDbCom.Parameters]传递啊

???2008 2003-12-12

打赏
举报

or try:
OleDbConnection oleDbCon=new OleDbConnection(ConnectionStr);
oleDbCon.Open();
OleDbCommand oleDbCom=new OleDbCommand();
oleDbCom.CommandText="SELECT * FROM " & TableName;

oleDbCom.Connection=oleDbCon;
oleDbCom.ExecuteReader();
oleDbCon.Close();

vb不好，不知道是否写错

???2008 2003-12-12

打赏
举报

try:
OleDbConnection oleDbCon=new OleDbConnection(ConnectionStr);
oleDbCon.Open();
OleDbCommand oleDbCom=new OleDbCommand();
oleDbCom.CommandText="SELECT * FROM " + TableName;

oleDbCom.Connection=oleDbCon;
oleDbCom.ExecuteReader();
oleDbCon.Close();

sunnysun67 2003-12-12

打赏
举报

Ole好像不支持 @TableName 的吧

SwnKai 2003-12-12

打赏
举报

还是没人知道?!!!!!!!!!!!!!!!!!!!!!

SwnKai 2003-12-12

打赏
举报

thanx

不过偶试过了还是不行的

CMIC 2003-12-12

打赏
举报

OleDbConnection oleDbCon=new OleDbConnection(ConnectionStr);
oleDbCon.Open();
OleDbCommand oleDbCom=new OleDbCommand();
oleDbCom.CommandText="SELECT * FROM @TableName ";
oleDbCom.Parameters.Add(new OleDbParameter("@TableName",OleDbType.VarChar));
oleDbCom.Parameters["@TableName"].Value = TableName;
oleDbCom.Connection=oleDbCon;
oleDbCom.ExecuteReader();
oleDbCon.Close();

SwnKai 2003-12-12