how to view data by dropdown list from multitables

http://kutub.info/library/add_book

I want show it like a page in the lunk above

In order to get the data from mutiple table you should consider to use "joins" in your query.  At the end, you get the result as datatable (i guess) if so follow the below url:

http://www.aspsnippets.com/Articles/Bind-Populate-ASPNet-DropDownList-using-DataTable-DataSet-in-C-and-VBNet.aspx 

 

Hope this helps!