Showing posts with label Web. Show all posts
Showing posts with label Web. Show all posts

Basic Social Networking Web site using C# - ASP.NET

5:05 PM | Saturday, May 19, 2012

Posted by harshadura

26 comments 

==================================
README - SLIIT COM SOCIAL NETWORK
==================================
Basic Social Networking system using C# - ASP.NET

-------------------------------------------------------
Feature Overview - TODO
-------------------------------------------------------
 
[DONE] 01.  Students should be able to get registered with the social network.
[DONE] 02.  They should be able to manage their own profiles.
[DONE] 03.  They should be able to share their posts and news on a public e-wall inside the site.
[DONE] 04.  They should be given privilege to manage the friend list.(add, modify and delete)
[SOME] 05.  Students can add students as friends but students can only follow the teachers.
[NOT-] 06.  Messaging and chat facility.
[DONE] 07.  Job bank (If there are vacancies students will be notified through the site)
[DONE] 08.  Event planner for the year.
[DONE] 09.  Students should be able to add educational applications to their profile.
[DONE] 10.  Login / Logout    

-------------------------------------------------------

Required Software
-------------------

[01] Dot Net Framework 3.5/4.0
[02] MS Visual Studio 2010/Web Developer Kit
[03] MS SQL Server 2010

-------------------------------------------------------

Notes.
-------
[01] Configure the MDF file inside App_Data to the SQL server.

-------------------------------------------------------

Regards, 
@harshadura

Screenshots of the System










Displaying Data from a SQL Server Database using ASP.NET

11:34 AM | Tuesday, May 15, 2012

Posted by harshadura

0 comments



Reference : http://www.stardeveloper.com/articles/display.html?article=2002041001&page=3 



<%@ Import Namespace="System.Data.SqlClient" %>
<%@ Page Language="C#" %>

<script runat="server">
 protected void Page_Load(Object sender, EventArgs e) {
  SqlConnection con = null;
  SqlCommand cmd = null;
  
  try {
   con = new SqlConnection("server=localhost;uid=sa;" + 
    "pwd=;database=Stardeveloper");
   cmd = new SqlCommand("SELECT * FROM Names", con);
   
   con.Open();
   grid.DataSource = cmd.ExecuteReader();
   grid.DataBind();

  } catch (Exception err) {
   message.Text = "<p><font color=\"red\">Err: " + 
    err.Message + "</font></p>";
  } finally {
   if(con != null)
    con.Close();
  }
 }
</script>

<html>
<head>
 <style>
 body { font-family:Verdana; font-size:12pt; }
 </style>
</head>
<body>
 <asp:datagrid id="grid" runat="server" />
 <asp:label id="message" runat="server" />
</body>
</html>

Subscribe to: Posts (Atom)