Combo box value stored in ms access 2010 database

arun kumar

Hi, I have a combobox in my project. When i select any item from the combobox and click the submit button it have to store the selected item in a database

The combobox contains three items. For example red,blue,green. I will select any one item from the combobox and click the submit button. The selected item, for example if i select red, then the selected item should store in a database in my case its red.

Please Kindly Helpme...

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

arun kumar14y ago
thanks now code is working
Satyapriya Nayak14y ago
Hi Arun,

Try this...

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using System.Data.OleDb;
namespace Combobox_access
{
    public partial class Form1 : Form
    {
        string ConnectionString = System.Configuration.ConfigurationSettings.AppSettings["dsn"];
        OleDbCommand com;
        string str;


        public Form1()
        {
            InitializeComponent();
        }

        private void Form1_Load(object sender, EventArgs e)
        {
            comboBox1.Text = "Select";
            comboBox1.Items.Add("Red");
            comboBox1.Items.Add("Green");
            comboBox1.Items.Add("Blue");
        }

        private void btn_insert_Click(object sender, EventArgs e)
        {
            OleDbConnection con = new OleDbConnection(ConnectionString);
            con.Open();
            str = "insert into test values('" + comboBox1.SelectedItem + "')";
            com = new OleDbCommand(str, con);
            com.ExecuteNonQuery();
            con.Close();
            MessageBox.Show("Records Successfuly Inserted");
        }
    }
}

Thanks
If this post helps you mark it as answer
Senthilkumar14y ago
Hi Arun,

First, you need to bind the combox box.

  System.Collections.ArrayList oArrayList = new System.Collections.ArrayList();
oArrayList.Add("Red");
oArrayList.Add("Blue");
oArrayList.Add("Green");

comboBox1.DataSource = oArrayList;

Then you need to write the code to get the selected value in the submit button.

  private void btnSubmit_Click(object sender, EventArgs e)
{
string sqlQuery = "INSERT INTO table_name(field) VALUES('" + comboBox1.SelectedItem.ToString()+"')";

string connectionString = ConfigurationManager.ConnectionStrings["OLEDbConnection"].ToString();
  connection.Open();
OleDbCommand command = new OleDbCommand(connection, sqlQuery);
command.ExecuteNonQuery();
connection.Close();
}

In web.config file,

connectionString="Provider=Microsoft.Jet.OLEDB.4.0; Data Source=your database path\yourdatabasename.mdb;"
providerName="System.Data.SqlClient" />

The above query has to be executed in the oledb connection in access database.