One of our applications has a page for our users to report bugs. We wanted to allow them to “attach” one or more files to the bug record. The files could be screen shots, spreadsheets, etc. So the bug entry page would have the normal data entry part and have the following box at the […]
Attaching upload files to a record. Read More »
I was having a lot of code that looked like the following: if(dr["StartTime"] != DBNull.Value) tbStartTime.Text = dr["StartTime"].ToString("M/d/yy H:mm"); else tbStartTime.Text = ""; and: tbStartTime.Text = DateTime.Now.ToString("M/d/yy H:mm"); You usually use the same formatting throughout an application so I simplified
Another way to store your connection string in a way that it doesn’t get in the way when you promote your web site from Test to QA to Prod is the following: Have your web site under a given directory, say d:\WebSites\MyWebsite. And you also have another directory to hold your connection strings that isn’t
Another Place to Put the Connection String 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: CREATE TABLE [dbo].[Exceptions]( [ExTime] [datetime] NULL CONSTRAINT [DF_Exceptions_ExTime] DEFAULT (getdate()),
Reporting when Logging only the start and end of an outage condition Read More »
We found an issue with some of the older scripts having SET ANSI_NULLS OFF and this causes problems. The ANSI_NULLS ON setting is a database option that determines how NULL comparisons are handled. Under ANSI_NULLS ON, two NULL values will never be equal to each other because the two separate values are unknown. With ANSI_NULLS
SET ANSI_NULLS OFF Read More »
We have an asp.net page that auto refreshes every 8 seconds using <meta http-equiv="refresh" content="8"> This page would pull data from a linked server and whenever that link or the target server were down it would fill up our error log with an entry every 8 seconds until it came back up. This is not
Log only the start and end of an outage condition Read More »
Machine.config is used for machine specific items – thus the name. It never get 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
Where to put the connection string Read More »
I see code like the following a lot: protected void GridView1_RowCreated(object sender, GridViewRowEventArgs e) { if (e.Row.RowType == DataControlRowType.Header) if (String.Empty != this.GridView1.SortExpression) AddSortImage(e.Row); } The problem with this is that it fires for each row in the GridView slowing performance. A better way is the following which only fires once
GridView Sort Column Arrow Performance Read More »
Below is the sql to show how many connection are being used from my application. declare @Database varchar(30), @LoginName varchar(30) set @Database = 'MyDB' set @LoginName = 'MyLoginName' select max(blocked) hasBlocking, count(1) [Count], sum(open_tran) open_trans, max(waittime) maxWaitTime from master.dbo.sysprocesses (nolock) where db_name(dbid) = @Database and convert(sysname, rtrim(loginame)) = @LoginName We
Connection Pool Misconceptions Read More »
Given a GridView like the one below, I want to add the ability to check the check box in the header and have that event check all of the checkboxes in each row. I did this by adding 12 lines of JavaScript code and adding 1 attribute to my header template. Below is
Checking All CheckBoxes in a GridView Using Client-Side Script Read More »
