private string find(string strSubCategoryId) { string strSubCategoryName; string strCommand = string.Format("select SubCategoryName from SubCategory where SubCategoryId = {0};", strSubCategoryId); Sql sql = new Sql(_strConn); strSubCategoryName = sql.getScalar(strCommand); return strSubCategoryName; }