could you tell me how to use dbcommand to find a row with given guid
primarykey?
It can't work:(
DbCommand command = new DbCommand("select * From test where Id =
@Id",connection);
DbParameter parameter =command.CreateParameter();
parameter.ParameterName = "@Id";
parameter.Value = a guid that exist in table;
DbDataAdapter adapter = new DbDataAdapter(command);
adapter.fill(table);
then table's rows.count =0;but when i use FbCommand and FbDataAdapter,it's
work fine.
two way:
1.what's wrong for the codes? or
2.If I want use "select * from table where id = guid",how to write the
sqlStetement,I know there's
a way to write the sql,but how to write it?
I only use "'"+Encoding.Default.GetString(aGuid.ToByteArray()) +"'",It can't
work.
How to write it?
thanks!
--
View this message in context:
http://www.nabble.com/How-to-use-sql-to-insert-record-with-guid--t1427996.html#a3878481
Sent from the firebird-net-provider forum at Nabble.com.
-------------------------------------------------------
This SF.Net email is sponsored by xPML, a groundbreaking scripting language
that extends applications into web and mobile media. Attend the live webcast
and join the prime developer group breaking into this new coding territory!
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&dat=121642
_______________________________________________
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
