c# 连接本地的sdf数据库文件

最新推荐文章于 2024-08-06 11:37:25 发布

zuoyefeng1990

最新推荐文章于 2024-08-06 11:37:25 发布

阅读量2.2k

点赞数

分类专栏： C#

本文链接：https://blog.csdn.net/zuoyefeng1990/article/details/71194604

版权

C# 专栏收录该内容

105 篇文章 1 订阅

订阅专栏

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using System.Data.SqlServerCe;

namespace testc
{
    public partial class Form1 : Form
    {
        SqlCeConnection sqlceCon = new SqlCeConnection();
        SqlCeCommand sqlCeCom = new SqlCeCommand();
        DataTable dt = new DataTable();

        public Form1()
        {
            InitializeComponent();
        }

        private void Form1_Load(object sender, EventArgs e)
        {
            sqlceCon = new SqlCeConnection("Data Source=D:\\test.sdf");
            sqlceCon.Open();

            SqlCeDataAdapter adptrOdbc = new SqlCeDataAdapter("select * from customers", sqlceCon);
            adptrOdbc.Fill(dt);

            dataGridView1.DataSource = dt;
        }      
    }
}