Josh Tenenbaum

Client Sorting on a GridView Part B

Josh Tenenbaum — Thu, 20 Jan 2011 01:42:46 GMT

I forgot this:

You can run this on $().ready(function() {

SetHeaderSortLinks('aGrid', 'Get()');

});

In the global js include.

function SetHeaderSortLinks(parent, functionToCall) {

//Clear existing links

$("#" + parent + " th").unbind("onclick");

$("#" + parent + " th").bind("click", function () {

var sortOn = $(this)[0].sort;

if (currentSortField == sortOn)

currentSortAsc = !currentSortAsc;

currentSortField = sortOn;

eval(functionToCall);

});

}

I'll probably add some css to change the cursor on mouseover based on the attribute (probably add an additional class in the function above)…

ASP.Net GridView, Client Binding, and Sorting

Josh Tenenbaum — Wed, 19 Jan 2011 23:49:33 GMT

I read a blog post a few months back about client binding your Asp.Net GridView. It was Called Bind Gridview using Jquery. I took it to heart and now I'm using it, except it doesn't handle client sorting (paging is another story). Granted this has some room for improvement and my js isn't the best…

Base Page method with the grid view:

protected void SetHeaderAttribs(GridView grid)

{

for (int i = 0; i < grid.Columns.Count; i++)

{

TableCell cell = grid.HeaderRow.Cells[i];

DataControlField field = grid.Columns[i];

if (!string.IsNullOrEmpty(field.SortExpression))

{

cell.Attributes.Add("sort", field.SortExpression);

}

On the Aspx page:

<asp:GridView ID="aGrid" runat="server" AutoGenerateColumns="false" AllowPaging="false" UseAccessibleHeader="true" ShowHeaderWhenEmpty="True">

<asp:TemplateField HeaderText="Milestone" SortExpression="Name">

<asp:HyperLink ID="lnkMilestoneId" runat="server" Text='<%# Eval("Name") %>' NavigateUrl='#' onclick='<%# "Edit(" + Eval("Id") + "); return false;" %>'/>

</ItemTemplate>

</asp:TemplateField>

<asp:BoundField DataField="DateStart" HeaderText="Start Date" SortExpression="DateStart"/>

<asp:BoundField DataField="DateEnd" HeaderText="End Date" SortExpression="DateEnd" />

In my global js include file:

function SortJSON(data) {

if ("" == currentSortField)

return;

data.d.sort(sort_by(currentSortField, currentSortAsc, function (a) { if (null != a) return a.toUpperCase(); else return null; }));

}

var sort_by = function (field, reverse, primer) {

reverse = (reverse) ? -1 : 1;

return function (a, b) {

//Note my json is an IList<X>, and the property can be something like "User.Name"

a = eval("a." + currentSortField); //a[field];

b = eval("b." + currentSortField); //b[field];

if (typeof (primer) != 'undefined') {

a = primer(a);

b = primer(b);

}

if (a < b) return reverse * -1;

if (a > b) return reverse * 1;

return 0;

}

In my ajax call:

function Bind (data) {

//This removes older results

$("#aGrid .dataItem").remove();

//Sorting call

SortJSON(data);

//Add the columns (give it a class dataItem so I can remove them cleanly with jquery above.

for (var i = 0; i < data.d.length; i++) {

$("#aGrid").append(

"<tr class='" + OddEven(i) + " dataItem'>"

+ "<td><a href='#' onclick='Edit (" + data.d[i].Id + ");return false;'>" + data.d[i].Name + "</a></td>"

+ "<td>" + data.d[i].StrDateStart + "</td>"

+ "<td>" + data.d[i].StrDateEnd + "</td>"

+ "</tr>"

);

}

Domain Hosting

Josh Tenenbaum — Wed, 19 Jan 2011 23:16:23 GMT

After hosting my domains with Godaddy for a few years, I was tired of the extra charge for private registration. I found that Hover offers it free and a few months back, I switched one of my domains. Wow! Godaddy really made that hard: When I authorized the transfer, Godaddy immediately stopped resolving DNS lookups even before domain propagation completed—this resulted in any email or web requests failing because their server did not return those server ips. When I called them, they either were clueless and did not know what they were doing or deliberately misled me to believe they had not done that and were not at fault. To make a long story longer, becareful leaving Godaddy—setup a new Name Server and change it before you approve the domain transfer.

Hope this saves somebody else…

Note to self about SubSonic

Josh Tenenbaum — Wed, 10 Dec 2008 21:57:50 GMT

If you are using SubSonic, don't name your column "CreatedBy." It appears to be a bad name… Now if I could figure out how to do a left outer join with multiple join criteria.

Not complaining, just making a note for myself (and others).

Why ripping DVDs should be legal

Josh Tenenbaum — Fri, 11 Jul 2008 03:42:35 GMT

I was listening to Natalie Del Conte on the Buzz Out Loud podcast (#762) today and I have to say, I am surprised at her attitude that people shouldn't backup their own DVDs: She obviously doesn't have children. After replacing 2 discs because of my kids ignoring me when I said to leave the DVD in the player; I totally see that backing up legally owned copies of DVDs for your own use is totally legitimate.

Why Jeff Atwood is crazy

Josh Tenenbaum — Fri, 11 Jul 2008 03:35:49 GMT

I've been listening to the StackOverflow podcasts recently—not as polished as some. Still, I enjoy the content. During episode #12, Jeff complained about the lack of specific criticism. My main point of disagreement is with his need to re-invent the wheel. Specifically, when he said he wanted to rewrite the login functionality for the stackoverflow site. I'm a pretty selective developer and I like to find places where I can refactor code to the point of removing as many lines as possible. But, I just don't see the point of taking tried and true login functionality and saying, no thanks: Especially since it is security code that involves passwords and login information.

Having said all that, I admire Jeff and I avidly read his blog. I just think he should look to reuse and then refactor. Too much is already written that shouldn't be rewritten.

Any order?

Josh Tenenbaum — Tue, 26 Feb 2008 03:24:11 GMT

Friday we deployed a major milestone, albeit 3 years late. We finally deployed our main application in .Net 2.0. Years and years of requests to allow us to do so and another project requesting it did the trick.

So, after 427 builds, we sent the deployment package to the group that manages the servers. The deployment is split into 3 archives: 1) the web site, 2) the sql patches, and 3) the stored procedures. The dba ran the patches and was running the stored procedures when he called me at 8:30 to tell me he was getting an error. I thought this odd and asked him to run them again. He did so and as it turned out the tool that runs the stored procedures reported an error on the procs it was running. Somehow the DirectoryInfo.getfiles call returned the list of files ordered by last modified date. I'd never seen that. I also didn't see any documentation that explained the order or how to change it. I did make an Array.Sort() call and that fixed it.

It's just a good idea to never assume an order obviously.

Blind SQL Injection ?

Josh Tenenbaum — Thu, 21 Feb 2008 03:22:27 GMT

My team recently upgraded our web application to Asp.Net 2.0 from Asp.Net 1.1. Yesterday was the first deployment since the upgrade. Overall, the conversion went well. But an odd thing happened during the mandated Vulnerability Assessment that is required before the application go live. I received an email that said "A high risk 'Blind SQL Injection' is showing up on the http://<domain> /<virtdir>/common/error.aspx URL on the aspxerrorpath object." I looked at the page, but it literally did nothing in the database (read or write). Not a thing. I thought maybe a Cross Site Scripting vulnerability, but certainly not a SQL injection problem. But, anybody who has worked in a large organization knows, the path of least resistance is the best.

I decided to address the perceived issue by overriding the OnError event in a common base class for all the pages in the site. I made sure I didn't pass the aspxerrorpath param and voila: We passed today.

CruiseControl.Net Subversion Error

Josh Tenenbaum — Thu, 21 Feb 2008 03:12:53 GMT

I use Subversion (1.4.5.25188) via Apache (2.2.6.0). I use CruiseControl.Net (1.0.1.1277) as our build server. I setup Subversion in a non-standard manner. And, it could account for the problem. All the users who access Subversion, do so via a domain login. That is except for the build user. I setup the build user as a local account on both the Subversion server and the Build server with the same password. I then setup a second location alias in Apache to also use SSPI authentication, but I set the "SSPIDomain" to Off. This allowed the user base to only have to put in their username without a domain and the allowed the local accounts to work via the second location.

All was fine until I started getting a build Exception that said "authorization failed." I was able to reproduce this and I tried all I could think of to fix it. Yesterday, I had an epiphany (understand I am paranoid): I setup the account to use SSL, and then to use basic authentication. I had avoided this in the past because I didn't want any passwords embedded in any scripts.

…The problem occurred only occasionally, but seemed to be occurring more often...

I also added another directive:

Order Deny, Allow

Deny from all

Allow from 192.168.xxx.xxx

I believe with this added, I have now effectively locked access down to only the build server.

More than just a Build Process

Josh Tenenbaum — Thu, 01 Nov 2007 14:02:49 GMT

I was just reading Jeff Atwood's "The F5 Key Is Not a Build Process." I find it interesting that the build process seems to be the end of it. The reality is that you also have to have a document telling people how to access all the code and what they need to have installed on their computer. It could be a page or 20 pages, but if you don't document all the software needed and the steps to configure it, you are just as lost as only having the build process. Mainly because you most likely have one or two people on the project still in charge with that information locked in their heads.

Don't get me wrong, I love the automated build process. I just advocate more and not just as a mechanism to have it. We have added 3 new people to the team, and I literally have handed them this document and said, "Look through this before you ask me any questions." And, its worked—except for our Project Manager…

Stupid Javascript bug

Josh Tenenbaum — Fri, 05 Oct 2007 20:08:06 GMT

I received an error that said, "Line 1: Syntax Error." I kept debugging the error, but I didn't think the document definition was causing the error. In the end, I found another developer on the project, had an onmouseover event getting set into a div on via the innerhtml property that included something like onmouseover='somefunction(someobject,'',someotherobject);'. It wasn't quite that simple, but essentially it was too long to find. Unfortunately, the debugging isn't what it should be and the developer didn't test his work.

Outlooks’s missing feature

Josh Tenenbaum — Fri, 05 Oct 2007 20:05:08 GMT

Outlook needs a filter by alias sent to. If someone sends you an email and I guess BCC's you, outlooks filters won't see a "to" in the filter and it won't allow the mail to be sent to a folder. But, if you look at the headers, you can see the destination address.

Problems with Security Update for Visual Studio 2005 SP1

Josh Tenenbaum — Wed, 12 Sep 2007 01:52:03 GMT

Is anybody else experiencing problems with the Security Update for VS2005SP1? I have installed it twice to no avail. It says it completed successfully, and then promptly requests I install it again. I've checked the obvious stuff like the Event Log for any errors and there aren't any.

Can't decide if I want company…

I read this and remembered my airline experience

Josh Tenenbaum — Fri, 31 Aug 2007 15:47:47 GMT

I forgot to post this from a while ago…but I still want to rant…

I read this post and couldn't help think about my flight experience last week. My family, which includes three kids between 4 and 8, were flying to Newark via AirTran. We arrived at the airport slightly late (but not that late); we didn't think to ask the TSA to let us skip to the head of the line and consequently after an hour in line, we finally made it through. It was 9:05 for a 9:20 flight. We went to get on the train to get to Concourse C. And, the train was broken… So, with all our stuff for three kids—and the three kids, we ran all the way. My wife and I taking turns to carry the kids at one point or another. We got to the gate at exactly 9:20 with 3 other people. The gate agent couldn't care less that the train was broken or that I just looked like I'd taken a shower. The plane was at the gate, they just wouldn't let any of us on the plane.

Debugging VS2003 javascript using IE7

Josh Tenenbaum — Fri, 31 Aug 2007 15:38:13 GMT

I recently upgraded Internet Explorer from IE6 to IE7. I added the "debugger" command to my javascript and I tried to debug, but I kept receiving an error message that said "There is no source code available for the current location." I found a few articles talking about this and I found information that VS2005 was going to be patched with VS2005SP1. The short of it is: there is a Microsoft knowledgebase article 930873. I downloaded the hotfix and all is working. Alternatively, you can move the javascript into an external file and it will work that way as well.