Where u binding these values in listbox ?? If u binding these in page_load then u can do it after binding some values in listbox. try like this.. http://www.java2s.com/Code/CSharp/GUI-Windows-Form/Getselectedcheckboxlistitems.htm

try using square brackets around your column names. i.e. [Column1], [Column2] etc. Also, do not include your AutoNumber column when inserting, this will be assigned automatically - you cannot write to it manually third thing - make sure you use command parameters with your code... cmd = new OleDbCommand("INSERT INTO Table1 ([column1], [column2]) VALUES (@1, @2)", cn); cmd.Parameters.Add("@1", OleDbType.Char).Value = textBox1.Text; cmd.Parameters.Add("@2", OleDbType.Char).Value = textBox2.Text; NOTE how the column names have been specified to avoid trying to insert into the AutoNumber column Life goes very fast. Tomorrow, today is already yesterday.