Copy Text Copied Use a different Browser — 1. Insert posts INSERT INTO wp_posts ( post_author, — change to your WP user ID (usually 1) post_date, post_date_gmt, post_content, post_title, post_excerpt, post_status, comment_status, ping_status, post_name, post_modified, post_modified_gmt, post_type, comment_count, guid ) SELECT 1 AS post_author, p.DateCreated AS post_date, UTC_TIMESTAMP() AS post_date_gmt, — or convert properly if […]
I wanted to monitor one of my system from my desk top and from my phone. I found a simple solution whereby I can subscribe to the result set of a stored proc by using RSS. So I can have this feed MS Outlook, my phone or my web browser. First, Visual Studio 2010 makes
Having the Result Set of a Stored Proc Sent to You by RSS Feed. Read More »
For a long time I’ve been logging all of my exceptions to a table that looks like: Now for exceptions that were generated by the database I want to also log the exact database call that caused the exception. It will make debugging go a lot faster. For this I have a new table: This
Logging Exceptions and the Commands that Caused Them. Read More »
On one of our projects we have a requirement that we have to change our passwords every 90 day. 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 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: private string stripPassword(string connString) { if (string.IsNullOrEmpty(connString)) return connString; int pos
Stripping Out Passwords Read More »
I needed to display some parent data with it’s child data on the same row like 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 »
Not many developers realize that you can change a plain HTML object’s attributes in the code behind without having to convert it into an ASP.Net control. So if I have a checkbox like this: <input type=”checkbox” id=”cbShowDef” name=”cbShowDef” onclick=”javascript: show()” /> I can hide this in the code behind with: ((System.Web.UI.HtmlControls.HtmlInputCheckBox) Form.FindControl(“cbShowDef”)).Style.Add(“display”,”none”);
Changing HTML Attributes on ASP.NET Pages in the Code Behind Read More »
A lot of times you have something like a description column and you want to display it in a GridView. But since for some of the rows the description column can be very long, it doesn’t always work very well. One solution is where you set the TD’s attribute NOWRAP, then the column runs off
Displaying a Long Description Column in a GridView Read More »
I have a page where the user can select which users are active (using CheckBoxes), and also select one (only one) to be the administrator. I put together this sample to show how I did it. The sample uses technologies instead of user. The picture below gives you an idea. I didn’t want to
Select One Row From a GridView Read More »
The question came up asking how to change something in a GridView row based on something else in that row without doing a postback. So I created a simple example where if you check a CheckBox then another column in that row would have it's background color changed. I did this in a generic way
How to Work With a GridView Row in JavaScript Read More »
