How to save data in asp.net using c#

 How to save data in asp.net using c#

using System;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;

public partial class DataSave : System.Web.UI.Page
{
  
    protected void Page_Load(object sender, EventArgs e)
    {
      
    }
    protected void Button1_Click(object sender, EventArgs e)
    {
       
        cmd.CommandText = "insert into lab values(@Reg_no,@Name,@Age,@Sex,@Regn_Date,@Test_Name,@Result,@Units,@Ref_Units)";
        cmd.Connection = conn;
        cmd.Parameters.Add("@Reg_No", SqlDbType.VarChar, 50).Value = TextBox1.Text;
        cmd.Parameters.Add("@Name", SqlDbType.VarChar, 50).Value = TextBox2.Text;
        cmd.Parameters.Add("@Age", SqlDbType.VarChar, 50).Value = TextBox3.Text;
        cmd.Parameters.Add("@Sex", SqlDbType.VarChar, 10).Value = TextBox4.Text;
        // cmd.Parameters.Add("@Regn_Date", SqlDbType.DateTime).Value = TextBox5.Text;
        cmd.Parameters.Add("@Regn_Date", SqlDbType.DateTime).Value = TextBox9.Text;
        cmd.Parameters.Add("@Test_Name", SqlDbType.VarChar, 50).Value = TextBox5.Text;
        cmd.Parameters.Add("@Result", SqlDbType.VarChar, 50).Value = TextBox6.Text;
        cmd.Parameters.Add("@Units", SqlDbType.VarChar, 50).Value = TextBox7.Text;
        cmd.Parameters.Add("@Ref_Units", SqlDbType.VarChar, 50).Value = TextBox8.Text;
        cmd.ExecuteNonQuery();
        TextBox1.Text = "";
        TextBox2.Text = "";
        TextBox3.Text = "";
        TextBox4.Text = "";
        TextBox5.Text = "";
        TextBox6.Text = "";
        TextBox7.Text = "";
        TextBox8.Text = "";
        //cmd.Dispose();
     
    }
}