using System;
using System.Data;
using System.Configuration;
using System.Collections;
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;

public partial class registration : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {

    }
    protected void TextBox1_TextChanged(object sender, EventArgs e)
    {

    }
    protected void TextBox2_TextChanged(object sender, EventArgs e)
    {

    }
    protected void TextBox3_TextChanged(object sender, EventArgs e)
    {

    }
    protected void TextBox4_TextChanged(object sender, EventArgs e)
    {

    }
    protected void TextBox5_TextChanged(object sender, EventArgs e)
    {

    }
    protected void TextBox6_TextChanged(object sender, EventArgs e)
    {

    }
    protected void TextBox7_TextChanged(object sender, EventArgs e)
    {

    }
    protected void TextBox8_TextChanged(object sender, EventArgs e)
    {

    }
    protected void TextBox9_TextChanged(object sender, EventArgs e)
    {

    }
    protected void TextBox10_TextChanged(object sender, EventArgs e)
    {

    }
    protected void TextBox11_TextChanged(object sender, EventArgs e)
    {

    }
    protected void TextBox12_TextChanged(object sender, EventArgs e)
    {

    }
    protected void TextBox13_TextChanged(object sender, EventArgs e)
    {

    }
    protected void TextBox14_TextChanged(object sender, EventArgs e)
    {

    }
    protected void B1_Click(object sender, EventArgs e)
    {
        SqlConnection con = new SqlConnection("Data Source=.;Initial Catalog=epropertydb;Integrated Security=True");
        con.Open();
        SqlCommand enter = new SqlCommand("insert into userdetails values(@userid,@password,@firstname,@lastname,@address,@pincode,@city,@state,@telephoneno,@mobileno,@faxno,@email)", con);

        
        enter.Parameters.Add("@userid", SqlDbType.VarChar);
        enter.Parameters["@userid"].Value = TextBox2.Text;


        enter.Parameters.Add("@password", SqlDbType.VarChar);
        enter.Parameters["@password"].Value = TextBox3.Text;


        enter.Parameters.Add("@firstname", SqlDbType.VarChar);
        enter.Parameters["@firstname"].Value = TextBox5.Text;

        enter.Parameters.Add("@lastname", SqlDbType.VarChar);
        enter.Parameters["@lastname"].Value = TextBox4.Text;

        enter.Parameters.Add("@address", SqlDbType.VarChar);
        enter.Parameters["@address"].Value = TextBox6.Text;

        enter.Parameters.Add("@pincode", SqlDbType.BigInt);
        enter.Parameters["@pincode"].Value = Convert.ToInt32(TextBox7.Text);


        enter.Parameters.Add("@city", SqlDbType.VarChar);
        enter.Parameters["@city"].Value = TextBox8.Text;

        enter.Parameters.Add("@state", SqlDbType.VarChar);
        enter.Parameters["@state"].Value = TextBox9.Text;


        enter.Parameters.Add("@telephoneno", SqlDbType.BigInt);
        enter.Parameters["@telephoneno"].Value = Convert.ToInt64(TextBox11.Text);

        enter.Parameters.Add("@mobileno", SqlDbType.BigInt);
        enter.Parameters["@mobileno"].Value = Convert.ToInt64(TextBox13.Text);

        enter.Parameters.Add("@faxno", SqlDbType.BigInt);
        enter.Parameters["@faxno"].Value = Convert.ToInt64(TextBox11.Text);

        enter.Parameters.Add("@email", SqlDbType.VarChar);
        enter.Parameters["@email"].Value = TextBox12.Text;


        enter.ExecuteNonQuery();


        SqlDataAdapter ad1 = new SqlDataAdapter(get);
        DataSet ds1 = new DataSet();
        ad1.Fill(ds1);

        con.Close();
        Response.Redirect("home.aspx");
    }

}