Access 另存为 .mdb 数据库; 在winform 中使用 Datagridview 控件,可以显示所有的源数据
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;
using System.Data.OleDb; //using 注意
{
public partial class Form1 : Form
{
public Form1()
{
InitializeComponent();
}
{
OleDbCommand cmd = conn.CreateCommand();
conn.Open();
OleDbDataReader dr = cmd.ExecuteReader();
DataTable dt = new DataTable();
if (dr.HasRows)
{
for (int i = 0; i < dr.FieldCount; i++)
{
dt.Columns.Add(dr.GetName(i));
}
dt.Rows.Clear();
}
while (dr.Read())
{
DataRow row = dt.NewRow();
for (int i = 0; i < dr.FieldCount; i++)
{
row[i] = dr[i];
}
dt.Rows.Add(row);
}
cmd.Dispose();
conn.Close();
dataGridView1.DataSource = dt;
}
}
原文:https://www.cnblogs.com/littlelhb/p/13110371.html
如果您也喜欢它,动动您的小指点个赞吧