DATAGRIDVIEW BINDING - OLEDB DATASET IN C#

Samuel Fernandes

Total Post:159

Points:1117
Posted by  Samuel Fernandes
C# 
C#
 3691  View(s)
Ratings:
Rate this:
Hi MindStickians,
How to bind datagridview with OLEDB dataset in C#?
  1. Sumit Kesarwani

    Post:378

    Points:2694
    Re: DataGridView Binding - OLEDB dataset in C#

    Hi Samuel,


    You can use this code:

    using System;
    using System.Data;
    using System.Windows.Forms;
    using System.Data.OleDb;
     
    namespace WindowsApplication1
    {
        public partial class Form1 : Form
        {
            public Form1()
            {
                InitializeComponent();
            }
     
            private void button1_Click(object sender, EventArgs e)
            {
                string connetionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=your .mdb file;";
                string sql = "SELECT * FROM Authors";
                OleDbConnection connection = new OleDbConnection(connetionString);
                OleDbDataAdapter dataadapter = new OleDbDataAdapter(sql, connection);
                DataSet ds = new DataSet();
                connection.Open();
                dataadapter.Fill(ds, "Authors_table");
                connection.Close();
                dataGridView1.DataSource = ds;
                dataGridView1.DataMember = "Authors_table";
            }
        }
    }

      Modified On Mar-30-2018 04:14:14 AM

Answer

NEWSLETTER

Enter your email address here always to be updated. We promise not to spam!