Есть ли примеры кодов для удаления данных базы данных и обновления целочисленного значения AUTO_INCREMENT в C#? Пожалуйста, кто-нибудь, помогите :'(

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data.SqlClient;

namespace LAB9
{
    public partial class Delete : System.Web.UI.Page
    {
        SqlCommand cmd;
        SqlConnection conn;

        protected void Page_Load(object sender, EventArgs e)
        {

        }

        protected void Button1_Click(object sender, EventArgs e)
        {
            conn = new SqlConnection(@"Data Source=DESKTOP-2IECU3E\SQLEXPRESS;Initial Catalog=LAB9;Integrated Security=True");
            conn.Open();

            cmd = new SqlCommand("DELETE FROM Registration WHERE (id = '" + TextBox1.Text + "')", conn);
            cmd.ExecuteNonQuery();
            //cmd = new SqlCommand("SET @num := 0", conn);

            //cmd = new SqlCommand("UPDATE Registration SET id = @num := (@num + 1)", conn);
            //cmd.ExecuteNonQuery();
            //cmd = new SqlCommand("ALTER TABLE Registration AUTO_INCREMENT = 1", conn);
            //cmd.ExecuteNonQuery();
            Label1.Text = "Data successfully deleted!";
            TextBox1.Text = "";
            conn.Close();
        }
    }
}