Question

如何：在 Windows 窗体中导航数据

Answer 1

在工具栏拖一个datagridview控件到form1中，下面是实现代码：

using System;

using System.Collections.Generic;

using System.ComponentModel;

using System.Data;

using System.Drawing;

using System.Text;

using System.Windows.Forms;

using System.Data.OleDb;

namespace text01

{

public partial class Form1 : Form

{

public Form1()

{

InitializeComponent();

OleDbConnection thisConnection = new OleDbConnection(@"provider=Microsoft.Jet.OLEDB.4.0;Data Source=H:\text01\text01\DB\协和医院.mdb");

string sql = "select * from Sheet1";

OleDbDataAdapter thisAdapter = new OleDbDataAdapter(sql, thisConnection);

System.Data.DataSet thisDataSet = new System.Data.DataSet();

thisAdapter.Fill(thisDataSet, "table");

DataTable dt = thisDataSet.Tables["table"];

this.dataGridView1.DataSource = dt;

thisConnection.Close();

}

}

}