BackTerminal.frmCatMan.GetIdByTitle C# (CSharp) Méthode

GetIdByTitle() private méthode

private GetIdByTitle ( string title ) : int
title string
Résultat int
        private int GetIdByTitle(string title)
        {
            SqlConnection connection = Library.Connection.Instance();
            string queryString = "SELECT id FROM dbo.category WHERE title='"+title+"';";
            SqlCommand command = new SqlCommand(queryString, connection);
            SqlDataReader reader = command.ExecuteReader();

            int id = 0;
            while (reader.Read())
            {
                id = (int)reader["id"];
                break;
            }
            reader.Close();
            return id;
        }