Social Networking site is designed in Visual Studio 2008 and the database used is SQL Server 2008. Database has three tables: User table, Friends table and Scraps table. New User can register by Signing Up. Once the registration is completed, the User can log into his/her account and search for friends and send a friend request. Users can accept or deny the friend request. Users can send messages to their friends

Amalraj, Navis

English

Governors State University

Governors State UniversityOPUS Open Portal to University ScholarshipAll Capstone Projects Student Capstone ProjectsFall 2010Social Networking SiteNavis AmalrajGovernors State UniversityFollow this and additional works at: http://opus.govst.edu/capstonesPart of the Computer Sciences CommonsFor more information about the academic degree, extended learning, and certificate programs of Governors State University, go tohttp://www.govst.edu/Academics/Degree_Programs_and_Certifications/Visit the Governors State Computer Science DepartmentThis Project Summary is brought to you for free and open access by the Student Capstone Projects at OPUS Open Portal to University Scholarship. Ithas been accepted for inclusion in All Capstone Projects by an authorized administrator of OPUS Open Portal to University Scholarship. For moreinformation, please contact opus@govst.edu.Recommended CitationAmalraj, Navis, "Social Networking Site" (2010). All Capstone Projects. 34.http://opus.govst.edu/capstones/34      Graduation Project CPSC890 Documentation Governors State University  Social Networking Site By  Navis Amalraj 9            Social Networking site in designed in Visual Studio 2008 and the database used is SQL Server 2008. Database has three tables: User table, Friends table and Scraps table. New User can register by Signing Up. Once the registration is completed, the User can log into his/her account and search for friends and send a friend request. Users can accept or deny the friend request. Users can send messages to their friends.  Login Page            Registration Page          Member Page              Search Result              Send Friend Request             Accept/Deny Friend Request              User Table            Friends Table             Scraps Table            Database Diagram    DatabaseClass.cs File  using System; using System.Collections.Generic; using System.Linq; using System.Web; using System.Data; using System.Data.SqlClient;  /// <summary> /// Summary description for DataBaseClass /// </summary> public class DataBaseClass {     SqlDataAdapter da;     SqlConnection con;     SqlCommand cmd = new SqlCommand();     DataSet ds = new DataSet();     DataTable dt = new DataTable();      public DataBaseClass()     {              }      public void ConnectDataBaseToInsert(string Query)     {         con = new SqlConnection(@"Data Source=Navis; Initial Catalog=RNetworkingWebApplication; uid=sa; pwd=password1;");         cmd.CommandText = Query;         cmd.Connection = con;         da = new SqlDataAdapter(cmd);                 con.Open();         cmd.ExecuteNonQuery();                con.Close();      }     public DataSet ConnectDataBaseReturnDS(string Query)     {         ds = new DataSet();         con = new SqlConnection(@"Data Source=Navis; Initial Catalog=RNetworkingWebApplication; uid=sa; pwd=password1;");         cmd.CommandText = Query;         cmd.Connection = con;         da = new SqlDataAdapter(cmd);         da.Fill(ds);         con.Open();         cmd.ExecuteNonQuery();         con.Close();                 return ds;     }     public DataTable ConnectDataBaseReturnDT(string Query)     {         dt = new DataTable();         con = new SqlConnection(@"Data Source=Navis; Initial Catalog=RNetworkingWebApplication; uid=sa; pwd=password1;");         cmd.CommandText = Query;         cmd.Connection = con;         da = new SqlDataAdapter(cmd);         da.Fill(dt);         con.Open();         cmd.ExecuteNonQuery();         con.Close();         return dt;     } }  WebService.cs File using System; using System.Collections.Generic; using System.Linq; using System.Web; using System.Web.Services; using System.Data; using System.Data.SqlClient;  /// <summary> /// Summary description for WebService /// </summary> [WebService(Namespace = "http://tempuri.org/")] [WebServiceBinding(ConformsTo = WsiProfiles.BasicProfile1_1)] // To allow this Web Service to be called from script, using ASP.NET AJAX, uncomment the following line.   [System.Web.Script.Services.ScriptService] public class WebService : System.Web.Services.WebService {      public WebService () {          //Uncomment the following line if using designed components          //InitializeComponent();      }      [WebMethod]     public string[] GetSearch(string prefixText)     {         string sql = "Select * from User Where Name like @prefixText";         SqlDataAdapter da = new SqlDataAdapter(sql, "Data Source=Navis; Initial Catalog=RNetworkingWebApplication; uid=sa; pwd=password1;");         da.SelectCommand.Parameters.Add("@prefixText", SqlDbType.VarChar, 100).Value = prefixText + "%";         DataTable dt = new DataTable();         da.Fill(dt);         string[] items = new string[dt.Rows.Count];         int i = 0;         foreach (DataRow dr in dt.Rows)         {             items.SetValue(dr["Name"].ToString(), i);             i++;         }         return items;     }       }       Web.Config File  <?xml version="1.0"?>  <configuration>  <configSections>   <sectionGroup name="system.web.extensions" type="System.Web.Configuration.SystemWebExtensionsSectionGroup, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35">    <sectionGroup name="scripting" type="System.Web.Configuration.ScriptingSectionGroup, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35">     <section name="scriptResourceHandler" type="System.Web.Configuration.ScriptingScriptResourceHandlerSection, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35" requirePermission="false" allowDefinition="MachineToApplication"/>     <sectionGroup name="webServices" type="System.Web.Configuration.ScriptingWebServicesSectionGroup, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35">      <section name="jsonSerialization" type="System.Web.Configuration.ScriptingJsonSerializationSection, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35" requirePermission="false" allowDefinition="Everywhere"/>      <section name="profileService" type="System.Web.Configuration.ScriptingProfileServiceSection, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35" requirePermission="false" allowDefinition="MachineToApplication"/>      <section name="authenticationService" type="System.Web.Configuration.ScriptingAuthenticationServiceSection, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35" requirePermission="false" allowDefinition="MachineToApplication"/>      <section name="roleService" type="System.Web.Configuration.ScriptingRoleServiceSection, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35" requirePermission="false" allowDefinition="MachineToApplication"/>     </sectionGroup>    </sectionGroup>   </sectionGroup>  </configSections>  <appSettings/>   <connectionStrings/>   <system.web>      <compilation debug="true">    <assemblies>     <add assembly="System.Core, Version=3.5.0.0, Culture=neutral, PublicKeyToken=B77A5C561934E089"/>     <add assembly="System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35"/>     <add assembly="System.Data.DataSetExtensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=B77A5C561934E089"/>     <add assembly="System.Xml.Linq, Version=3.5.0.0, Culture=neutral, PublicKeyToken=B77A5C561934E089"/>     <add assembly="System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35"/>     <add assembly="System.Web.Extensions.Design, Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35"/>     <add assembly="System.Design, Version=2.0.0.0, Culture=neutral, PublicKeyToken=B03F5F7F11D50A3A"/>     <add assembly="System.Windows.Forms, Version=2.0.0.0, Culture=neutral, PublicKeyToken=B77A5C561934E089"/></assemblies>   </compilation>      <authentication mode="Windows"/>      <pages>    <controls>     <add tagPrefix="asp" namespace="System.Web.UI" assembly="System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35"/>     <add tagPrefix="asp" namespace="System.Web.UI.WebControls" assembly="System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35"/>    </controls>   </pages>   <httpHandlers>    <remove verb="*" path="*.asmx"/>    <add verb="*" path="*.asmx" validate="false" type="System.Web.Script.Services.ScriptHandlerFactory, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35"/>    <add verb="*" path="*_AppService.axd" validate="false" type="System.Web.Script.Services.ScriptHandlerFactory, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35"/>    <add verb="GET,HEAD" path="ScriptResource.axd" type="System.Web.Handlers.ScriptResourceHandler, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35" validate="false"/>   </httpHandlers>   <httpModules>    <add name="ScriptModule" type="System.Web.Handlers.ScriptModule, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35"/>   </httpModules>  </system.web>  <system.codedom>   <compilers>    <compiler language="c#;cs;csharp" extension=".cs" warningLevel="4" type="Microsoft.CSharp.CSharpCodeProvider, System, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089">     <providerOption name="CompilerVersion" value="v3.5"/>     <providerOption name="WarnAsError" value="false"/>    </compiler>    <compiler language="vb;vbs;visualbasic;vbscript" extension=".vb" warningLevel="4" type="Microsoft.VisualBasic.VBCodeProvider, System, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089">     <providerOption name="CompilerVersion" value="v3.5"/>     <providerOption name="OptionInfer" value="true"/>     <providerOption name="WarnAsError" value="false"/>    </compiler>   </compilers>  </system.codedom>    <system.webServer>   <validation validateIntegratedModeConfiguration="false"/>   <modules>    <remove name="ScriptModule"/>    <add name="ScriptModule" preCondition="managedHandler" type="System.Web.Handlers.ScriptModule, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35"/>   </modules>   <handlers>    <remove name="WebServiceHandlerFactory-Integrated"/>    <remove name="ScriptHandlerFactory"/>    <remove name="ScriptHandlerFactoryAppServices"/>    <remove name="ScriptResource"/>    <add name="ScriptHandlerFactory" verb="*" path="*.asmx" preCondition="integratedMode" type="System.Web.Script.Services.ScriptHandlerFactory, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35"/>    <add name="ScriptHandlerFactoryAppServices" verb="*" path="*_AppService.axd" preCondition="integratedMode" type="System.Web.Script.Services.ScriptHandlerFactory, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35"/>    <add name="ScriptResource" preCondition="integratedMode" verb="GET,HEAD" path="ScriptResource.axd" type="System.Web.Handlers.ScriptResourceHandler, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35"/>   </handlers>  </system.webServer>  <runtime>   <assemblyBinding xmlns="urn:schemas-microsoft-com:asm.v1">    <dependentAssembly>     <assemblyIdentity name="System.Web.Extensions" publicKeyToken="31bf3856ad364e35"/>     <bindingRedirect oldVersion="1.0.0.0-1.1.0.0" newVersion="3.5.0.0"/>    </dependentAssembly>    <dependentAssembly>     <assemblyIdentity name="System.Web.Extensions.Design" publicKeyToken="31bf3856ad364e35"/>     <bindingRedirect oldVersion="1.0.0.0-1.1.0.0" newVersion="3.5.0.0"/>    </dependentAssembly>   </assemblyBinding>  </runtime>   <system.serviceModel>     <serviceHostingEnvironment aspNetCompatibilityEnabled="true"/>   </system.serviceModel> </configuration>

Social Networking Site

https://opus.govst.edu/cgi/viewcontent.cgi?article=1031&amp;context=capstones

Social Networking Site

Abstract

Similar works

Full text

Available Versions

Governors State University