I’m a bit late to the party but the migration from CodePlex to GitHub is complete. I took the time to move everything just in case. Here is a list of GitHub profile links:
About a year ago, we decided to “cut the cord” and get rid of cable. We’ve been extremely happy with our setup and multiple friends have asked which products and services we’re using. As an answer to all the questions, here is a write up explaining our setup.
Continue reading “How I Cut the Cord”
I finally took the time to move my ASP.NET Forms Bootstrap Menu Control code over to a GitHub repository. Because of the move, I’ve closed the comments on the original post in hopes of moving all discussion regarding the control to its repository.
I’ve also built out 2 separate example projects. The first shows how to use the control with just the class file. The second shows how to use the control by referencing the project from a separate class library.
This is short notice but this weekend is BarCampNola 9!
BarCampNola is New Orleans’ premier community driven, self organizing, free, tech conference.
For more information, please visit the following links:
Here’s the scenario. You have a hierarchical data set like categories, folders, etc. and you need to output the entire path for each.
Let’s say we take the category example and we have a table that looks like:
CREATE TABLE [dbo].[Category](
[Id] [int] IDENTITY(1,1) NOT NULL,
[Name] [nvarchar](max) NOT NULL,
[ParentCategoryId] [int] NULL,
-- normal PK script removed to keep this short
To get the full path for each category, the SQL would look like:
WITH CTE_CategoriesWithPaths AS
c.Name AS [Path]
FROM Category c
WHERE c.ParentCategoryId IS NULL
cte.[Path] + '/' + c.Name AS [Path]
INNER JOIN CTE_CategoriesWithPaths cte
ON c.ParentCategoryId = cte.Id
WHERE c.ParentCategoryId IS NOT NULL