protected void Page_Load(object sender, EventArgs e)
{
/*Session["count"]=Convert.ToInt32(Session["count"])+1;
* Response.Write("Session Count :" + Session["count"]+"<br/>");*/
if (Session["id"] != null)
{
uid = Session["id"].ToString();
query = "Select * from user_details where userid=@id";
SqlParameter[] parameter = new SqlParameter[]
{
new SqlParameter("@id", uid)
};
DataSet ds = common.ExeAdapter(query, parameter, "users");
string username = ds.Tables["users"].Rows[0]["name"].ToString();
string email = ds.Tables["users"].Rows[0]["email"].ToString();
string path = ds.Tables["users"].Rows[0]["image"].ToString();
ImageButton1.ImageUrl = path;
alert += "Welcome " + username + "!";
alert += "EmailID : " + email;
Response.Write("<script>alert('" + alert + "')</script>");
lbl_name.Text = lbl_name2.Text = username;
txt_mail.Text = ds.Tables["users"].Rows[0]["email"].ToString();
txt_mobile.Text = ds.Tables["users"].Rows[0]["mobileno"].ToString();
//Formatting address string-----------------------------------------------------
string address = ds.Tables["users"].Rows[0]["address"].ToString();
string[] adr = address.Split('+');
address = "";
for (int i = 0; i < adr.Length; i++)
{
address += adr[i] + ",";
}
address = address.Replace('=', '-');
txt_address.Text = address;
///fetching voterID from UserID------------------------------------------
///
query = "select image from images where imageid=@id";
parameter = new SqlParameter[]
{
new SqlParameter("@id", uid)
};
object vid = common.ExeScalar(query, parameter);
voterid = vid.ToString();
img_voterid.ImageUrl = voterid;
img_voterid.AlternateText = username + "VoterID";
}
else
{
Response.Redirect("Userlogin.aspx");
}
}
