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!
|
|
Creating an ASP.NET Page
Posted: 30 Nov 06 3:12 PM
|
fiogf49gjkf0d My company has done development work for the lan client of SLX for sometime now and has recently decided to embark into the web. I know that you can make windows forms and import them into SLX, but how do I make a asp.net form with the vb code behind it and import that into SLX? Do I create a new web site and import that? Don't understand how I am suppose to do this. Help concerning this would be most appreciated. |
|
|
|
Re: Creating an ASP.NET Page
Posted: 30 Nov 06 7:39 PM
|
fiogf49gjkf0d Allen,
It's actually not difficult to do. All you have to do is make create a SalesLogix alias that is a hyperlink and have that hyperlink call your asp.net page on whatever web site/virtual directory you have your .NET page/application running in. That's the easiest way. Just have the target frame of the hyperlink be whatever frame in SalesLogix that you want the page to appear in.
I would recommend that you have some sort of configuration option in SalesLogix somewhere where you can specify what your web site/virtual directory is located. That way if you change the location, you just configure it and you don't need to change aliases or HTML pages in SalesLogix. For example, if you put the path to your web site somewhere in the SalesLogix database, you can use a #SQL tag to get that value and then you only need to hardcode the page name. Or, abstracting another layer, create a table in SalesLogix that has a user friendly page name, the URL and the .NET page to call, and then you can change either the URL and page name and have that configurable. You could then use that to build your links.
For example, if you have a table called C_DOTNET_MODULES, with three columns (plus the standard SLX fields): module name, module_URL and module _page with a record with the values: "sales_opp", "http://myserver/", and "salesopp.aspx", you could build a javascript/hyperlink alias that calls a function on the SalesLogix page named loadDotNetPage like this:
function loadDotNetPage()
{
var url = "<#SQL code="SELECT MODULE_URL FROM C_DOTNET_MODULES WHERE MODULE_NAME = 'sales_opp'" format=0>" + "<#SQL code="SELECT MODULE_PAGE FROM C_DOTNET_MODULES WHERE MODULE_NAME = 'sales_opp'" format=0>";
document.location.href = url; // URL should resolve to "http://myserver/salesopp.aspx".
}
When your user clicks that javascrip hyperlink alias, they'll call the function that will dynamically have your module name and URL in it and they'll be redirected to the .NET page.
The down side to something like this is you have to build an interface that allows your users to configure their .NET modules. The upside is your page references aren't hard coded inside the SalesLogix HTML.
There's probably a more elegant way to do it, but I'd definitely recommend a way to avoid hard-coding page URLs and names into your SalesLogix HTML pages. Hopefully this will give you some ideas.
Jeff
|
|
|
|
Re: Creating an ASP.NET Page
Posted: 01 Dec 06 2:52 AM
|
fiogf49gjkf0d Allen:
Basically, you don't Import an ASP.NET form into SLX. You could link into it, or hosted within an IFrame, etc..
The reply by Jeff contains a good approach to improve your ability to maintain the location of the ASP.NET content without having to hard code it into SLX. Another option that I utilize, although similar is to host the ASP.NET content on the same site as SLX somewhere under the slxweb folder and then do somewhat hardcode the path.
Other than that, its just up to you on how to integrate .NET into SLX. I have used it in several ways:
- Semi-External Applications that run in separate browsers.
- Embedded content that runs into IFrames on a tab
- To generate HTML that I could then inject into an area of a Page
On the other hand, if you are just looking to make some simple modifications or additions to the Web Client, it may be simpler to just learn how to work with Templates and Actions.
|
|
|
|
Re: Creating an ASP.NET Page
Posted: 01 Dec 06 1:33 PM
|
fiogf49gjkf0d I thank both of ya'll for the help, but I do have one more question. What do I need to import or reference in VS 2005 from SLX? |
|
|
|
Re: Creating an ASP.NET Page
Posted: 01 Dec 06 1:38 PM
|
fiogf49gjkf0d The answer to your question is "nothing"
You can use ADO or ADO.NET to get to the data, and depending upon wether you have a need to synchronize the data you should write it back thru ADO (or ADO.NET) thru the SLX OLEDB Provider.
|
|
|
|
Re: Creating an ASP.NET Page
Posted: 01 Dec 06 2:09 PM
|
fiogf49gjkf0d Let me see if I got this:
All I need to do is create a new web site in VS 2005 and call those pages in SLX through an alias that's a hyperlink or a JS that redirects to it, right? |
|
|
|
Re: Creating an ASP.NET Page
Posted: 01 Dec 06 2:18 PM
|
fiogf49gjkf0d Yes.
If you are looking to retreive data from SLX, and/or update it, you would do so either via ADO or ADO.NET utilizing the SLX OLEDB Provider. Make sure you pass in the user ID and use the Impersonate property of the connection string if you need to apply security rules as SalesLogix does.
|
|
|
| |
| |
|