Biegral Blog

怎么创建数据库请参考
http://blog.csdn.net/u011511086/article/details/79174680

C#測試firebird嵌入式數據庫demo地址下載
https://pan.baidu.com/s/1dFZvNtZ

此示例demo的csdn下载地址
http://download.csdn.net/download/u011511086/10226084

數據庫下載：
https://www.firebirdsql.org/en/firebird-2-5-8/

.NET驅動下載
https://www.firebirdsql.org/en/additional-downloads/

C#示例代碼
https://www.firebirdsql.org/en/net-examples-of-use/

项目bin目录

using FirebirdSql.Data.FirebirdClient;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Data;

namespace FirebirdTest
{
    class Program
    {
        static void Main(string[] args)
        {
            //這裡的fbembed的版本是2.5.8
            FbConnectionStringBuilder sb = new FbConnectionStringBuilder();
            sb.ServerType = FbServerType.Embedded;
            //SYSDBA
            sb.UserID = "SYSDBA";
            //masterkey
            sb.Password = "masterkey";
            sb.Database = AppDomain.CurrentDomain.BaseDirectory.Replace("bin\\Debug\\", "") + "DB\\TEST.FDB";
            FbConnection connection1 = new FbConnection(sb.ToString());
            connection1.Open();

            //事務       
            FbTransaction tran = connection1.BeginTransaction();
            try
            {
                //插入
                FbCommand cmd2 = connection1.CreateCommand();
                cmd2.Transaction = tran;
                string sql2 = "INSERT INTO USERINFO (ID, NAME, SPASSWORD) VALUES (@id, @name, @password)";
                cmd2.CommandText = sql2;
                cmd2.Parameters.Add(new FbParameter("@id", Guid.NewGuid().ToString()));
                cmd2.Parameters.Add(new FbParameter("@name", "歐陽修0"));
                cmd2.Parameters.Add(new FbParameter("@password", "sdf56756"));
                int count = cmd2.ExecuteNonQuery();
                cmd2.Dispose();

                //修改
                FbCommand updateCmd = connection1.CreateCommand();
                updateCmd.Transaction = tran;
                string sql_update = "update USERINFO set  NAME='小萬1' where id='700A096E-5B28-7AF7-8D61-C3E0D0FF93FF'";
                updateCmd.CommandText = sql_update;
                int count_up = updateCmd.ExecuteNonQuery();
                updateCmd.Dispose();

                tran.Commit();
            }
            catch (Exception ex)
            {
                tran.Rollback();
            }

            //查询
            string sql = "select * from USERINFO";
            FbCommand cmd = new FbCommand(sql, connection1);
            FbDataAdapter dp = new FbDataAdapter(cmd);
            DataTable dt = new DataTable();
            dp.Fill(dt);
            dp.Dispose();
            cmd.Dispose();

            connection1.Close();
            connection1.Dispose();

        }
    }
}

报错解决：