How to manipulate the Firebird database in .NET

xiaoxiao2021-03-06  69

When you study .Net and Firebird databases, the biggest problem is how to connect to open the database. When you debug the program, you will always make such an error, but just try to find the answer, you will succeed! First, install firebird .NET DATA Provider To access the Firebord database in .NET, you must download the corresponding version of the .NET Framework's corresponding version of Firebird .NET DATA Provider (URL: http://firebird.sourceforge.net/index.php?op=files&id=NetProvider) I downloaded Version 1.6.3. Use of the version of the .NET Framework 1.1. After the installation is complete, you should restart your computer, although there is no prompt to restart. Second, add items to the toolbox web form to select the fbconnection, fbcommandbuilde, fcommand, fbdataadapter option, and you can use this control in the page view after you are determined. Third, other precautions are in the design, especially the writing of SQL statements. I believe that the following errors appear in the debug. Dynamic SQL ERRORSQL ERROR CODE = -204Table Unknmasternameat line 1, Column 15. In fact, this is a SQL statement written wrong, because his writing format is not quite, the online use of the following format: "SELECT *" MyTable / "" But so I didn't debug it, I don't know where I have a problem. I wrote this and debug. "Select * from" "MyTable" "If you select, you need to add quotation marks as follows:" SELECT "" C1 "", "C2" "" "" "" "" Note The above problem should be operated Firebird database There is nothing wrong with it!

转载请注明原文地址:https://www.9cbs.com/read-87760.html

New Post(0)