How to use Combobox's values in Query

Question

Im using Combobox filled with Tables Names. When I made Insert command and determine the table name by getting the values of the Combobox it didn't work

           private void Form2_Load(object sender, EventArgs e)
    {
        Conn.Open();
            foreach (DataRow dr in dt.Rows)
            {
                comboBox1.Items.Add(dr["TABLE_NAME"].ToString());
            }
        Conn.Close();  

    }

//cmd = new SqlCommand("insert into dbo."+ comboBox1.SelectedItems.ToString()     +"(Phone, Email, Address) values('" + txt1.Text + "','" + txt2.Text + "','" + txt3.Text + "')", Conn);

exception of type 'System.Data.SqlClient.SqlException' occurred in System.Data.dll — user2102572
– user2102572, Commented Feb 23, 2013 at 16:46
Except that you have to use SelectedItem and not SelectedItems (that does not exist), your code to read the selected value in the combobox seems right. I suppose you have some problem with the connection (is it open when you execute the command?) or with escaping (if you have an ' in your txt controls your sqlString does not work. To find what is happening I suggest you to analyze the InnerException of your Exception, because SqlException is to generic. Hope to help. — Daniele Armanasco
– Daniele Armanasco, Commented Feb 23, 2013 at 18:33

Camilo Aguilar · Accepted Answer · 2013-02-23 15:43:16Z

1

Combobox article

You can find there a very good resource for everything for combobox. You can use the datasource property and let know the values and display for what you need.

comboBox1.datasource = datatable;
comboBox1.displayname = "ColumnNameForDisplayName";
comboBox1.valuename = "ColumnsNameForValueName";

answered Feb 23, 2013 at 15:43

Camilo Aguilar

1291 silver badge11 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to use Combobox's values in Query

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related