Byte Food

Google Adwords conversion failing with Ajax

2011-12-06T17:30:00.004+02:00

Google adwords conversion script (conversion.js) uses document.write(), which prevents it from working correctly when using dynamic Ajax page loading.

Excelent workaround here:

http://articles.adamwrobel.com/2010/12/23/trigger-adwords-conversion-on-javascript-event

Visual Studio Macro: Locate Item in Solution Explorer

2011-08-31T16:32:00.000+03:00

This is a great macro that allows you to locate the current file in edition on the Solution Explorer:

Visual Studio Macro: Locate Item in Solution Explorer on Demand « Critical Development:

Using WinMerge with Team Explorer and TFS

2011-08-05T12:52:00.000+03:00

Nice page explaining how to change the default file compare on Visual Studio Team Explorer:

Rory Primrose | Using WinMerge with TFS

WCF and error serializing enums

2011-08-03T17:08:00.000+03:00

I had a similar problem as described here: WCF error caused by a serialisation issue

The exception thrown was too generic: The socket connection was aborted. This could be caused by an error processing your message or a receive timeout being exceeded by the remote host, or an underlying network resource issue. Local socket timeout was '00:00:59.7490000'

The best way to go to find reasons for problems not explicitly shown by WCF exceptions is to use the Trace Viewer described in this thread.

Exception was all in the log generated by the server side of WCF.

Visio diagram lines changed on copy paste?

2011-07-21T12:42:00.001+03:00

I drew my diagram on Vision 2003 all nice, when I copied it to Word the dashed lines were changed to solid lines!

Found the resolution on good old Microsoft Support site.

Dashed or dotted line patterns are converted to a solid line pattern when you embed a Visio 2003 object in another document

Using IDs in jQuery Mobile Pages

2011-07-18T18:33:00.002+03:00

With JQuery Mobile different server pages are loaded on the same client DOM.

If you need to access an element by ID or class which conflicts with another element on another page with the same ID or class (in my case it was the same page with different parameters) you can use the ancestor on the JQuery selector as described by cplee70 in this forum thread:

Using IDs in jQuery Mobile Pages - jQuery Forum: "

$('div.ui-page-active .lat') instead of just: $('.lat')

EDIT:

Better yet, I started using: $('.lat', $.mobile.activePage)

aspnet_wp.exe stopped unexpectedly

2010-06-23T19:49:00.002+03:00

On one of our deployed environments ASP.NET crashed completely when accessing an Interop dll that invokes MATLAB code.

We isolated the line of code that had the problem, this would run ok from a console application but crash miserly on ASP.NET. Event viewer shows "aspnet_wp.exe (PID: xxxx) stopped unexpectedly".

After spending a lot of time trying different things and googling, I finally ran into this one.

I'm not sure of the security consequences of this change, but since it is on the .NET context, for that environment it seems like a safe solution.

Xcopy not working from System.Diagnostics.Process.Start()

2009-10-15T15:34:00.001+03:00

This one wasn't easy.

See http://social.msdn.microsoft.com/Forums/en-US/netfxbcl/thread/ab3c0cc7-83c2-4a86-9188-40588b7d1a52/

"This is a quirk of xcopy.exe. If you redirect the output, you have to redirect the input as well."

SQL 2008 - "Saving changes is not permitted."

2009-09-07T10:22:00.001+03:00

On SQL 2008 Management Studio Icoudln't save the changes done on a table.

This seemed strange, but was easy to fix:

http://weblogs.asp.net/pabloperalta/archive/2008/09/23/sql-2008-quot-saving-changes-is-not-permitted-quot-error-message.aspx

Running dynamic javascript generated on the UpdatePanel partial postback

2009-04-21T21:28:00.003+03:00

I found this great piece of code that allows a more or less generic way of running javascript generated during the processing of a partial postback within an UpdatePanel.

It runs all the script inside script tags with a certain ID.

http://www.31a2ba2a-b718-11dc-8314-0800200c9a66.com/2008/08/dynamic-javascript-in-update-panel_19.html?showComment=1240338420000#c118959118652221112

Stuck with static constructor exception

2009-04-17T10:48:00.002+03:00

It took me quite some time to understand why I was getting allways the same exception on a static constructor. So this blog confirmed what I suspected. The exception is cached and thrown again:

http://weblogs.asp.net/avnerk/archive/2008/12/16/static-constructor-throws-the-same-exception-again-and-again.aspx

I found this with .NET2.0 I believe .NET 3.5 works differently since they added this to the documentation:

"If a static constructor throws an exception, the runtime will not invoke it a second time, and the type will remain uninitialized for the lifetime of the application domain in which your program is running"

Check if 2 dates belong to the same week

2009-03-18T17:08:00.002+02:00

I found this post while looking for the solution to the problem in C#.

http://quickduck.com/blog/2008/11/03/reader-challenge/

I endded up using the code:

   public static bool InSameWeek(DateTime d1, DateTime d2)
   {
   DateTime beginningOfWeekDate1 = GetFirstDayOfWeek(d1);
   DateTime beginningOfWeekDate2 = GetFirstDayOfWeek(d2);
   return beginningOfWeekDate1 == beginningOfWeekDate2;
   }

   ///
   /// Considers monday to be the first day of week
   ///
   ///
   ///
   private static DateTime GetFirstDayOfWeek(DateTime d)
   {
   switch (d.DayOfWeek)
   {
   case DayOfWeek.Monday:
   return d;
   case DayOfWeek.Tuesday:
   return d.AddDays(-1);
   case DayOfWeek.Wednesday:
   return d.AddDays(-2);
   case DayOfWeek.Thursday:
   return d.AddDays(-3);
   case DayOfWeek.Friday:
   return d.AddDays(-4);
   case DayOfWeek.Saturday:
   return d.AddDays(-5);
   case DayOfWeek.Sunday:
   return d.AddDays(-6);
   default:
   throw new ApplicationException();
   }
   }

Equals on Javascript between different types

2009-01-17T15:23:00.000+02:00

Equality with javascript between differetn types has it's pitfalls, for example between bool and string.
Fortunately there is the operator ===
'false' == '' -> true
'false' === '' -> false

See JavaScript pitfalls: null, false, undefined, NaN - MapbenderWiki

Return a result code from a batch file

2008-11-05T18:26:00.000+02:00

How to return a result code (ERRORLEVEL) from a batch file.
exit /B 63
See Batch script return code : return, batch, code, script

Enable or Disable Triggers on SQL Server 7.0

2008-10-13T14:17:00.000+03:00

Icreated a trigger to prevent deletion of data from a table. but of course in some cases (Database initialization) ı need to override the trigger. Here's how: Enable or Disable Triggers on SQL Server 7.0

Log unexpected exceptions in a windows service and in an APPDomain in general

2008-10-06T14:42:00.001+03:00

My services stopped without reason and I had no thing on the log except the System Event Log. A good solution to log fatal errors is to use the event AppDomain.CurrentDomain.UnhandledException (see Cannot catch Exception in a thread - .NET C#)

ınclude extra classes on a web service not referenced yb the parameters directly

2008-09-19T12:00:00.000+03:00

We created a webmethod that would receive a list of objects, Sometimes these objects are integers or strings, sometimes they can be a more complex type, like CustomClass[]. Turns out that with XmlIncludeAttribute solved the problem, thanks to this post: WebMethod can't serialise an array of custom type : ASMX Web Services and XML Serialization : .NET Development : MSDN Forums

F7 to switch from ASPX "Source" to C# codebehind

2008-07-11T18:57:00.000+03:00

The trick is to configure the View.ToggleDesigner to F7. From F7 to switch from ASPX "Source" to C# codebehind - doesn't work? - ASP.NET Forums

Caching in ASP.NET with a dependency on the SQL Server

2008-06-28T21:00:00.000+03:00

As I suspected when you use caching on ASP.NET 2.0 with SQL Server Dependency in SQL Server 2005 the system is not implemented with a polling mechanis as in previous versions of SQL Server. It uses the NOtifications Services to advise the ASP.NET that some cache item must be cleared. See Caching in ASP.NET with the SqlCacheDependency Class

Microsoft certification 70-536

2008-06-22T02:03:00.003+03:00

I just watched an excellent presentation about the Microsoft certification 70-536 (Microsoft .NET Framework). I was very impressed by the quality of the presentation and the functionalities of the player itself! I have one certification made 3 years ago, and I want to do some more pretty soon, from what I could understand the first one to take for developers is the 70-536. The presentation gives a general explanation about the content of the exam. It also gives out some links to resources (pasted below).

Books and training
C# Online learning guide
Practices Tests: measureup.com , selftestsoftware.com
Blog about MS certifications

I want to get 2 kinds of materials (books?) one on the theory and one with exercises, but I still couldn't understand what's the best place for that (everyone I talk to uses some pirate memorize-the-answers books, but I think I don't want to go that way)

Page with big table and many text inputs is stuck on loading, in IE

2008-05-26T17:57:00.003+03:00

Problem: A page with a table with 300 rows and a total of 1500 input text boxes was rendered fast but I couldn't scroll for 20 seconds. It seemed like the whole Internet Explorer was stuck, frozen doing something. I tried several things to find out where the problem was.

Removed all javascript from the page, still slow
Removed all elements from the page except the basic structure (html, body, form) and the table with the inputs, still slow
Took out all id and name attributes from the inputs, still slow
Removed the form tag, page opened and scrolled fast (we need the FORM though :P)
Removed the table and kept all 1500 inputs, page opened and scrolled fast (we need the layout though :P)

Tested the page on Firefox and it would load and scroll fast. So all I could find was that a page with a form with a table containing a considerable number of textboxes would freeze in IE for some time. After asking for the help of others, in the hope of some enlightment, we found out that a friend had no problems opening and scrolling the page! I quikly realized that the problem was in the Google Toolbar AutoFill functionality... It seems like Firefox doesn't have the same problem when using the Google Toolbar.

Share and Pin in Visual SourceSafe

2008-04-21T15:40:00.001+03:00

Nice step by step on what to do to share, branch and merge with VSS, and how to integrate that with Visual Studio 2005: Share and Pin in Visual SourceSafe | testingReflections.com

Nice article about Deadlock's

2008-04-02T13:39:00.001+03:00

Very helpfull in finding the reason behing the deadlocks: Bart Duncan's SQL Weblog : Deadlock Troubleshooting, Part 1

Xsl for-each in reverse order

2008-03-28T15:36:00.001+02:00

How to invert the order in a XSL for-each

use:

<xsl:sort select="position()" data-type="number" order="descending"/>

See xsl for each reverse order - Reverse order: ""

VSS Rights by Project was disabled

2008-03-27T09:54:00.001+02:00

On Visual Source Safe Admin window I had the "Rights by Project" option disabled. Got the answer from here: RE: "Rights by Project" greyed out

Test trigger existance

2008-02-11T10:33:00.000+02:00

Cry How To - Test trigger existance: "if exists (select * from sysobjects where name='tD_Employee' and xtype='TR')"

How to show the version of the current assembly

2008-02-08T12:36:00.000+02:00

From K. Scott Allen : AssemblyVersion and Web Projects

The Sql2005 Default Backup directory using SMO

2008-01-21T15:10:00.000+02:00

using Microsoft.SqlServer.Management.Smo
"Server.Settings.BackupDirectory"
Thanks to Phil Factor's Phrenetic Phoughts : Twiddling the knobs: The Default Backup directory:

Create Excel files on .NET

2007-12-31T11:29:00.000+02:00

CarlosAg Excel Xml Writer Library seems to be a great option on creating Excel files in .NET.
Seems easy and effective, no more CSV formatting problems and create several sheets in excel in an easy way!
Unfortunately it doesn't seem to be open source, but it's still free!

Using both MaskedEditExtender and calendarextender

2007-12-17T19:30:00.000+02:00

It's not easy to use the Ajax Toolkit controls like the example in here for editing a date. Well, at least not easy if you want it to be multicultural. I used the following: //Set the culture settings CultureInfo oCulture = CultureInfo.CurrentCulture; CalendarMaskExtender1.CultureName = oCulture.Name; CalendarExtender1.Format = oCulture.DateTimeFormat.ShortDatePattern; //CalendarMaskExtender expects something like "99/99/9999" CalendarMaskExtender1.Mask = CalendarExtender1.Format.Replace( oCulture.DateTimeFormat.DateSeparator, "/").Replace( "d", "9").Replace( "M", "9").Replace( "y", "9"); And don't forge tot set the <asp:ScriptManager EnableScriptGlobalization="true">

Argh, how do you set the format on this blogger.....aahh, just view source of this page if you need to check the code..

Add another Header row resulting in multiple header rows for GridView

2007-09-12T13:39:00.000+03:00

It was quite easy to add rows to the header of the Gridview thanks to this article:
Multi Header Grid view - The Code Project - ASP.NET
It's not easy to understand the description, but if you download the sample code you can easily see how it is done.

TabContainer: Extra white space below tab title when removing the DOCTYPE

2007-09-11T16:56:00.000+03:00

This forum thread helped me solve a rendering problem with the TabContainer when in a page without DOCTYPE.
TabContainer: Extra white space below tab text - ASP.NET Forums

Running ASPX on II6 (Windows 2003) for the first time results in 404 file not found

2007-08-29T15:57:00.000+03:00

Remember that you need to enable ASP.NET from "web service extensions" in IIS.
From Can not run ASPX on a Windows 2003 Web Server... - ASP.NET Forums: "web service extensions"

How to show and hide rows in a table with javascript

2007-08-29T11:36:00.000+03:00

If you need to to hide and show rows dinamically both in Firefox and Internet Explorer (IE), set the style.display to empty string.
Thanks to The Strange Zen Of JavaScript: Table rows...revealed!

Generate Scripts by command line...

2007-08-20T14:38:00.000+03:00

It seems that there is no easy way to automatize the script generation of db objects... :(
Generate Scripts...

Using CASE in Order by Clause in SQL Server

2007-08-02T17:19:00.000+03:00

If you need to use a CASE in the ORDER BY and you have 2 different types for the expression, you end up receiving this error: "Syntax error converting the nvarchar value 'Alice Mutton' to a column of data type int."
Check out the solution at Using CASE in Order by Clause in SQL Server - ExtremeExperts.

Try Catch in Sql Server 2005

2007-07-26T15:12:00.000+03:00

Here's a good short text about error handling and transaction handling in Sql Server 2005 using Try Catch.

Select a row in a GridView by clicking anywhere on the row

2007-07-19T18:06:00.000+03:00

Here's how to select a row in a GridView by clicking anywhere on the row. On RowCreated you set
e.Row.Attributes.Add("onclick", Page.ClientScript.GetPostBackEventReference(
new PostBackOptions( GridView1, "Select$" + e.Row.RowIndex)));
I got some help from this post, even though he was looking for an answer to a different problem.

RadioButtonList with and AJAX UpdatePanel and AsyncPostBackTrigger

2007-07-16T17:29:00.000+03:00

When using the RadioButtonList with an AsyncPostBackTrigger I just had a server event on the first change. I was going slightly mad until I found this:
Mike Ormond's Blog : The Curious Case of the RadioButtonList not Triggering

LLBL, don't generate the date and time on the header of the files, for VSS

2007-07-16T16:15:00.000+03:00

You may not want the date time generated onm every file if you use VSS, no need to check-in the file if nothing changed.
HnD::List all messages of thread: Is there any way to switch off the 'Code Generated On' comment in the Generated code?: "TdlEmitTimeDateInOutputFiles"

MS Ajax AutoComplete using a page method

2007-07-16T14:38:00.000+03:00

Had to google to find this one. AJAX documentation doesn't tell all.
You nees to set the method as static if you want to use a page method instead of a web method.
MS Ajax AutoComplete Extender using a Page Method « All Wrong

Register the onclick event for a Radiobuttonlist

2007-07-12T12:13:00.000+03:00

If you need to set the onclick client event for each radio button in a Radiobuttonlist, it's not obvious.
This page was usefull for me, although it contains a solution for ASP.NET 1.
In ASP.NET 2 I ended up doing something similar but using Page.ClientScript and document.getElementsByName('<%rbl.UniqueID%>'); and then setting the onclick event dynamically.
You need to give a function reference to the event and inside the function you can use "this" to accerss the radio button properties.

Recovering Deleted Files

2007-07-10T11:55:00.000+03:00

I just had an unfortunate accident, while playing with the delte command of nant ended up deleting some important files! And it deletes them completely, not into the recycle bin...
I immeditely googled an found this: Recovering Deleted Files which was of great help, recovered all of the files except one, I guess I should have stopped using the computer imediately...

The difference between ResolveUrl and ResolveClientUrl

2007-07-10T10:57:00.000+03:00

Ever wondered what is the difference between ResolveUrl and ResolveClientUrl?
I did:
"In simple terms, ResolveClientUrl returns a path relative to the current page, and ResolveUrl returns a path relative to the site root."
From Andornot Developers' Blog: ResolveUrl vs. ResolveClientUrl

Focus in ASP.NET Controls

2007-07-04T15:14:00.000+03:00

There are several ways to set the default focus on a asp.net control.
It was great to find out that it's enough to do a txtName.Focus();
See Focus in ASP.NET Controls

Allowing special keys like F5 for onkeypressed evetn on firefox

2007-07-03T15:04:00.000+03:00

Bumped into this problem where I was filtering the allowed keys in a input text with onkeypressed but then I noticed that the F5 wouldn't work neither when the focus was on the input.
Here's info about filtering the characters.
Here's info about allowing the F5 and special keys

IEnumerable to implement a classe for foreach

2007-06-22T21:57:00.000+03:00

If you want to implement a class that can be used with foreach you need to implement an IEnumerable. See Using IEnumerator and IEnumerable in the .NET Framework - The Code Project - C# Programming

How to escape the % (Percent) sign in a LİKE query T-SQL

2007-06-18T10:27:00.000+03:00

If you need to search the '%' sign in Transact SQL, cehcvk out the reference page for the LIKE (T-SQL):

USE pubs

SELECT notes

FROM titles

WHERE notes LIKE '50%% off when 100 or more copies are purchased'

ESCAPE '%'

File locked after sent via email attatchment

2007-06-04T15:51:00.000+03:00

When sending attatchemnts with System.Net.Mail remember to Dispose.
If you don't invoke Dispose on the attatchment the file remains locked until Garbage Collector takes action.
I preffer to dispose the MailMessage:

Using objMM As New MailMessage
...
...
End Using

Help from here

Sending E-mail .NET 1.1 and 2.0

2007-06-04T14:43:00.000+03:00

Trying to clean the warnings in VS2005 from a project migrated from .NET 1.1

I had many warnings related with mail sending. Old version is obsolete.

Here's a good reference for this, specially on how to authenticate in the new version.

Show an integer as hexadecimal in T-SQL

2007-05-31T14:16:00.000+03:00

If you need to select an integer and show it as an hexadecimal value you can use a trick, cast it to binary because Sql Server Management Studio shows binary data as hexadecimal. Example:

select cast( 1454 as varbinary(2))

Tabs using Multiview Control

2007-05-29T11:28:00.000+03:00

After some googling I could finally find a reference to a preety good implementation of Tabs using the Multiview control, without using images.

Still here (Was: Moved out to Msn Spaces)

2005-10-25T15:50:00.000+03:00

~~This blog has preety much been abandoned. I opened up a new blog where I hope to write more about software development and technology stuff. See you there.~~
I decided to use this to post interesting links I found at work.

Grocery Store Wars

2005-05-22T12:54:00.000+03:00

May the farm be with you!

Multiple dynamic combo-boxes in an HTML page

2005-05-19T18:05:00.002+03:00

While answering this question at Experts Exchange I created this javacript that maintains a variable number of combo-boxes connected with each other all on the client-side. I'm sure many people have done this several times, and there are tons of different solutions for this. Mine is a good (IMHO) open solution with the following characteristics:

Any number of combos supported (tested with 2 and 3)
Per item description supported
Javascript function hook for the last combo
IE and Firefox compatible (not tested with other browsers)
Multiple instances of combo groups on the same page supported

The solution is here.

To use it, just save the source of the file. It's not difficult to understand the logic, look at the BODY part of the file. You need to set the following:

the SELECT tags with the extra attributes
the javascript array with MCComboItem's
the action function for the last combo
Invoke MCStart function passing the references to everything and the initial values for the combos.

Rss Reader

2005-05-19T17:28:00.000+03:00

For those that are new to the blogosphere I urge you to get an RSS Reader. This is an application that allows you to subscribe to RSS feeds and easily check what's new on them. The RSS feeds can come from blogs, news sites or any other kind of site that provides a feed. I know there are many options, I recomend SharpReader for being simple and efective. But you need to have Microsoft .NET Runtime installed to use it. Once you installed your RSS reader start subscribing the feeds you want to follow. They usually are identified by an orange icon like this: Start using an RSS Reader now! Nobody has the patience to keep opening web pages with browsers anymore!

The title

2005-05-19T14:03:00.000+03:00

Thanks to Bruno for helping me with the title of this blog! I'm sure it will be number one hit in no time! Yea right...

A technology blog

2005-05-19T13:20:00.000+03:00

Lately I've been learning about this blog thing. I'm a software developer and I google a lot for help in solving everyday problems. More and more I get help from bloggers that decided to post their problems and solutions. I decided to join in and post some of the stuff I find interesting in the technology world, including everything from software development to technology internet news. And so it starts...