C# loading data from MS Access database to listbox

Question

public partial class Form1 : Form
{
    OleDbCommand cmd = new OleDbCommand();
    OleDbConnection cn = new OleDbConnection();
    OleDbDataReader dr;
    public Form1()
    {
        InitializeComponent();

    }

    private void Form1_Load(object sender, EventArgs e)
    {
        cn.ConnectionString = @"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\Users\AsusK450c\documents\visual studio 2010\Projects\ADD\ADD\testing.accdb;Persist Security Info=True";
        cmd.Connection = cn;
        loaddata();

    }
    private void loaddata()
    {
        listBox1.Items.Clear();
        listBox2.Items.Clear();
        try
        {
            string q = "select * from info";
            cmd.CommandText = q;
            cn.Open();
            dr = cmd.ExecuteReader();
            if (dr.HasRows)
            {
                while (dr.Read())
                {
                    listBox1.Items.Add(dr[0].ToString());
                    listBox2.Items.Add(dr[1].ToString());
                }
            }
            dr.Close();
            cn.Close();

        }
        catch (Exception e)
        {
            cn.Close();
            MessageBox.Show(e.Message.ToString());
        }
    }
}

This is an image of the database:

I added 2 list boxes. Those two should display the data i put in the database but It doesn't. I don't know which is wrong, the path, the code or the database

I added 2 list boxes. Those two should display the data i put in the database but It doesnt — user5207499
– user5207499, Commented Sep 26, 2015 at 5:31
Can you debug and check dr contains values or it getting any exception — Nagaraj S
– Nagaraj S, Commented Sep 26, 2015 at 5:36

Shamal Perera · Accepted Answer · 2015-09-26 05:56:01Z

1

There is nothing wrong with you code. Check if you are getting any exceptions or pointed to the right database.

Also check if you have assigned the function Form1_Load() to form's load event

answered Sep 26, 2015 at 5:56

Shamal Perera

1,6911 gold badge18 silver badges22 bronze badges

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

Comments

Harutyun Imirzyan · Accepted Answer · 2015-09-26 05:56:04Z

0

I'm not sure what your problem is, but you can change the connectionString by this way:

System.Data.OleDb.OleDbConnectionStringBuilder builder = new System.Data.OleDb.OleDbConnectionStringBuilder();
            builder.Provider = "Microsoft.ACE.OLEDB.12.0";
            builder.OleDbServices = -1;
            builder.DataSource = @"C:\Users\AsusK450c\documents\visual studio 2010\Projects\ADD\ADD\testing.accdb";
            cn.ConnectionString = builder.ConnectionString;

OleDbServices = -1 can help you.

answered Sep 26, 2015 at 5:56

Harutyun Imirzyan

4644 silver badges17 bronze badges

Collectives™ on Stack Overflow

C# loading data from MS Access database to listbox

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related