During the last examination period at SLIIT, the Ebook sharing website (Thariya's Ebook Linker) which I designed was very much helpful for me and for my friends to share the learning resources we had. I received so many good comments for developing that from my friends as well as my lecturers at SLIIT.
It was successfully hosted at http://tharindu.somee.com but after two or three weeks I got to know that the website was not working properly. The reason was the deletion of the database from the server. I guess it was done by the site administrators at somee.com and I can't blame them since it's a free hosting service. Maybe they received complains from the book authors for violating copy rights.
I have no intention of running the site by uploading a database to the server. Therefore I thought of sharing the source code of the website with you. It was developed using Microsoft Visual Studio 2008, .NET framework 3.5, ASP.NET and C# as the programming language.
This will be useful for 1st year students at SLIIT for the ITA group project.
Click Here to download. (5.76 MB)
The database is also included in the Zip file. You have to attach the database to the MS SQL server on your PC when running the website. (Read this post for more information)
Then open the project in Microsoft Visual Studio. You need to modify the web.config file with your MS SQL server name. In my PC it is (local). Replace (local) with your server name.
If you don't know the server name, you can open the Microsoft SQL Server Management Studio and the Server Name will appear as shown in the image below.
If you have any problem regarding the source code, just drop me a message via the contact me page.
-Tharindu Edirisinghe-
-SLIIT 10-
9 comments:
Thanx Machan It bwas very helpful to all of us, syre it will be helpful to 1st year students in the future. Keep the Good Work Man
Thanx Machan It was very helpful to all of us, sure it will be helpful to 1st year students in the future. Keep the Good Work Man
sure dude :D
Hi ! I'm using visual studio 2010 when click on 'open project' link & after selecting 'SSBookStore' folder vs studio can not find any project file under 'All Project Files' please tell me how can i open this project?
@Dharshana,
I'm happy to hear your interest. This is not a visual studio project, but an ASP.NET website.
So, in Visual Studio,
File->Open->Website
Then browse and select the folder 'SSBookStore'.
Now it sould be successfully opened. Goto Solution Explorer. If you can't find the shortcut, View->Solution Explorer.
Now you see all the files in the website. First, open the Web.config file and modify it as I've mentioned. Then open the file Default.aspx and got Debug->Start Debugging. Now the website should be opened in your browser. It should function properly if you have attached the database also.
@ Tharindu
Now i could open it via visual studio then i modified the server name too. When i debug then opened via browser so went to registration form to register as a new user. After insert my personal details pressing register button following error occurred. I'm using sql server management studio 2008 - express edition. Thanks.....
"A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)"
An example for a connection string in web.config file is like this.Put your server name instead of XXXXX.
If that is not the problem,
it means the database is not attached properly. There are two files in the database folder which you downloaded. (.mdf file and log file). First you need to copy these two files to the folder which your PC stores databases. (It can be C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA)
Then you need to attach that database to your SQL server. (Read This for more info)
Now, that database should be visible under the list of databases in you computer.
Then open the Default.aspx web page from Visual Studio and debug. If the database is attached properly, it should work.
The connection string example is not appearing in the above comment.
add name="ssbooksConnectionString" connectionString="Data Source=XXXXXXX;Initial Catalog=ssbooks;Integrated Security=True" providerName="System.Data.SqlClient"
Post a Comment