Check out the following example:
string newid = "";
string sql = "INSERT INTO teachers (name, gender) VALUES (@name, @gender);" +
" SELECT SCOPE_IDENTITY();";
using (var con = new SqlConnection("your connection string") )
using (var cmd = new SqlCommand(sql, con)
{
cmd.Parameters.Add("@name", SqlDbType.VarChar, 100).Value = txtName.Text;
cmd.Parameters.Add("@gender", SqlDbType.VarChar, 20).Value = txtGender.Text;
con.Open();
newid = cmd.ExecuteScalar().ToString();
}
Read more:
SCOPE_IDENTITY (Transact-SQL)[
^]