Clyde Eisenbeis schrieb am 26.01.2017 um 18:45:
It appears that sqlite3 is not part of System.Data.SQLite.
Aaah! Now we get somewhere! You should have told us from the beginning
that you are using SQLite through the .NET/MONO Wrapper. All the
mentioning of sqlite3_bind_* and the like refer to the native interface
of SQLite.
Set up your command string with placeholders like others already stated:
" AND fstInfo LIKE ('%' || ?1 || '%') AND fstInfo
LIKE ('%' || ?2 || '%')"
Now add your values to the Parameters-Collection of your Command-Object:
myCmd.Parameters.Add(new SQLiteParameter(...));
Also seedocumentation to System.Data.Common
<https://msdn.microsoft.com/en-us/library/system.data.common%28v=vs.110%29.aspx> (especially DbCommand and DbParameter) which System.Data.SQLite is derived from.
If you are working with VS on windows, download the .chm-File from
http://system.data.sqlite.org/index.html/doc/trunk/Doc/SQLite.NET.chm?mimetype=application/x-chm
Then right-click on the file and open its properties. In the lower part of that dialog
you will find a security warning with an "Unblock"-button. Click it, and you
should be able to open the file.
If you don't have a .chm-reader, see
https://support.microsoft.com/en-us/help/917607/error-opening-help-in-windows-based-programs-feature-not-included-or-help-not-supported
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
