Webshop code in C#

jack_hilary · September 28th, 2009, 03:22 AM

Hello,
I have downloaded code for WebShop (chapter 9). I can change its code files to C# to some extent but not to global file and stored procedures. So can any body help me regarding code for Webshop in C#.

Also I have been working on Asp.Net 3.5 by Imar sir, there were 2 databases. First is default where all info. about users are stored and second database stores info about all Reviews, Photo albums etc.
Now Integrating with Webshop application which handles only one database handling all info (about users as well as products), is there any problem if I store products info. in second database according to Asp.Net 3.5 cause it deals with the profile of user which is managed by application itself.

Imar · September 28th, 2009, 03:37 AM

Take a look here:

These articles show you how to use aspnet_regsql to prepare your own database for the ASP.NET Application Services.

Cheers,

Imar

jack_hilary · September 28th, 2009, 04:12 AM

Nice Articles,
These articles will definitely help me a lot, Thanks for such valuable articles.
But for the time being now I'm asking about code in C# for webshop.
Cause I can convert source files (.Vb files) from VB to C# but stored procedures and global file requires some expertise.
And by databases I mean that will there be any problem later when implementing the single database over 2 databases that are same as in your PlanetWrox.com sample databases. Because I am integrating Webshop in my existing (similar to planetWrox.com) project. Because profile for the user is maintained in ASPNETDB.mdf database.

Imar · September 28th, 2009, 05:00 AM

If you read the articles I lned to you'll see how to *combine* the ASPNETDB database with your own.

Stored procedures are not tied to a language so there's nothing to convert.

There's not much code in the Global.asax. What's there is also available in the PlanetWrox site, in C# and VB....

Imar

jack_hilary · September 28th, 2009, 05:17 AM

Thank you Sir, for your kind suggestion. It makes me now confident coz' I was afraid of stored procedures. Now I can start working.

Thank you once again.

jack_hilary · September 30th, 2009, 03:17 PM

Hello everyone,
On suggestion of using store procedures as they are because they are not language specific, when I try to create the stored procedures then it generates error like "Invalid Object name [dbo].aspnet_AnyDataInTables"
and the stored procedure looks like

Code:

ALTER PROCEDURE [dbo].aspnet_AnyDataInTables
    @TablesToCheck int
AS
BEGIN
    -- Check Membership table if (@TablesToCheck & 1) is set
    IF ((@TablesToCheck & 1) 


Procedure continues.............

it seems to come out from sql server object aspnet_AnyDataInTables
as there is no such table in database. Please tell me how to fix problem.
Also How to create view states........?
Thank you.