OleDbCommand的参数问题 求解！

[SwnKai]

偶有一段代码如下：
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: 表名无效

[SwnKai]

up

• 打赏
• 举报

回复 赞

[SwnKai]

没人知道的么?

• 打赏
• 举报

回复 赞

[CMIC]

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]

thanx

不过偶试过了 还是不行的

• 打赏
• 举报

回复 赞

[SwnKai]

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

• 打赏
• 举报

回复 赞

[sunnysun67]

Ole好像不支持 @TableName 的吧

• 打赏
• 举报

回复 赞

[???2008]

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

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

• 打赏
• 举报

回复 赞

[???2008]

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不好，不知道是否写错

• 打赏
• 举报

回复 赞

[SwnKai]

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

• 打赏
• 举报

回复 赞