Problem with Drop Down List

  • Thread starter Thread starter fazee.ent
  • Start date Start date
F

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
 
*****************
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
****************

<asp:DropDownList id="cmbcat" runat="server" DataTextField="cat_name"
DataValueField="cat_id" ></asp:DropDownList>
 
*****************
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
****************

<asp:DropDownList id="cmbcat" runat="server" DataTextField="cat_name"
DataValueField="cat_id" ></asp:DropDownList>
 
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?
 
Back
Top