How to Fill ComboBox with Data inside the DataGridView in C# and MS Access Database

Submitted by: 
Language: 
Visitors have accessed this post 215 times.

This time, I will teach you how to fill combobox with data in the datagridview in C# and MS Access Database. This is very useful most especially when you are dealing with combo box and datagridview control. In this way, you can manipulate the data inside a combobox easily.

Creating Application

Step 1

Open Microsoft Visual Studio 2015 and create a new windows form application in C#.
psq1

Step 2

Do the form just like shown below.
ps2

Step 3

Press F7 to open the code editor. In the code editor, add a namespace for OLeDB to access OLeDB libraries.

  1. using System.Data.OleDb;

Step 4

Create a connection between the access database and c#. After that, declare all the classes that are needed.

  1. OleDbConnection con = new OleDbConnection("Provider = Microsoft.ACE.OLEDB.12.0; Data Source =" + Application.StartupPath + "/studentdb.accdb");
  2. OleDbCommand cmd;
  3. OleDbDataAdapter da;
  4. DataTable dt;
  5. string sql;

Step 5

Create a method for adding the comboxbox column with data in the datagridview.

  1.  
  2. private void fill_combo(string sql)
  3. {
  4. try
  5. {
  6. con.Open();
  7.  
  8. cmd = new OleDbCommand();
  9. da = new OleDbDataAdapter();
  10. dt = new DataTable();
  11. DataGridViewComboBoxColumn cbo = new DataGridViewComboBoxColumn();
  12.  
  13. cmd.Connection = con;
  14. cmd.CommandText = sql;
  15. da.SelectCommand = cmd;
  16. da.Fill(dt);
  17.  
  18. cbo.HeaderText="Name";
  19. cbo.DataSource = dt;
  20. cbo.ValueMember = "ID";
  21. cbo.DisplayMember = "fname";
  22.  
  23. dataGridView1.Columns.Add(cbo);
  24.  
  25. }
  26. catch(Exception ex)
  27. {
  28. MessageBox.Show(ex.Message);
  29. }
  30. finally
  31. {
  32. con.Close();
  33. da.Dispose();
  34. }
  35. }

Step 6

Do the following codes to execute the method that you have created in the first load of the form.

  1.  
  2. private void Form1_Load(object sender, EventArgs e)
  3. {
  4. sql = "Select * From tblstudent";
  5. fill_combo(sql);
  6. }

Download the complete sourcecode and run it on your computer.
For any questions about this article. You can contact me @
Email – [email protected]
Mobile No. – 09305235027 – TNT
Or feel free to comment below


Add new comment

Filtered HTML

  • Web page addresses and e-mail addresses turn into links automatically.
  • You may insert videos with [video:URL]
  • Allowed HTML tags: <a> <em> <strong> <cite> <blockquote> <code> <ul> <ol> <li> <dl> <dt> <dd> <table> <tr> <td> <th> <img> <h1> <h2> <h3> <iframe> [video]
  • You can enable syntax highlighting of source code with the following tags: <code>, <blockcode>, <asp>, <c>, <cpp>, <csharp>, <css>, <html4strict>, <java>, <javascript>, <mysql>, <php>, <python>, <sql>, <vb>, <vbnet>. The supported tag styles are: <foo>, [foo].
  • Lines and paragraphs break automatically.

Plain text

  • No HTML tags allowed.
  • Lines and paragraphs break automatically.
CAPTCHA
This question is for testing whether or not you are a human visitor and to prevent automated spam submissions.