i hv created 3 tables category,author and publisher...n i hve added category,author,publisher items in dropdownlist...n i hv taken lsit box...in which when i select item from dropdownlist i should get the list of items in that particular selected item from dropdownlist..eg...if i select category from dropdownlist i should get the content of that category table...n if i select author then i should get content of that author table in that listbox..so please help me how to do by using sqldatasourse...
sid1 0 Newbie Poster
kvprajapati 1,826 Posting Genius Team Colleague
Sid,
Do not use "leet" or SMS speak on a forum.
>so please help me how to do by using sqldatasourse
Assign Select query property with following statement,
str="select * from " & DropDownList1.SelectedValuestr="select * from " + DropDownList1.SelectedValue 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.