Filtering Data using dropdown list in UDT
Last Post 08/14/2008 10:06 PM by Joseph Craig. 1 Replies.
Author Messages
Satish yagnik
Nuke Newbie
Nuke Newbie
Posts:6


--
08/14/2008 8:09 AM  
i m using UDT 3.5.1 for developing catagory based database... & i hv 17000 rows of data in excel...

database contains normal information of persons profile like name, address, email, mobile, web, & last professional...i.e. my catagory & i want to search / filtered the data using dropdown list of profession (catagory).

i m able to create the table in UDT & i can able to insert d data but i hv two problems

1. how to import 17000 excel data to sql server 2000 ..i tried copy manually but the problem is data stored in database vertically not column vise

2. how to insert dropdown list menu (catagory) to filter data to show result

i tried forum & cum to know that it is possible using Advancedtable.xsl...but i cant figured out how cuz i m not from programming background.

Joseph Craig
DNN MVP
Posts:11667


--
08/14/2008 10:06 PM  
You can import an XML file into UDT. From Excel, you'll need to export your data into an XML file.

Joe Craig, Patapsco Research Group
Complete DNN Support


---