I want to design an online application .I chose to design an online application (Social website) which is similar to Facebook, and twitter .I chose this type of application as i believe that social website is the key to toward the society to use the internet
technology in different aspect.
My question is, as a social website we will have many tables for the user, user profile, friends, friends request, comments, groups…etc. I want to build a small example of how those public social website works. I am not sure what DB engine I have to use?
SQL or MySQL? Could you advice my on that. Another thing, if you have any small model or example of using database in asp.net will be helpful for me.Notice that I am using Asp.net. Also, if you can advise me for any helpful website will be great !
Please try to connection to your local database first by using：
1）Open "View"=>"Server Explorer"，then choose a Server to connect。
2）After connecting to the server（whether local or remote successfully），please copy the ConnectionString from the property panel at right-down and then paste it into the web.config。
Now every time I try to run the project .... I will see the login page and if i try to sign up ... I got weather these error....
Invalid User Name or Password
or
"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: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)"
Why is this ..what is the problem ...if you understund what going on ,please explain it becouse i want to understand what going one not only run the project .?
Since I think you are connecting to the SQL Server，and there's no need for you to use ODBC but just SqlConnection。So in your codes you have to use SqlConnection，SqlCommand，SqlDataAdapter……，ect。
Saby2012
Member
160 Points
150 Posts
Social Website Database -Online application
May 09, 2012 05:44 PM|LINK
I want to design an online application .I chose to design an online application (Social website) which is similar to Facebook, and twitter .I chose this type of application as i believe that social website is the key to toward the society to use the internet technology in different aspect.
My question is, as a social website we will have many tables for the user, user profile, friends, friends request, comments, groups…etc. I want to build a small example of how those public social website works. I am not sure what DB engine I have to use? SQL or MySQL? Could you advice my on that. Another thing, if you have any small model or example of using database in asp.net will be helpful for me.Notice that I am using Asp.net. Also, if you can advise me for any helpful website will be great !
Saby2012
Member
160 Points
150 Posts
Re: Social Website Database -Online application
May 10, 2012 04:10 PM|LINK
hello ..I finally find got good project example of social website but I could not try it . it say it dose not connected to the database .
can i get any help in how to try it ???!!
this the link ...
http://www.techipost.com/2011/06/03/signupsign-in-for-social-networking-website/
Decker Dong ...
All-Star
118619 Points
18779 Posts
Re: Social Website Database -Online application
May 11, 2012 01:58 AM|LINK
Please try to connection to your local database first by using：
1）Open "View"=>"Server Explorer"，then choose a Server to connect。
2）After connecting to the server（whether local or remote successfully），please copy the ConnectionString from the property panel at right-down and then paste it into the web.config。
Reguards！
Saby2012
Member
160 Points
150 Posts
Re: Social Website Database -Online application
May 11, 2012 03:00 PM|LINK
Thank u for ur reply . I did not understand this line...!! i know the web.config。....but wich property panel u mean ?!!
Decker Dong ...
All-Star
118619 Points
18779 Posts
Re: Social Website Database -Online application
May 12, 2012 12:18 AM|LINK
Hello：）
It means this following image of screenshot（after you connected to the SQL Server's db successfully……）
Saby2012
Member
160 Points
150 Posts
Re: Social Website Database -Online application
May 12, 2012 08:33 PM|LINK
Thank you for ur effort...
oky ... i already have in web.config this :
<connectionStrings>
<!--<add name="StrataDial" connectionString="Data Source=localhost;Initial Catalog=companydb; Integrated Security=true; " providerName="System.Data.SqlClient"/>-->
<add name="StrataDial" connectionString="Data Source=localhost;Initial Catalog=companydb; User ID=sa; Password=123; " providerName="System.Data.SqlClient"/>
</connectionStrings>
Then.... after i connecte i have a short one :
Dsn=dBASE Files;uid=sa
Decker Dong ...
All-Star
118619 Points
18779 Posts
Re: Social Website Database -Online application
May 13, 2012 06:09 AM|LINK
Hello Saby2012：）
Never mind，so what's up now？
Saby2012
Member
160 Points
150 Posts
Re: Social Website Database -Online application
May 13, 2012 08:20 AM|LINK
Oky .. I try to connect by using Microsoft ODBC Data Source (ODBC).
I got this ...
Oky Now I understund that I have to copy the Connection string into web.config...
But I already have Connection string .... becouse this project I got from the internt as an example of social network .:
<connectionStrings> <!--<add name="StrataDial" connectionString="Data Source=localhost;Initial Catalog=companydb; Integrated Security=true; " providerName="System.Data.SqlClient"/>--> <add name="StrataDial" connectionString="Data Source=localhost;Initial Catalog=companydb; User ID=sa; Password=123; " providerName="System.Data.SqlClient"/> </connectionStrings>.also in the whole project there is file called script ( I think this is sql file ) ....
.. you can also ...download the whole project from the link :
http://www.techipost.com/2011/06/03/signupsign-in-for-social-networking-website/
Now every time I try to run the project .... I will see the login page and if i try to sign up ... I got weather these error....
Invalid User Name or Password
or
"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: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)"
Why is this ..what is the problem ...if you understund what going on ,please explain it becouse i want to understand what going one not only run the project .?
Thank you
Decker Dong ...
All-Star
118619 Points
18779 Posts
Re: Social Website Database -Online application
May 13, 2012 09:34 AM|LINK
Hello again：）
Since I think you are connecting to the SQL Server，and there's no need for you to use ODBC but just SqlConnection。So in your codes you have to use SqlConnection，SqlCommand，SqlDataAdapter……，ect。
Reguards！
Saby2012
Member
160 Points
150 Posts
Re: Social Website Database -Online application
Jun 12, 2012 06:50 AM|LINK
Hello agin ... i give up for some time,,,,
Now I came back & figur out that the file is not database file.... it look like a script for databse....
so i think i have to build the database from that script .. am right ??
if yes.... how to do it ......?
The file is ...... server quey file!