Dear Heyram,
Thank you for your post. Unfortunately Aspose.AdHoc does not provide all of the abilities of the ActiveX component you referenced. Aspose.AdHoc is a purely server side component and creating the drag-n-drop interface for table joins would require a very large amount of DHTML. Unfortunately not all browsers support the same DHTML interface; therefore, a server side component may be much more limited in what it can render. We are investigating adding a table join interface; however, from my understanding it will be quite some time.
We typically suggest creating either some flat views or stored procedures and the providing the user with a drop down list of flat data structures. Once the user selects a flat data structure code can then be executed to build a DataTable object from the view / sp and bound to the AdHoc component. The following post better explains the concept: http://www.aspose.com/forums/ShowPost.aspx?PostID=13712#13720
Currently Aspose.AdHoc is the only .Net server side, query building component. We are always open to growing the product and adding new features so be sure to let us know any specific areas you would like to see improved. Thank you again for you post and if there is anything further I can do to help, please do not hesitate to ask.
Danny Cooper
Team Leader, Aspose Texas Team
Contact Us