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

[ Post a follow-up to this message ]

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...
> 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
>

[ Post a follow-up to this message ]

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: examnotes
<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

[ Post a follow-up to this message ]

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

Thanks for the responses.

Jon

""Vinayak Tadas[MSFT]"" wrote:

> Is this information indepenedent of any of the commerce server resources?
> In some case for eg if  you want to return addition Product information fo
r
> 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 right
s.
>  You assume all risk for your use. © 2002 Microsoft Corporation. All ri
ghts
>  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.  Plea
se
>  reply to the newsgroups only
>
>
> --------------------
> Thread-Topic: Custom Tables & Stored Procs
> thread-index: AcW/hXjXoCqotGfWQlmUrI1jrIsqsw==
> X-WBNR-Posting-Host: 63.145.142.2
> From: examnotes
> <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 ca
n
> 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
>
>

[ Post a follow-up to this message ]

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/d...-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: examnotes
<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:

> 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: examnotes
> <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
>
>

[ Post a follow-up to this message ]