Combo box value stored in ms access 2010 database

Question

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 redbluegreen. 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...

Satyapriya Nayak · Answer

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

arun kumar · Answer

thanks now code is working

Senthilkumar · Answer

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.