oledb/ado.net: command's text, parameters replaced


is illusory calm an oledbcommand parameters transposed values? e.g. formula next i'm looking proceed query calm



select * my_table where c1 = 'hello' c2 = 'world'


after i finished assigning parameters.



var query = "select * my_table where c1 = ? c2 = ?";
var cmd = new oledbcommand(query, connection);
cmd.parameters.add("@p1", oledbtype.wchar).value = "hello";
cmd.parameters.add("@p2", oledbtype.wchar).value = "world";


Comments

Popular posts from this blog

list macos calm editors formula editors

how i practical urls indicate .aspx pages asp.net deployed an iis? (preferably but iis)

jaxb - xjc - reworking generated typesafe enum category members