Small width layout Medium width layout Maximum width layout Small text Medium text Large text
     Search
Downloads Downloads Directory Directory Forums Forums Forge Forge Blogs Blogs        Marketplace Marketplace Careers Program Careers
Community › Forums Register  |  

AspDotNetStoreFront
  Ads  
 


  Sponsors  

Meet Our Sponsors

AspDotNetStoreFront - E-Commerce by Design - The Leading ASP.NET shopping cart platform for developers!
SteadyRain
DataSprings - Great Ideas. Always Flowing.
R2integrated - formerly bi4ce
Jango Studios - Skins, Modules and Hosting for DotNetNuke
eUKhost.com is commited to offer exceptional UK Windows Web Hosting solutions with quality 24x7 technical support.Our plans support ASP.Net, ASP, ASP.NET Ajax extensions, XML, MSSQL, MySQL, PHP,DNN, multiple domains and Shared SSL as standard.
 


DotNetNuke Forums
 
  Forum  DotNetNuke® Pro...  User Defined Ta...  Filtering Data using dropdown list
Previous Previous
 
Next Next
New Post 8/14/2008 6:22 AM
User is offline satish
6 posts
10th Ranked


Filtering Data using dropdown list 

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.

 
 
New Post 8/14/2008 9:09 AM
User is offline Stefan Cullmann
1553 posts
5th Ranked








Re: Filtering Data using dropdown list 
Modified By Stefan Cullmann on 8/14/2008 11:09:43 AM)

1. Only way is by converting your data into a UDT compatible XML File.
2. You need some XSL skills for this.
3. UDT was not designed to work against 17.000 records

I suggest that I would need up to 4h for such a task. I have written a converter which transforms CSV Files to UDT Import File  It is not stable enough to for a public release, and it only supports strings. For example DateTime values need to be handled manually. Second importing of large documents fails, it simply times out (work araound: enable debug mode in web.config).

Send me an email if you need external help, this is out of the scope of normal help inside forums.

 

 

Stefan Cullmann - stefan.cullmann [at] dotnetnuke.com
Form and List will be the successor of the User Defined Table module.
----------------------------------------------------------------------
Do you want to import external data to Form and List /User Defined Table?
Check out http://www.codeplex.com/Csv2UDTImport
 
 Page 1 of 1
Previous Previous
 
Next Next
  Forum  DotNetNuke® Pro...  User Defined Ta...  Filtering Data using dropdown list
 


Forum Policy

These Discussion Forums are dedicated to the discussion of the DotNetNuke Web Application Framework.

For the benefit of the community and to protect the integrity of the project, please observe the following posting guidelines:

1. No Advertising. This includes promotion of commercial and non-commercial products or services which are not directly related to DotNetNuke.
2. Discussion or promotion of DotNetNuke product releases under a different brand name are strictly prohibited.
3. No Flaming or Trolling.
4. No Profanity, Racism, or Prejudice.
5. Site Moderators have the final word on approving/removing a thread or post or comment.
6. English language posting only, please.
 


DocuPeak Business Process Management RAD
Comprehensive enterprise and government process management. Forms, documents, indexing, workflow, views, content intelligence, capture, etc. Point and click rapid application development.
www.Webiplex.com 		ADefWebserver.com
DotNetNuke® Module Development Help Website
ADefWebserver.com 		Get Smarter Mail, SmarterStats, SmarterTickets
Windows mail server, web log analytics, and customer service management software - Free Editions Available!
www.smartertools.com

DotNetNuke Corporation   Terms Of Use  Privacy Statement
DotNetNuke®, DNN®, and the DotNetNuke logo are trademarks of DotNetNuke Corporation
Hosted by MaximumASP