Member Avatar for khair.ullah

Hello dear ALL

I am working with a form in vb.net which have the follwing attribute i.e BOOK TITLE(text box) , CATEGORY NAME(combo box) ,YEAR PUBLISHED(t.box) and SAVE button .the CATEGORY combo pickup data from CATEGORY TABLE on cat_name . on back end (SQL SERVER) there are two tbl i.e

CATEGORY(cat_id,cat_name) and BOOKRECORD(book_name,cat_id,pub_year)
Now when i press the SAVE button the record save in BOOKRECORD table with cat_id instead of selected category NAME.
HOW can i accomplish this task plz HELP ME.
THANK TO YOU ALL .

  • 1 Contributor
  • 1 Reply
  • 209 Views
  • 2 Weeks Discussion Span
  • Latest Post Latest Post by khair.ullah
Member Avatar for khair.ullah

cmb.displaymember="cat-name"
cmb.valuemember="cat_id"

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.