ASP.Net

GridView Sort Column Arrow Performance

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 »

Connection Pool Misconceptions

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 »