auto generation code for Emp id

// SP
ALTER PROCEDURE dbo.GetRowsCount
AS
	SET NOCOUNT ON;
	
	SELECT * FROM users
	
	RETURN

// DAL
  public int getRowsCount()
        {
            con.Open();

            SqlCommand cmd = new SqlCommand("GetRowsCount", con);
            cmd.CommandType = CommandType.StoredProcedure;

            SqlDataAdapter da = new SqlDataAdapter(cmd);
            DataTable dt = new DataTable();
            da.Fill(dt);

            con.Close();

            return dt.Rows.Count;
        }

//BAL
public int RowCount()
        {
            return usr.getRowsCount();
        }

// while inserting data from UI
protected void btn_Click(object sender, EventArgs e)
       {

               bc.GetID = bc.RowCount() + 1;
       }