QuizVerification.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;
using System.Data.SqlClient;
using System.Configuration;
using System.Web.Security;

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

        protected void Page_Load(object sender, EventArgs e)
        {

        }

        protected void VerifyButton_Click(object sender, EventArgs e)
        {

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

            //Kullanıcı var mı? Yok mu?
            SqlCommand cmd = new SqlCommand("select * from QuizTable where Quiz_ID=@Quiz_ID and Password=@Password", con);
            cmd.Parameters.AddWithValue("@Quiz_ID", QVQuizIDTextBox.Text);
            cmd.Parameters.AddWithValue("@Password", QVQuizPassTextBox.Text);
            //cmd.ExecuteNonQuery(); 

            SqlDataAdapter da = new SqlDataAdapter(cmd);
            DataTable dt = new DataTable();
            da.Fill(dt);

            if (dt.Rows.Count > 0)
            {
                String QID = QVQuizIDTextBox.Text;
                String QuizPass = QVQuizPassTextBox.Text;

                Int32 QuizID = Convert.ToInt32(QID);
                //Int32 QuizPass = Convert.ToInt32(QPass);

                Session.Add("QuizID", QuizID);
                Session.Add("QuizPass", QuizPass);

                if (QuizID != 0) //ID'ler 0'dan büyük hep
                {
                    SqlCommand cmd1 = new SqlCommand("INSERT INTO TakeTable (User_ID, Quiz_ID, Total_Score) VALUES (@UserID, @QuizID, 0)", con);
                    cmd1.Parameters.AddWithValue("@UserID", Session["UserID"]);
                    cmd1.Parameters.AddWithValue("@QuizID", Session["QuizID"]);

                    cmd1.ExecuteNonQuery();
                    Response.Redirect("~/TakeTheQuiz.aspx");
                }
                    
                //else Label1.Text = "olmadı";

            }//if sonu








        }

        protected void Button1_Click(object sender, EventArgs e)
        {
            Response.Redirect("~/Profile.aspx");

        }
    }
}