初学者问sql语句中@变量名赋值的问题。

[billtzh]

程序如下。但是运行后说Exception Details: System.Data.OracleClient.OracleException: ORA-01036: 非法的变量名/编号

我认为是SQL语句中的@变量并没有换掉。可是错在哪里呢？都是很简单的语句呀。

{如果SQL为string CommandText = "select * from tzhtable";即不用参数程序就对的。}

private void Button2_Click(object sender, System.EventArgs e)
{
string ConnectionString = "user id=tzh;data source=\"db01.centralsoft\";password=tzh";
string CommandText = "select * from tzhtable where age<@age";

OracleConnection myConnection = new OracleConnection(ConnectionString);
myConnection.Open();
OracleCommand myCommand = new OracleCommand (CommandText, myConnection);
myCommand.Parameters.Add("@age",OracleType.Int16).Value=13;

OracleDataReader myreader=myCommand.ExecuteReader(CommandBehavior.CloseConnection);
DataGrid2.DataSource=myreader;
DataGrid2.DataBind ();
}

[ahui_net]

就一个参数就
int nNumber = 13;
string CommandText = "select * from tzhtable where age < "+ nNumber;

[cmsoft]

@age这个参数名换掉，比如换成@myage，参数名不要与字段名相同

[hillseok]

在myCommand.Parameters.Add("@age",OracleType.Int16.Value=13);后加上
myCommand.Parameters["@age"].value=参数值;

[billtzh]

To cmsoft(韦小宝是我的老乡)(.net&java):

我换成了string CommandText = "select * from tzhtable where age<@myage";
myCommand.Parameters.Add("@myage",OracleType.Int16).Value=13;
还是不行。


TO hillseok(山海经)
我按你的改成
string CommandText = "select * from tzhtable where age<@myage";
OracleConnection myConnection = new OracleConnection(ConnectionString);
myConnection.Open();
OracleCommand myCommand = new OracleCommand (CommandText, myConnection);
myCommand.Parameters.Add("@myage",OracleType.Int16);
myCommand.Parameters["@myage"].Value=13;
OracleDataReader myreader=myCommand.ExecuteReader(CommandBehavior.CloseConnection);

还是不行。出同样的错

ORA-01036: 非法的变量名/编号
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.OracleClient.OracleException: ORA-01036: 非法的变量名/编号

Source Error:


Line 125:myCommand.Parameters.Add("@myage",OracleType.Int16).Value=13;
Line 126:
Line 127: OracleDataReader myreader=myCommand.ExecuteReader(CommandBehavior.CloseConnection);
Line 128: DataGrid2.DataSource=myreader;
Line 129: DataGrid2.DataBind ();

[tongzhenhua]

在Oracle中是用:变量名不是用@变量名
呵呵。enjoy