using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;

namespace the_fuck
{
    public partial class _Default : System.Web.UI.Page
    {

        DataSet ds = new DataSet();

        //Here we declare the parameter which we have to use in our application
        SqlCommand cmd = new SqlCommand();
        SqlParameter sp1 = new SqlParameter();
        SqlParameter sp2 = new SqlParameter();
        SqlParameter sp3 = new SqlParameter();
        SqlParameter sp4 = new SqlParameter();

        private string _connString =
            @"Data Source=.\SQLEXPRESS;" +
            "Initial Catalog=WebApp;" +
            "Integrated Security=True;";

        SqlConnection con;




        protected void Page_Load(object sender, EventArgs e)
        {

        }

        protected void Button1_Click(object sender, EventArgs e)
        {
            con = new SqlConnection(_connString);
            //cmd.Parameters.Add("@Id", SqlDbType.Int).Value = TextBox1.Text;
           // cmd.Parameters.Add("@Password", SqlDbType.VarChar).Value = TextBox2.Text;
            cmd.CommandType = CommandType.StoredProcedure;

           // SqlParameter param1 = new SqlParameter("@Id", SqlDbType.Int);
          //  SqlParameter param2 = new SqlParameter("@Password", SqlDbType.VarChar,50);


            //cmd.Parameters.Clear();

            cmd.Parameters.AddWithValue("@Id", Convert.ToInt32(TextBox1.Text));
            cmd.Parameters.AddWithValue("@Password", TextBox2.Text);
            cmd = new SqlCommand("testAgain", con);

            con.Open();
            cmd.ExecuteNonQuery();
            con.Close();
        }
    }
}