Profile.aspx.cs

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data.SqlClient;
using System.Configuration;
using System.Data;
using System.Web.Security;

namespace QUtopiaProject
{
    public partial class Profile : System.Web.UI.Page
    {
        SqlConnection SQLConn = new SqlConnection("Data Source=DESKTOP-1M38HSH; Integrated Security=True");

        
        protected void Page_Load(object sender, EventArgs e)
        {

            SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["dbconnection"].ConnectionString);
            con.Open();
            SqlDataReader dataReader;

            UserIDLabel.Text = "User ID : " + Session["UserID"];

            
            SqlCommand cmd1 = new SqlCommand("select First_Name, Middle_Name, Last_Name, Mobile, E_Mail from UserTable where User_ID = @UserID", con);
            cmd1.Parameters.AddWithValue("@UserID", Session["UserID"]);

            dataReader = cmd1.ExecuteReader();
            while (dataReader.Read())
            {
                NameLabel.Text = dataReader.GetString(0) + " " + dataReader.GetString(1) + " " + dataReader.GetString(2);
                PhoneLabel.Text = "" + dataReader.GetInt64(3);
                EMailLabel.Text = dataReader.GetString(4);
            }
          
        }//Page_Load sonu

        protected void QuestionsButton_Click(object sender, EventArgs e)
        {
            Response.Redirect("~/Questions.aspx");
        }

        protected void QuizzesButton_Click(object sender, EventArgs e)
        {
            Response.Redirect("~/Quizzes.aspx");
        }

        protected void TakeTheQuizButton_Click(object sender, EventArgs e)
        {
            Response.Redirect("~/QuizVerification.aspx");
        }

        protected void QuizzesTakenButton_Click(object sender, EventArgs e)
        {
            Response.Redirect("~/QuizzesTaken.aspx");
        }

    }
}