slxdeveloper.com Community Forums

The Forums on slxdeveloper.com are now retired. The forum archive will remain available for the time being. Thank you for your participation on slxdeveloper.com!

Web Forums - SalesLogix Web Platform & Application Architect
Forum to discuss the use of the SalesLogix Web Platform, Client and Customer Portals, and the Application Architect (For version 7.2 and higher only). View the code of conduct for posting guidelines.

Forums RSS Feed

Back to Forum List | Back to SalesLogix Web Platform & Application Architect | New Thread

View: Search:

Author

Thread: Set SLX Datagrid result set to SQL result

Steve Knowles
Posts: 657

Set SLX Datagrid result set to SQL result Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 18 Jun 08 6:50 AM

Goal: Allow user in customer portal to search tickets by prettykey contains search value. Someone made the call to remove all the groupbuilder (???!!!) functionality from the portal so this functionality is not available.

Since prettykey is stored in two fields I am thinking an SQL result set might be easiest (for my skill set and the current level of slx web documentation). I am thinking I can put a textbox and button on the form - the user will enter part of the pretty key, I will run SQL and populate the grid with the result set.

Are there any examples of doing this out there? Is doing this with an SLX grid much different than doing this with an asp.net datagrid? Any input appreciated. Thanks

[Reply][Quote]

Raul A. Chavez
Posts: 1300

Re: Set SLX Datagrid result set to SQL result Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 21 Jun 08 1:43 PM

If you look at the ActivityManagerList.ascx you will find an example of binding to a DataSet.
Although this example is a bit schewed, it is still a good one.

In this case, they get the data from a call in the Activity Object that returns and IList object, but then they dynamically build a DataTable.
I see no reason why you couldn't just retreive the data table directly yourself by executing the appropriate SQL statement, then again, I have yet to try that. But again, the fact of the matter is that the grid in this example is bound to a DataSet but just simply setting the Data Source.

[Reply][Quote]

Steve Knowles
Posts: 657

Re: Set SLX Datagrid result set to SQL result Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 21 Jun 08 3:47 PM

I was able to bind a dataset to the grid. worked nicely.

[Reply][Quote]

Page 1 of 1

You can subscribe to receive a daily forum digest in your user profile. View the site code of conduct for posting guidelines.

Forum RSS Feed - Subscribe to the forum RSS feed to keep on top of the latest forum activity!

slxdeveloper.com is brought to you courtesy of Ryan Farley & Customer FX Corporation. This site, and all contents herein, are Copyright © 2025 Customer FX Corporation. The information and opinions expressed here are not endorsed by Sage Software.	code of conduct \|

page cache (param): 2/23/2025 3:02:41 PM