Author Archives: David Bauernschmidt

David Bauernschmidt

About David Bauernschmidt

I live in the historical triangle of Virginia where I am married with two daughters. I have spent over 13 years working for a Fortune 500 company in the computer area. I started in VB 6.0 and by the time I ended my employment I was supervising a development team where we built many web applications. When my first daughter was born I wanted to spend more time with her so I left and became a programmer analyst for local government as well as launch my own company. Since then I have grown James River Webs into a profitable web design and application company helping small businesses create a big presence on the internet. As an employee I have created web application used by citizens and other companies. I enjoy fly fishing, and spending time with my family. I also enjoy learning new approaches and development tools when it comes to developing applications.

Quick Way to Populate Form Fields for Testing

If you build forms you know that testing is a necessary evil. If have a lot of html elements on that form you know it feels like you have to …

Tags: , , , , , , , , , , , , | Posted under Programming/Coding | Leave a comment

Finding Week Number in SQL Based on Fiscal Period

If your fiscal year matches the calendar year then SQL has an easy process of find the week number. You simply use something like this:

Tags: , , , , , , , , , | Posted under Programming/Coding | Leave a comment

LINQ to SQL with Totals

Ever since I have been using Linq2SQL, I am always impressed by the speed and the functionality of it. However; using SQL for 10+ years I always find my self …

Tags: , , , , , | Posted under Programming/Coding | Leave a comment