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
Post a Comment