ASP.NET

ASP.NET Multi-Select Radio Buttons

“HERESY!” you say, “Radio buttons are for single-select items!  If you want multi-select, use checkboxes!”  Well, I would agree, and that is why I consider this a significant bug that ASP.NET developers need to be aware of.  Here’s the situation. If you use ASP:RadioButton controls on your WebForm, then you know that in order to get them to behave properly, that is, to define a group in which only one of them can be selected by the user, you use the Group attribute and set the same value on each one.  For example: ...

Fix for EF4 Profiler Issue Coming in next Cumulative Update

Hey!  What do you know?  Microsoft Connect really works! I was very happy this morning to open my email and find a notice from Umachandar on the SQL Programmability Team that they have created a fix for the Odd Profiler Results with EF4 issue that I wrote about last June.  Not only did I blog about it, but I logged an item to Connect with repro steps and sample code.  And now, they have announced that they have a fix for this problem and that it will be included in the next Cumulative Update for SQL Server 2008 R2....

Work-Around for Odd Profiler Results with EF4

A couple of months ago I wrote a post about Odd Profiler Results with Entity Framework 4.  Thanks to Olaf Tinnemeyer, we now have a simple work-around that he posted to my question on StackOverflow. When using the Visual Studio tools to create the Entity Data Model, it automatically builds the Connection String for you, and one of the default settings is to set the MultipleActiveResultSets option to True.  If you change this setting to False, then Profiler will properly report that the query was executed within the application database. Please note that I have not done any...

Profiler and Entity Framework Bug Logged to Connect

As a follow-up to my previous post Odd Profiler Results with EF4, I have now logged a SQL Server bug to Microsoft Connect.  If you have similar concerns, I encourage you to logon to Connect and vote it up. If you have a solution, I encourage you to reply to my blog, or respond to my still unanswered questions on the ASP.NET Forums or Stack Overflow or Server Fault.  I will happily mark your answer as correct (assuming that it is).

On Web Camp and Convention Facilities

I attended the Web Camp in Redmond last Friday at the Microsoft Conference Center.  It was a really nice setup in the room with rows of tables (plenty of space between them) and long power strips so every attendee could plug-in their laptop.  The week before that, I attended SQLSaturday, also at a Microsoft facility, and it had rows of tables setup and plenty of in-floor outlets.  Maybe this is just to be expected at Microsoft…it makes sense that of the events that will be held at a Microsoft facility, it is likely that a large portion of the attendees...

Odd Profiler Results with EF4

I have been doing some testing of using the Microsoft Entity Framework 4 with stored procedures and ran across some really odd results in SQL Server Profiler. The application that is running which uses Entity Framework 4 is a simple Web Application written in C#, and the Entity Data Model is actually contained in a referenced class library of its own.  I’ll write more about my experiences with this later.  For now the question is, why does SQL Profiler think that the stored procedure is running in Master, and not in my application database? While analyzing the effects...

Too Clever for My Own Good

Yesterday I caught myself being a little too clever for my own good with some ASP.NET code.  It seems that I have forgotten some of my good old classic HTML and JavaScript skills, and become too dependent on the .NET Framework and WebControls to do the work for me.  Here’s the scenario… In order to improve the User Interface and better communicate to the user when something is happening that they need to wait for, we have started to modify some of our larger (slower) pages to display messages like Processing… or Reloading… while they are cycling through a...

Guessing Excel Data Types

Note to Self HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Jet\4.0\Engines\Excel: TypeGuessRows = 0 means scan everything. Note to Others About 10 years ago I stumbled across this bit of information just when I needed it and it saved my project.  Then for some reason, a few years later when it would have been nice, but not critical, for some reason I could not find it again anywhere.  Well, now I have stumbled across it again, and to preserve my future self from nightmares and sudden baldness due to pulling my hair out, I have decided to blog it in the hopes that I...

Debug – Terminate All

I was debugging an ASP.NET Web Application Project today and when I got to a breakpoint and then clicked the Stop Debugging tool button, it appeared to stop just fine, closing Internet Explorer and returning me to my editor. But what really happened was that the code had continued to run.  I thought I had seen this behavior before, but this time I had conclusive proof because it updated 45 records in my database with data representing the bug which had led me to want to stop in the first place. So what happened?  I thought when I told...

Debugging with IE8

I recently upgraded to Internet Explorer 8 because I was having an issue with a collection of sites that I visit regularly (typically opening them in a tab group).  There is something renegade that frequently caused IE7 to crash if I too-quickly closed a tab and tried to scroll or quickly close another tab...it was annoying, but not enough for me to truly troubleshoot and pinpoint the culprit.  This didn't happen all the time, but when it did, usually that group was involved.  Well, I thought maybe it was just something screwy with my dev machine, and maybe the IE8...

CodeBehind vs. CodeFile and the 'does not exist in the current context' Error

I find myself spending more time in .NET code lately.  While I was verifying my understanding of one of the other attributes of the @Page directive under the ASP.NET 2.0 (Visual Studio 2005) release, I stumbled across the following note regarding the CodeBehind attribute: This attribute is included for compatibility with previous versions of ASP.NET, to implement the code-behind feature. In ASP.NET version 2.0, you should instead use the CodeFile attribute to specify the name of the source file, along with the Inherits attribute to specify the fully qualified name of the class. So,...

«August»
SunMonTueWedThuFriSat
272829303112
3456789
10111213141516
17181920212223
24252627282930
31123456