using System;
using System.Data;
using System.Data.SqlClient;
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.SqlTypes;

public partial class _Default : System.Web.UI.Page 
{
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!Page.IsPostBack)
        {
            TextBox1.Text = "";
        }
    }
    protected void Button1_Click(object sender, EventArgs e)
    {

        string sqlStmt;
        string conString;
        SqlConnection cn = null;
        SqlCommand cmd = null;
        try
        {
            sqlStmt = "INSERT INTO sampleTable(SampleName,Age) Values(@SampleName,@Age)";
            conString = "Data Source=GAMERFORCE;Initial Catalog=GamerForce;Integrated Security=True";
            cn = new SqlConnection(conString);
            cmd = new SqlCommand(sqlStmt, cn);
            cmd.Parameters.Add(new SqlParameter("@SampleName", SqlDbType.VarChar, 50));
            cmd.Parameters.Add(new SqlParameter("@Age", SqlDbType.Int, 50));
            cmd.Parameters["@SampleName"].Value = TextBox1.Text;
            cmd.Parameters["@Age"].Value = Int32.Parse(TextBox2.Text);
            cn.Open();
            cmd.ExecuteNonQuery();
            label1.Text = "Record Inserted Succesfully";
        }
        catch (Exception ex)
        {
            label1.Text = ex.Message;
        }
        finally
        {
            cn.Close();
        }
    }
}