用C#写了一段程序，想把access数据库的数据显示到dataGridView表格中，下面是一段代码没有报错，就是dataGridView表格中不显示数据，不知道怎么回事？
public partial class CustomerEditor : Form
  {
  private OleDbConnection connection;
  public CustomerEditor()
  {
  InitializeComponent();
  }

   

  private void menuDataconnect_Click(object sender, EventArgs e)
  {
  Connect();
  }
  public void Connect()
  {
  if (DialogopenFile.ShowDialog(this) == DialogResult.OK)
  {
  try
  {
  string connectionString = string.Format(
  "Provider=Microsoft.Jet.OLEDB.4.0;Data Source={0};User ID=;Password=;", DialogopenFile.FileName);
   
  OleDbConnection newConnection = new OleDbConnection(connectionString);
  newConnection.Open();
  Connection = newConnection;


  }
  catch (Exception ex)
  {
  HandleException("A connection could not be made", ex);
  }
   
  }
  }

  private void HandleException(string p, Exception ex)
  {
  MessageBox.Show(this, string.Format("{0}\n{1}:{2}", p, ex.GetType().ToString(), ex.Message));
  }
  public OleDbConnection Connection
  {
  get
  {
  return connection;

  }
  set
  {
  disconnection();
  connection = value;
  }

  }
  public void disconnection()
  {
  if (connection != null)
  {
  if (connection.State != ConnectionState.Closed)
  connection.Close();
  connection = null;
  }
  }
  protected void Dispos(bool disposing1)
  {
  disconnection();
  if (disposing1)
  {
  if (components != null)
  {
  components.Dispose();
  }
  }
  base.Dispose(disposing1);
  }

  private void menuDataload_Click(object sender, EventArgs e)
  {
  LoadData();
  }

  public void LoadData()
  {
  if (connection == null)
  {
  MessageBox.Show(this, "you must connect to a database");
  return;

  }

  OleDbCommand command = connection.CreateCommand();
  OleDbDataAdapter adapter = new OleDbDataAdapter(command);
  try
  {
   
   = "Customers";
   = CommandType.TableDirect;
   
  DataSet dataset = new DataSet();
  adapter.Fill(dataset);
  dataGridCustomers.DataSource = dataset;
   
  }
  catch (Exception ex)
  {
  HandleException("the data could not be loaded", ex);

  }
  finally
  {
  if (adapter != null)
  adapter.Dispose();
  if (command != null)
  command.Dispose();
  }

  }
  }
}

主要是调试的也没发现什么问题，就是不显示数据。不知道怎么回事？

  OleDbCommand command = connection.CreateCommand();
  OleDbDataAdapter adapter = new OleDbDataAdapter(connection,command);  //不懂你写的,好像少了连接，只有语句
  try 
  {
   
   = "Customers";
   = CommandType.TableDirect;  //首先连接语句不对，而且这两句应该在命令执行的前面,但和你前面写的不一样   
  DataSet dataset = new DataSet();
  adapter.Fill(dataset);
  dataGridCustomers.DataSource = dataset; //=dataset.Table[0].Defaultview,应该这样填充的
   

//给个示例
            int k = this.cbCountry.SelectedIndex;

            SqlConnection con = new SqlConnection();
            con.ConnectionString = @"Server = PC--20110803JXD\SQLEXPRESS;Database = Dsdv;User ID=sa;Password='wfl137632'";
            con.Open();

            SqlCommand cmd = new SqlCommand();
            cmd.Connection = con;

            //string cdstr = this.ctcdlist[k].ToString();
            //string ctcd = cdstr.Substring(4, 2);
            //this.tbZhtCd.Text = this.tbZhtCd.Text.Substring(0, 4) + ctcd;

            this.cbTown.Items.Clear();
            this.twcdlist.Clear();

             = "SELECT dsdvsn,dsdvcd FROM dsdv WHERE dsdvcd LIKE '" + this.tbZhtCd.Text + "___000000'";

            SqlDataReader dr = cmd.ExecuteReader();  //这里

            bool ok = false;

            while (dr.Read())
            {
                if (ok)
                {
                    this.cbTown.Items.Add(dr[0]);
                    this.twcdlist.Add(dr[1]);                
                }
                ok = true;
            }

            dr.Close();
            con.Close();

[ 本帖最后由 qq1023569223 于 2011-9-15 18:20 编辑 ]

你的程序很难看！

看的眼疼...

本来一个简单的东西，被你搞的这么大一坨。

异常不比都捕获了吧