Fill DataGridView from SQLite DB (C#)

Question

I'm trying to fill a datagridview from an SQLite database.

I've found plenty of ways of doing this. However, I have pre-existing columns in my dgv (Item, Quantity).

Currently, when I load the DB to the dgv, I get columns of the DB inserted into the dgv instead of the actual data being inserted into the correct column.

My SQLite DB, has a table with three columns (id PRIMARY KEY AUTO INCREMENT, item VARCHAR, quantity INTEGER).

How do load the DB into the pre-existing columns of the dgv?

Current code for filling dgv:

private void button1_Click_1(object sender, EventArgs e)
    {
        SetConnection();
        sqlconnection.Open();
        sqlcmd = sqlconnection.CreateCommand();

        string CommandText = "SELECT * FROM table1";
        sqlda = new SQLiteDataAdapter(CommandText, sqlconnection);


        using (dt = new DataTable())
        {
            sqlda.Fill(dt);
            dataGridView1.DataSource = dt;
        }

Abdul Saleem · Accepted Answer · 2019-02-13 14:25:55Z

15

If you dont want to disturb the columns you can read the rows one by one using SQLiteDataReader and put it into the datagridview..

private void button1_Click_1(object sender, EventArgs e)
{
    conn.Open();
    SQLiteCommand comm = new SQLiteCommand("Select * From Patients", conn);
    using (SQLiteDataReader read = comm.ExecuteReader())
    {
        while (read.Read())
        {
            dataGridView1.Rows.Add(new object[] { 
            read.GetValue(0),  // U can use column index
            read.GetValue(read.GetOrdinal("PatientName")),  // Or column name like this
            read.GetValue(read.GetOrdinal("PatientAge")),
            read.GetValue(read.GetOrdinal("PhoneNumber")) 
            });
        }
    }

}

edited Feb 13, 2019 at 14:25

answered Mar 17, 2015 at 19:27

Abdul Saleem

10.7k6 gold badges47 silver badges47 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

nobody · Accepted Answer · 2015-03-17 19:32:30Z

2

1) Set AutoGenerateColumns to false

2) dgv.Columns["Item"].DataPropertyName = "Item"; dgv.Columns["Quantity"].DataPropertyName = "Quantity";

3) Then instead of select * from table1 use select item Item,quantity Quantity from table1

answered Mar 17, 2015 at 19:32

nobody

11.1k8 gold badges51 silver badges72 bronze badges

Collectives™ on Stack Overflow

Fill DataGridView from SQLite DB (C#)

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related