Populate ComboBox from MS Access Data Base using C#

siddango...

SOLVED CLOSED ACTIVE ANSWERED
User: siddangoud
Posted: on Sep 26, 2016 03:44 AM
Forum: Microsoft Access
Answer: 1
Views: 4843

i am useing access databasr for windows application

i have certain table which executes the result in sql view

of an ms acces when we write the query.but it is not executing in

C# it is showing with out error data table is empty

below is my code

my_con.Open();
DataTable dt = new DataTable();
OleDbCommand cmd = new OleDbCommand("select * from Batch", my_con);
OleDbDataAdapter ad = new OleDbDataAdapter(cmd);
ad.Fill(dt);
comboBox1.ValueMember = "Batch_Name";
comboBox1.DisplayMember = "Batch_Name";
comboBox1.DataSource = dt;
comboBox1.Text = "select id";

so is it version problem of ms access

please help me

Download FREE API for Word, Excel and PDF in ASP.Net

dharmend...

0 1

Reply
ANSWER
User: dharmendr
Replied: on Sep 26, 2016 07:25 AM
Report

Hi siddangoud,

Refer the below code.

string conStr = "PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA SOURCE=" + Server.MapPath("~/database.mdb");
OleDbConnection objCon;
OleDbCommand objCmd;
DataTable dt = new DataTable();
string getSql = string.Empty;
getSql = "(SELECT * FROM Batch)";
using(objCon = new OleDbConnection(conStr))
{
    objCon.Open();
    using (objCmd = new OleDbCommand(getSql, objCon))
    {
        OleDbDataAdapter da = new OleDbDataAdapter(objCmd);
        da.Fill(dt);
    }
}
objCon.Close();
comboBox1.DataSource = dt;
comboBox1.ValueMember = "Batch_Name";
comboBox1.DisplayMember = "Batch_Name";

I agree, here is the link: https://www.e-iceblue.com/Introduce/spire-office-for-net-free.html

Populate ComboBox from MS Access Data Base using C#

Company

Explore

Follow us

Contact Us