private void btnOk_Click(object sender, System.EventArgs e)
{
OracleConnection connection = new OracleConnection("Data Source=fc1;User ID=real;Password=real");
OracleCommand command = new OracleCommand("IP_NEWDANUM", connection);
connection.Open();
command.CommandType = CommandType.StoredProcedure;
//command.Parameters.Add("yy_NumID",Convert.ToInt32(DropDownList1.SelectedValue));
command.Parameters.Add("yy_NumID",496);
//myCommand.Parameters.Add("RET_CURSOR", OracleType.Cursor);
OracleParameter ret = command.Parameters.AddWithValue("yy_return", OracleType.VarChar);
myCommand.Parameters.AddWithValue("datvalue", DBNull.Value);
command.ExecuteNonQuery();
this.TextBox1.Text=Convert.ToString(ret.Value);
}提示“System.Data.OracleClient.OracleParameterCollection”并不包含对“AddWithValue”的定义
{
OracleConnection connection = new OracleConnection("Data Source=fc1;User ID=real;Password=real");
OracleCommand command = new OracleCommand("IP_NEWDANUM", connection);
connection.Open();
command.CommandType = CommandType.StoredProcedure;
//command.Parameters.Add("yy_NumID",Convert.ToInt32(DropDownList1.SelectedValue));
command.Parameters.Add("yy_NumID",496);
//myCommand.Parameters.Add("RET_CURSOR", OracleType.Cursor);
OracleParameter ret = command.Parameters.AddWithValue("yy_return", OracleType.VarChar);
myCommand.Parameters.AddWithValue("datvalue", DBNull.Value);
command.ExecuteNonQuery();
this.TextBox1.Text=Convert.ToString(ret.Value);
}提示“System.Data.OracleClient.OracleParameterCollection”并不包含对“AddWithValue”的定义
SqlCommand Com = new SqlCommand("pro_x", Con);
Com.CommandType = CommandType.StoredProcedure;
Com.Parameters.Add(new SqlParameter("@usr",SqlDbType.VarChar));
Com.Parameters["@usr"].Value = TextBox1.Text.Trim()+'%';
Con.Open();
Com.ExecuteNonQuery();
这样看看
参数名。value
要添加的值。这是前后两个参数
//cmd.Parameters.AddWithValue("@id", PageItem); 这个就好使 string strWhere = "'%美%'";
strSql = "SELECT * FROM area Where [name] like @strWhere";//这个就不好使 cmd.Parameters.AddWithValue("@strWhere", strWhere);
cmd.CommandText = strSql;
OleDbDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
Response.Write(dr[0] + " <br>");
}
}
}
这样改改试试
string strWhere = "美";
strSql = "SELECT * FROM area Where [name] like '%'+@strWhere+'%'
AddWithValue(string parameterName, object value)方法OracleConnection conn = new OracleConnection("Data Source=oracledb;
User Id=UserID;Password=Password;");
OracleCommand cmd = new OracleCommand();
cmd.Connection = conn;
cmd.CommandText = "";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("", OracleType.Number).Value = 102;
conn.Open();
int rowsAffected = cmd.ExecuteNonQuery();
conn.Close();
http://www.cnblogs.com/datasky/archive/2007/11/07/952141.html
OracleParameter ret = command.Parameters.AddWithValue("yy_return", OracleType.VarChar).value=……;
不知道可不可以 sql是可以的
你可能是没有传他的value打 OracleParameter ret = command.Parameters.AddWithValue( 会出来提示 你看下里面的参数是什么