hi all
i have a problem with dropdownlist and listbox

i am adding text items from dropdowlist in to the database
but an error says the like some items Btech,MCA,MBA

but error says the Btech not allowed here only contants,expression are allowed

please help  

how i add from dropdownlist to database

i am giving the query


"insert into news values('" & TextBox1.Text & "','" & TextBox2.Text & "','" & TextBox3.Text & "','" & TextBox4.Text & "'," & TextBox5.Text & "," & Textbox6.Text & ",'" & RadioButtonList1.SelectedItem.Text & "'," & ListBox1.SelectedItem.Value & "," & DropDownList2.SelectedIndex.ToString & ",'" & TextBox7.Text & "'," & TextBox10.Text & ",'" & TextBox31.Text & "','" & TextBox32.Text & "')"

thanks in advance



____________________________
rahul

Perhaps you need quotes around DropDownList2.SelectedIndex.ToString in your INSERT...

could also try:

DropDownList2.SelectedItem.Value

I would also suggest putting the column names in your INSERT statement.


INSERT INTO myTable (id, name, etc) VALUES('1','Bean','AlltheRest')


____________________________
Eggheads unite! You have nothing to lose but your yolks.