Online Members

Dropdown list Problem.

Posted Date: 12 Jun 2012 Posted By:: kaviyarasi Member Level: Silver Member Rank: 1322 Points: 2 Responses: 2

Hi,

I have two dropdown list.The first one will display all the tables present in backend ms access table names. Now i want to display the table names which is ended with _LookUp table names in the second dropdown list.

Can any one tel the solution for this?

Responses

#675229 Author: Pawan Awasthi Member Level: Diamond Member Rank: 4 Date: 12/Jun/2012 Rating: Points: 3
Hai Kaviyarasi, As you can display the data correctly to your first dropdown list. Now in the same way, you can fetch the data from your access data base using the 'Like' operator. See the below query for the reference: `Select <column_name> from <table_name> where <column_name> like '%_LookUp'` Hope it will be helpful to you. Regards, Pawan Awasthi(DNS MVM) +91 8143683708 (pawansoftit@gmail.com) Outstanding Contribution Award..NTT Data Inc

#675238 Author: Anil Kumar Pandey Member Level: Platinum Member Rank: 1 Date: 12/Jun/2012 Rating: Points: 2
Here is a sample code. `SELECT MSysObjects.Name AS table_name FROM MSysObjects WHERE Name like '%_Lookup' AND (MSysObjects.Type) In (1,4,6)) order by MSysObjects.Name` Thanks & Regards Anil Kumar Pandey Microsoft MVP, DNS MVM

Post Reply

This thread is locked for new responses. Please post your comments and questions as a separate thread.
If required, refer to the URL of this page in your new post.

	Next : Simple Filter from textbox (NOT AJAX)
	Previous : Filter particular items in a Dropdown and make it available in another drop down in asp.n
	Return to Discussion Forum
	Post New Message
	Category:

Related Messages

Active Members
Today

Last 7 Days

more...

Awards & Gifts

Email subscription

Talk to Webmaster Tony John