C#连接嵌入式小型数据库firebird,操作数据

怎么创建数据库请参考
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();

        }
    }
}

报错解决:

这里写图片描述

这里写图片描述

评论 7
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包

打赏作者

王焜棟琦

你的鼓励将是我创作的最大动力

¥1 ¥2 ¥4 ¥6 ¥10 ¥20
扫码支付:¥1
获取中
扫码支付

您的余额不足,请更换扫码支付或充值

打赏作者

实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值