protected void Page_Load(object sender, EventArgs e) { if (Session["uname"] == null) { Response.Redirect("Login.aspx"); } else { returnname nam12 = new returnname(); Label2.Text = nam12.id1(Session["uname"].ToString()).ToString(); SqlConnection cn = new SqlConnection(); cn.ConnectionString = System.Web.Configuration.WebConfigurationManager.ConnectionStrings["cn"].ToString(); cn.Open(); string str = "select * from reg where Email='" + Session["uname"].ToString() + "'"; SqlCommand cmd = new SqlCommand(str, cn); SqlDataReader dr = cmd.ExecuteReader(); if (dr.Read()) { Label1.Text = dr[1].ToString(); LinkButton12.Text = dr[1].ToString(); } profilepic(); cn.Close(); fillpendingreq(); fillfriend(); fillpen(); fillpost(); follow(); notification(); body.Controls.Add(new LiteralControl("<script>$(document).ready(function(){$('[data-toggle='tooltip']').tooltip();});</script>")); } }
void fillpen() { SqlConnection cn = new SqlConnection(); cn.ConnectionString = System.Web.Configuration.WebConfigurationManager.ConnectionStrings["cn"].ToString(); SqlCommand cmd = new SqlCommand("select * from friend where (receiver='" + Session["uname"].ToString() + "'or sender='" + Session["uname"].ToString() + "') and status='1' order by dor desc", cn); DataSet ds = new DataSet(); SqlDataAdapter ad = new SqlDataAdapter(cmd); SqlCommandBuilder cmdb = new SqlCommandBuilder(ad); ad.Fill(ds); int c = 0; a = new ArrayList(); foreach (DataRow dr in ds.Tables[0].Rows) { c++; if (dr[1].ToString() == Session["uname"].ToString()) { a.Add(dr[2].ToString()); } else { a.Add(dr[1].ToString()); } } foreach (object o in a) { LinkButton b12 = new LinkButton(); b12.Text = r.name(o.ToString()); b12.Style.Add("font-size", "15px"); b12.Attributes.Add("href", "javascript:register_popup('" + r.id1(o.ToString()) + "' , '" + r.name(o.ToString()) + "');"); flist.Controls.Add(new LiteralControl("<table><tr><td><img src='img/d.png' id='" + r.id1(o.ToString()) + "-i' /></td>")); flist.Controls.Add(new LiteralControl("<td style='width:8px'></td>")); A = new abc(); int t = A.chkpicstat(o.ToString()); if (t == 0) { if (A.chkgender(o.ToString())) { flist.Controls.Add(new LiteralControl("<td><img src='temp/b.jpg' alt='image' class='img-circle' width='60' height='60'></td>")); } else { flist.Controls.Add(new LiteralControl("<td><img src='temp/g.jpg' alt='image' class='img-circle' width='60' height='60'></td>")); } } else { flist.Controls.Add(new LiteralControl("<td><img src='Account/" + o.ToString() + "/p.jpg' alt='image' class='img-circle' width='60' height='60'></td>")); } flist.Controls.Add(new LiteralControl("<td style='width:15px'></td>")); flist.Controls.Add(new LiteralControl("<td>")); flist.Controls.Add(b12); flist.Controls.Add(new LiteralControl("</td></tr></table>")); //flist.Controls.Add(new LiteralControl("</li>")); } cn.Close(); if (c == 0) { flist.Controls.Add(new LiteralControl("<p>No Friends yet...!</p>")); } }