That brush pack doesn't really look like the effect he's after.
What's wrong with creating a pattern and filling the image (or a selection) with it (as Daniel suggested)? If you do this on a seperate layer you can use a layer mask for the fading. Or you could simply erase parts of the grid to make it fade in and out as you please.
BTW here is
a tutorial for using a stroke to create a grid pattern.
A stroke creates a grid that has a 2 pixel thick line though.
Personally I would create a small image (the size of the grid) with a transparent background. Select a vertical line of one pixel width. Add a horizontal line of one pixel height to the selection. Now you have a cross selection. Fill that with the color you want to use for the grid. reverse the selection and apply a gaussian blur (for the glow effect). I think it looks nicer if you blur it a few times with different radii. Then finally deselect and create a pattern from the image.
The fading can be done with a layer mask. From the layer mernu select Layer mask and then reveal all. In the layer pallette you can click on the mask and draw in what selections you want to fade out. Use gradient fills if you want smooth fades or brush with black or white to manually fade parts.