private string query = "select * from tb_zone t where t.employee=:p1 :p2 "; public void test() { using (OracleConnection connection = new OracleConnection(connectionString)) { connection.Open(); OracleCommand cmd = new OracleCommand(query, connection); cmd.Parameters.AddWithValue("p1", 8434); //Substitution cmd.Parameters.AddWithValue("p2", " and t.rkc is not null "); MessageBox.Show( cmd.ExecuteOracleScalar().ToString()); } }
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)