|
Home > Archive > Commerce Server General > September 2005 > Custom Tables & Stored Procs
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Custom Tables & Stored Procs
|
|
| Jon Oestermeyer 2005-09-22, 8:58 pm |
| 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 2005-09-22, 8:58 pm |
| 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
>
| |
| Vinayak Tadas[MSFT] 2005-09-22, 8:58 pm |
| 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
| |
| Jon Oestermeyer 2005-09-22, 8:58 pm |
| 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: =?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
>
>
| |
| Vinayak Tadas[MSFT] 2005-09-22, 8:58 pm |
| 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: =?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:
> 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
>
>
|
|
|
|
|