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 »
I see code like the following a lot: Copy Text Copied Use a different Browser 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
GridView Sort Column Arrow Performance Read More »
Below is the SQL to show how many connections are being used from my application. Copy Text Copied Use a different Browser 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 where db_name(dbid) = @Database and convert(sysname,
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 the
Checking All CheckBoxes in a GridView Using Client-Side Script Read More »
