Microsoft Visual Studio – How to remove last character(s) from a string

Let’s say I am concatenating a string with values from a collection. Every time I add a value, I want to append with a comma (,) and a space to separate. I don’t know at run time how many objects … Read the rest

Microsoft Visual Studio – ASP.Net Dynamic and Static Hover Style Conflict in IE-9 Browser

When working with a menu control, I found that Internet Explorer 9 can’t handle setting both the static and dynamic hover style properties of the menu control. It works fine in Chrome and Firefox, but not IE-9.

To make IE-9 … Read the rest

Google Chrome – RealPlayer plugin does not work

Ask RealPlayer: Download This Video in Google’s Chrome Browser

by REAL TEAM on AUGUST 10, 2012

UPDATED OCTOBER 11, 2012: Chrome 22 (released on Sept. 26, 2012) does not currently support our Download This Video feature. At this time, the

… Read the rest

SQL Server – Alternative to using ‘Case When’ in Where clause of SQL Statement

I came across a scenario where I needed to write conditional statements in my WHERE clause of my SQL that was more complex than what a ‘CASE WHEN’ statement could provide.

I have two parameters, @FieldA and @FieldB. Both … Read the rest

SQL Server Reporting Services (SSRS) – Set CacheDataForPreview = False

Have you ever witnessed running a report in the Business Intelligence Development Studio only to see data that you know does not exist anymore in your SQL Database?

In certain circumstances, when previewing a report in BIDS, the environment bypasses … Read the rest

Microsoft Visual Studio – ASP.Net Using LINQ to Filter Collections

You have a collection of objects. You want a subset of that collection. Instead of making another SQL call to the database or using programming code to create a filtered subset of your original collection, you can accomplish this simply … Read the rest

Microsoft Visual Studio – ASP.Net How to Pass a Wildcard Parameter to a Table Adapter Query

If you are not using a stored procedure for you table adapter, then the answer is DON’T!!

I have done a lot of research and have found no perfect answer. Trying to pass ‘%’ to the fill method or embedding … Read the rest

Microsoft Visual Studio – ASP.Net Error in IE 9 When Using ReportViewer : No Such Interface Supported

While I was debugging in Visual Studio 2010, I come across this error when working with an aspx page that has a report viewer control. This only happens with IE. My report displays, but as soon as I click a … Read the rest

SQL Server Reporting Services (SSRS) – Dealing with multiple date ranges with the option of choosing NULL for the start and/or end date in SSRS Reports

select * from date_range_table
where

((@startdate1 IS NULL AND @enddate1 IS NULL)
OR (start_date1 >= @startdate1 AND start_date1 <= @enddate1)
OR (start_date1 >= @startdate1 AND @enddate1 IS NULL)
OR (@startdate1 IS NULL AND start_date1 <= @enddate1))

AND

((@startdate2 IS NULL

… Read the rest

WordPress: How to manage email subscriptions

To see, deactivate, or delete email subscriptions to your feed:

1) Login to www.feedburner.com
2) click Feed Title
3) Click ‘Publicize’ tab
4) Click ‘Subscription Management’ left column
5) Scroll to the bottom and click ‘View Subscriber Details’… Read the rest