DataGridView中没有出现的列/数据 [英] DataGridView not showing Columns/Data

问题描述

我想一些数据加载到一个DataGridView，但无论是在DataGridView不显示数据（即使它，它有它的项目调试模式说）

 保护无效PopulateGrid（）
 {
字符串数据源=test.db的; 
字符串的connectionString =数据源=+数据源; 
字符串的SelectCommand =SELECT * FROM test_run 
 SQLiteDataAdapter的DataAdapter = 
新SQLiteDataAdapter（SelectCommand中，的connectionString）; 
 
的DataSet DS =新的DataSet（）; 
 DataAdapter.Fill方法（DS）; 
 
 dataGridView1.DataSource = DS; 
 dataGridView1.Refresh（）; 
} 
  

，或不工作，一个错误出现：DataReader的已激活在此命令

 保护无效PopulateGrid（）
 {
 SQLiteConnection SQLCONNECT =新SQLiteConnection（）; 
 SQLiteCommand的SqlCommand =默认（SQLiteCommand）; 
 SQLiteDataAdapter SQLAdapt =新SQLiteDataAdapter（）; 
 SQLiteDataReader = SQLReader的默认（SQLiteDataReader）; 
 DataTable的DB =新的DataTable（）; 
 
 SQLconnect.ConnectionString =数据源= test.db的; MultipleActiveResultSets =真; 
 SQLconnect.Open（）; 
的SqlCommand = SQLconnect.CreateCommand（）; 
 
 
 SQLcommand.CommandText =SELECT * FROM test_run;; 
 = SQLReader的SQLcommand.ExecuteReader（）; 
 
 SQLAdapt.SelectCommand =的SqlCommand; 
 SQLAdapt.Fill（DB）; 
 dataGridView1.DataSource = db.DataSet; 
 dataGridView1.Refresh（）; 
  

解决方案

  dataGridView1。数据源= DS; 
 dataGridView1.DataMember = ds.Tables [0] .TableName; 
 //或者如果你想使用数据表作为数据源为网格
 dataGridView1.DataSource = ds.Tables [0]; 
  

I'm trying to load some data into a DataGridView, but either the DataGridView is not showing the data (even though it says in Debug-Mode that it has the items in it)

    protected void PopulateGrid()
    {
        string dataSource = "test.db";
        String connectionString = "Data Source=" + dataSource;
        String selectCommand = "SELECT * FROM test_run";
        SQLiteDataAdapter dataAdapter =
                    new SQLiteDataAdapter(selectCommand, connectionString);

        DataSet ds = new DataSet();
        dataAdapter.Fill(ds);

        dataGridView1.DataSource = ds;
        dataGridView1.Refresh();
    }

or it doesn't work and an error comes up: "datareader already active on this command"

    protected void PopulateGrid()
    {
        SQLiteConnection SQLconnect = new SQLiteConnection();
        SQLiteCommand SQLcommand = default(SQLiteCommand);
        SQLiteDataAdapter SQLAdapt = new SQLiteDataAdapter();
        SQLiteDataReader SQLreader = default(SQLiteDataReader);
        DataTable db = new DataTable();

        SQLconnect.ConnectionString = "Data Source=test.db;MultipleActiveResultSets=True";
        SQLconnect.Open();
        SQLcommand = SQLconnect.CreateCommand();


        SQLcommand.CommandText = "SELECT * FROM test_run;";
        SQLreader = SQLcommand.ExecuteReader();

        SQLAdapt.SelectCommand = SQLcommand;
        SQLAdapt.Fill(db);
        dataGridView1.DataSource = db.DataSet;
        dataGridView1.Refresh();

解决方案

dataGridView1.DataSource = ds;
dataGridView1.DataMember = ds.Tables[0].TableName;
//or if you want to use DataTable as DataSource for your grid
dataGridView1.DataSource = ds.Tables[0];

这篇关于DataGridView中没有出现的列/数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！