Windows Server

Jon Oestermeyer · Guest

Sorry if this is a repeat question, but I was unable to locate anything on
the web or in the product documentation.

We are creating a CS Site (SP3 and FP1) and attempting to access some
additional tables and stored procedures. These are used for ancillary pages
and not specific catalog related information. Is there a method that I can
use the CS data access layer to query / return results from these tables? I
was hoping to not manage an additional connection string and DAL.

Thanks,
Jon

Jeff Lynch · Guest

It really depends upon what kind of information you want to return. If it's
"Profile" related you can customize the profiles and the runtime can return
all the properties. The same goes for catalog info. If it's really unrelated
you'll have to build a DAL & BLL which is really pretty simple using C# or
VB.NET.

In a previous CS2002 project I wrote a simple DAL using the Enterprise
Library "Blocks" and an object-oriented BLL using C# to return customer open
orders and invoices from our ERP system. This was bound to a few ASP.NET
server controls to display the info to the user.

--
Jeff Lynch
"A BizTalk Enthusiast"
http://codebetter.com/blogs/jeff.lynch

"Jon Oestermeyer" <JonOestermeyer@discussions.microsoft.com> wrote in
message news:875D4A9A-E5D4-48A3-9490-39A7CA374138@microsoft.com...

Vinayak Tadas[MSFT] · Guest

You should take a look at this article. This allows you to add a custom
resource and have it managed by Comemrce Server

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/comsrv2k/ht
m/cs_sp_introtoprog_ttid.asp

Thanks
Vinayak Tadas
Microsoft
http://blogs.msdn.com/vinayakt

This posting is provided "AS IS" with no warranties, and confers no rights.
You assume all risk for your use. © 2002 Microsoft Corporation. All rights
reserved.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
Get Secure! For more info visit http://www.microsoft.com/security. Please
reply to the newsgroups only

--------------------
Thread-Topic: Custom Tables & Stored Procs
thread-index: AcW/pb1PdGixM5AnRJKHttX24YaonA==
X-WBNR-Posting-Host: 63.145.142.2
From: =?Utf-8?B?Sm9uIE9lc3Rlcm1leWVy?=
<JonOestermeyer@discussions.microsoft.com>
References: <875D4A9A-E5D4-48A3-9490-39A7CA374138@microsoft.com>
<lPSa4R6vFHA.768@TK2MSFTNGXA01.phx.gbl>
Subject: RE: Custom Tables & Stored Procs
Date: Thu, 22 Sep 2005 11:45:01 -0700
Lines: 68
Message-ID: <5E0EC2A4-BCFF-4784-97DC-0E1BFCC416E7@microsoft.com>
MIME-Version: 1.0
Content-Type: text/plain;
charset="Utf-8"
Content-Transfer-Encoding: 8bit
X-Newsreader: Microsoft CDO for Windows 2000
Content-Class: urn:content-classes:message
Importance: normal
Priority: normal
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
Newsgroups: microsoft.public.commerceserver.general
NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250
Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGXA03.phx.gbl
Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.commerceserver.general:3543
X-Tomcat-NG: microsoft.public.commerceserver.general

It is totally un-related, so I guess I am on my own.

Thanks for the responses.

Jon

""Vinayak Tadas[MSFT]"" wrote:

Jon Oestermeyer · Guest

It is totally un-related, so I guess I am on my own.

Thanks for the responses.

Jon

""Vinayak Tadas[MSFT]"" wrote:

Vinayak Tadas[MSFT] · Guest

Is this information indepenedent of any of the commerce server resources?
In some case for eg if you want to return addition Product information for
your catalogs you can use the Join table feature to return data from your
custom tables
If not then you will have to manage this on your own

Thanks
Vinayak Tadas
Microsoft
http://blogs.msdn.com/vinayakt

This posting is provided "AS IS" with no warranties, and confers no rights.
You assume all risk for your use. © 2002 Microsoft Corporation. All rights
reserved.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
Get Secure! For more info visit http://www.microsoft.com/security. Please
reply to the newsgroups only

--------------------
Thread-Topic: Custom Tables & Stored Procs
thread-index: AcW/hXjXoCqotGfWQlmUrI1jrIsqsw==
X-WBNR-Posting-Host: 63.145.142.2
From: =?Utf-8?B?Sm9uIE9lc3Rlcm1leWVy?=
<JonOestermeyer@discussions.microsoft.com>
Subject: Custom Tables & Stored Procs
Date: Thu, 22 Sep 2005 07:54:02 -0700
Lines: 12
Message-ID: <875D4A9A-E5D4-48A3-9490-39A7CA374138@microsoft.com>
MIME-Version: 1.0
Content-Type: text/plain;
charset="Utf-8"
Content-Transfer-Encoding: 7bit
X-Newsreader: Microsoft CDO for Windows 2000
Content-Class: urn:content-classes:message
Importance: normal
Priority: normal
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
Newsgroups: microsoft.public.commerceserver.general
NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250
Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGXA03.phx.gbl
Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.commerceserver.general:3534
X-Tomcat-NG: microsoft.public.commerceserver.general

Sorry if this is a repeat question, but I was unable to locate anything on
the web or in the product documentation.

We are creating a CS Site (SP3 and FP1) and attempting to access some
additional tables and stored procedures. These are used for ancillary
pages
and not specific catalog related information. Is there a method that I can
use the CS data access layer to query / return results from these tables?
I
was hoping to not manage an additional connection string and DAL.

Thanks,
Jon

	Windows Server Forum Index -> Commerce Server	All times are GMT
Page 1 of 1