how to make combobox to take data by selection and custom also both

Question

I want to insert data to my access database by combobox that have some item in it but some time when I want insert some thing there is not exist in my combobox how can write it down manually on my combobox and insert it to my db

OleDbCommand cmd = new OleDbCommand();
cmd.CommandType = CommandType.Text;
cmd.CommandText = "insert into [data] ( [Description] ) values ('" + comboBox10Text + "' )";
cmd.Connection = con;
con.Open();
cmd.ExecuteNonQuery();
System.Windows.Forms.MessageBox.Show("Data Inserted Successfully");

So what is the problem you should probably use comboBox10Text.Text and OleDbCommand.Parameters — mybirthname, Nov 08 '16 at 11:46
**warning** your code is vulnerable to sql injection attacks — Daniel A. White, Nov 08 '16 at 14:33

score 0 · Answer 1 · answered Nov 08 '16 at 11:48

0

You can add another item to your combobox something like other. Then check the selected item, if it is other then enable a textbox and read the input value from it. Otherwise, read the input value from the combobox.

answered Nov 08 '16 at 11:48

Mahdi

3,199
2
25
35

but I want to be in same combobox – baban jamal Nov 08 '16 at 16:49

score 0 · Accepted Answer · edited May 23 '17 at 11:46

0

You are actually almost there, just a dot missing. comboBox10.Text will give you the entered text:

cmd.CommandText = "insert into [data] ( [Description] ) values ('" + comboBox10.Text + "' )";

I would suggest to check for emptiness and use parameterized sql commands to avoid SQL Injection

edited May 23 '17 at 11:46

Community

1
1

answered Nov 08 '16 at 14:29

Mong Zhu

23,309
10
44
76

ah ok, if you don't mind empty values. Still, there is a dot missing in `comboBox10Text` and you really should consider to parameterize your query – Mong Zhu Nov 08 '16 at 16:57

how to make combobox to take data by selection and custom also both

2 Answers2