I wanted to do some home automation, and I wanted to write the code myself (I’m a software developer.) I looked into it and decided to use Z-Wave technology. I started by buying a USB Z-Stick for about $45 to allow my laptop to talk to the different devices. This can control up to 232 […]
Programming Your Home Read More »
We have the requirement that our passwords have to change every 90 days. I wanted to automate this and it sounded pretty easy to do, but it wasn’t that easy. Why? Because there are a lot of rules for passwords. First, I have to store it in the web.config. So no XML special characters. quot
Generating Passwords Read More »
On one of our projects, we have a requirement that we have to change our passwords every 90 days. So I created a page where I can just click a button and it will generate a password, change the password on the database for the user in the connection string, and then change the password
Change Connection String Password Programmatically Read More »
I wanted to document how we do our DAL. First, performance is important, so we use ADO.NET instead of the Entity Framework, NHibernate, etc. Second, in our main project, we have 1,743 stored procs and counting, so a stored proc-centered approach is necessary. So over the years, I have reduced it down so that the
Data Access Layer Architecture Read More »
I have a page in my ASP.Net application where I show all of my AppSettings, connection strings, etc. But I didn’t want to show the passwords. I wanted something like: server=MyServer;uid=MyUserId;pwd=*******;database=MyDatabase; So here is the code to strip out the password: Copy Text Copied Use a different Browser private string stripPassword(string connString) { if (string.IsNullOrEmpty(connString))
Stripping Out Passwords Read More »
I needed to display some parent data with its child data on the same row as shown in the image above. I happen to be combining a few tables together into a new table (called dtPlan) and then binding the GridView to that new table. So this was my approach while moving the data into
Grid within a GridView Cell Read More »
Part of my pattern during development is to: 1. Create a new table 2. Create the stored procs to get data and save data 3. Create the data access layer methods that call the stored procs. This is a little tedious, so I created a SQL stored proc called createDALFromSP to generate a data access
Generate Data Access Layer Methods From Stored Procs Read More »
In a previous post, I had a system to only log the start and end of an outage condition. To report on the outages, we need to first look at the table where the exceptions get logged: Copy Text Copied Use a different Browser CREATE TABLE [dbo].[Exceptions]( [ExTime] [datetime] NULL
Reporting when Logging only the start and end of an outage condition Read More »
In one of our ASP.NET applications, we wanted to change where the AppSettings were stored from a config file to a database table. Since this is a very large application (over 670 .cs files), the first requirement was that the majority of the changes needed to be done with a search and replace. In the
Moving AppSettings to a Database Table. Read More »
Machine.config is used for machine-specific items – thus the name. It never gets moved from machine to machine. So that is where you put your connection strings. Doing this, you will never have the horror of realizing your QA team has been hammering against your production data because someone forgot to account for the web.config
Where to put the connection string Read More »
