How to send and receive friend request in social site using

Question

I want to send friend request in my social networking site project

priya mishra · Answer

using System; using System.Collections.Generic; using System.Linq; using System.Web; using System.Web.UI; using System.Web.UI.WebControls; using System.Data; using System.Data.SqlClient; using System.Collections; using System.Web.Security; using System.Web.UI.WebControls.WebParts; using System.Web.UI.HtmlControls; using System.Drawing; using System.IO; using System.Text; using System.Net.Mail; using System.Text.RegularExpressions; using System.Threading; public partial class trialfrndreq : System.Web.UI.Page { SqlConnection con = new SqlConnection(@"Data Source=.\sqlexpress;Initial Catalog=MISHRA;Integrated Security=True"); protected void Page_Load(object sender, EventArgs e) { if (!Page.IsPostBack) { // GetUserFriendsRequest(int.Parse(Request.QueryString["Id"].ToString())); String getUserFriendRequest = this.Request.QueryString["ID"]; } } public void GetUserFriendsRequest(int Id) { SqlCommand cmd = new SqlCommand("Select * FROM [UserTble] where Id IN (SELECT MyId as Id FROM Friends WHERE FriendId='" + Id + "' AND FriendStatus=0)"); SqlDataReader dt = cmd.ExecuteReader(); if (dt.Read()) { DataList1.DataSource = dt; DataList1.DataBind(); } } public string getHREF(object sURL) { DataRowView dRView = (DataRowView)sURL; string Id = dRView["Id"].ToString(); return ResolveUrl("~/Home.aspx?Id=" + Id); } public string getSRC(object imgSRC) { DataRowView dRView = (DataRowView)imgSRC; string ImageName = dRView["ImageName"].ToString(); if (ImageName == "NoImage") { return ResolveUrl(@"~/images/missing.jpg"); } else { return ResolveUrl("~/images/" + dRView["ImageName"].ToString()); } } protected void FreindRequestList_ItemCommand(object source, DataListCommandEventArgs e) { if (!object.Equals(Session["UserId"], null)) { if (e.CommandName == "Accept") { string SenderFriendId =""+Session["ID"]; string MyID = Session["UserId"].ToString(); SqlCommand cmd1 = new SqlCommand("Update Friends set FriendStatus=1 where MyId='" + SenderFriendId + "' AND FriendId='" + MyID + "' "); SqlDataReader dr = cmd1.ExecuteReader(); // Response.Redirect("Home.aspx?Id=" + Request.QueryString["Id"].ToString()); Response.Redirect(String.Format("Home.aspx?ID="+Request.QueryString["ID"].ToString())); } if (e.CommandName == "Deny") { string SenderFriendId = "" + Session["ID"]; string MyID = Session["UserId"].ToString(); SqlCommand cmd2 = new SqlCommand(" Update Friends set FriendStatus=2 where MyId='" + SenderFriendId + "' AND FriendId='" + MyID + "'"); SqlDataReader dr2 = cmd2.ExecuteReader(); // Response.Redirect("Home.aspx?Id=" + Request.QueryString["Id"].ToString()); Response.Redirect(String.Format("Home.aspx?ID=" + Request.QueryString["ID"].ToString())); } } } } This code is not working properly.This was not retrive image or other user information.

Anurag Sarkar · Answer

You need to code for that. Have you tried anything ?

How to send and receive friend request in social site using

Answers (2)