实测项目,代码可以正常跑。数据库为Acess
1、界面如下
1、所需的using
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Data.OleDb;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;
using System.Data.SqlClient;
2、查询所有用户也算更新 把数据库内的表格更新到C# 的dataGridView2上面
private void DataDisplay()
{
conn = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=E:\\users\\userloging.mdb");
string sql = "select * from usetable";
da = new OleDbDataAdapter(sql, conn);
ds = new DataSet();
da.Fill(ds,"用户表");
dt = ds.Tabl