I tracked a status of a record in a text field and wanted to sort the results in a specific order. For example I want “active” to show before “rejected” and “deleted” to show up last, etc… It turns out it was pretty easy to do in SQL. Here it is:

select * […]

Posted in SQL No Comments »

I set the DataFormatString to {0:d} and also tried {0:MM-dd-yyyy} as several forums and articles suggested; but it still wouldn’t work and kept on displaying the entire string including the time. It turns out, all I had to do is add HtmlEncode=”false”.
<asp:GridView ID=”gridItems” runat=”server” AutoGenerateColumns=”False” DataKeyNames=”ItemId”
DataSourceID=”MyItemsDataSource” Width=”100%”>
<Columns>
<asp:BoundField DataField=”Title” HeaderText=”Title” SortExpression=”Title” />
<asp:BoundField DataField=”Status” HeaderText=”Status” […]

Posted in .net, Web Dev, asp.net No Comments »

I just got my first mac ever. It’s a mac mini which I bought refurbished from Apple’s outlet store and paid $550 for it. I will be blogging about my experiences as I play with it. It’s hard to believe I am using mac, because I am a .net developer and a […]

Posted in Mac, Software No Comments »

I start reading the Getting Things Done: The Art of Stress-Free Productivity book and doing some research online about GTD. I love the concept which is really common sense (at least to me) and in one way or another I have been doing that all along. Anyhow, I needed to implement GTD using […]

Posted in Productivity, Software 3 Comments »

Here is a great sql script that will look at your table and generate a script to insert all the data. This is very useful when moving databases or when you want to create a database setup in your application with some default data. Note that I haven’t tried this procedure and it […]

Posted in SQL, database No Comments »

Check out this article http://dwarfurl.com/9de21
that discusses the ineffectiveness of site-authentication images as used by some banking sites like bank of America and country wide. I personally agree, first because I can never remember the image and if every site has its own image then I will not be able to remember all images and […]

Posted in Web Dev No Comments »

I got this e-mail from UNICEF (one of my favorite non-profits). To donate go to http://dwarfurl.com/c5428
Hello,
As Mother’s Day approaches, I’d like to remind you that you don’t have to be a mother to care for kids. Please join me in honoring motherhood today by making a donation to help UNICEF immunize children and save more […]

Posted in Random 1 Comment »