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 ?