insertion of listbox value in to database.

Question

Hi... how to insert a listbox items in single field database?i m using Access.

Suthish Nair · Answer

How to get selected values of a ListBox

Sam Hobbs · Answer

You can bind the listbox to a SQL query and then the listbox contents will come from the table and go to the table.

guna sakthi · Answer

hi soumyathans for ur reply... i tried tht but last record only inserted in the database .. how to insert listbox all items?

Suthish Nair · Answer

Guna explain your post with more information.

Soumya Surendran · Answer

after establishing connection and creating oledb command (say cmd) for(int i=0;i { cmd.CommandText=insert into table_name(field_name) values('+listBox1.Items[i].toString()+'); cmd.ExecuteNonQuery; }