Problem with Drop Down List

[fazee.ent]

i am using a drop down list and have sucessfuly populated it proble is
this i have set
DataValueField = "cat_id" but value for dropdownlist appears a string
"cat_id" instead of numer value of cat_id

plz help me

Faisal Iqbal Ch

 

[David Lozzi]

Can you paste the actual code on here?

Thanks

David

 

[fazee.ent]

*****************
Data binding Code
*******************
Const strSQL2 as String ="SELECT * FROM book_cat"
Dim objCmd2 as New SqlCommand(strSQL2, objConn)

objConn.Open() 'Open the connection

cmbcat.DataSource =
objCmd2.ExecuteReader(CommandBehavior. CloseConnection)
cmbcat.DataBind()


****************
Insertion Code
****************

sql="INSERT INTO book_cat_sub
(cat_name,cat_keywords,cat_head)VALUES('" & txtname.Text & "','" &
txtkeywords.Text & "',"& cmbcat.DataValueField & ")"

dbcomm=New OleDbCommand(sql,dbconn)
dbread=dbcomm.ExecuteReader()

dbread.Close()
dbconn.Close()



****************
Drop Down Lis code
****************

<aspropDownList id="cmbcat" runat="server" DataTextField="cat_name"
DataValueField="cat_id" ></aspropDownList>

 

[fazee.ent]

*****************
Data binding Code
*******************
Const strSQL2 as String ="SELECT * FROM book_cat"
Dim objCmd2 as New SqlCommand(strSQL2, objConn)

objConn.Open() 'Open the connection

cmbcat.DataSource =
objCmd2.ExecuteReader(CommandBehavior. CloseConnection)
cmbcat.DataBind()


****************
Insertion Code
****************

sql="INSERT INTO book_cat_sub
(cat_name,cat_keywords,cat_head)VALUES('" & txtname.Text & "','" &
txtkeywords.Text & "',"& cmbcat.DataValueField & ")"

dbcomm=New OleDbCommand(sql,dbconn)
dbread=dbcomm.ExecuteReader()

dbread.Close()
dbconn.Close()



****************
Drop Down Lis code
****************

<aspropDownList id="cmbcat" runat="server" DataTextField="cat_name"
DataValueField="cat_id" ></aspropDownList>

 

[David Lozzi]

Can you look at the page source of the returned page and see if the value of
the list items in then drop down box is also cat_id?