Simple method to constrain stored procedures by a collection(www.charlesrcook.com)

submitted by ccook(320) 1 month, 1 day ago

Passing a collection of ID's to filter a SQL query within a stored procedure is not natively supported. Consider this article which discusses methods for passing arrays into a stored procedure. Constraining a stored procedure's query has a simple work around, however. Passing the ID collection as a comma deliminated string allows the query to use LIKE to constrain the results. Note that the preceding and trailing commas are necessary. An example demonstrates how to do this easily. read more...

add a comment |category: SQL |Views: 8

tags: SQL another

Undo Within Selected(charlesrcook.com)

submitted by ccook(320) 2 years, 11 months ago

Today I was working on some code, nothing particularly different than any other day. I did something I have done thousands of times before, made some changes, and then needed to get previous code back. This was quickly done with undo several times, copy to clip board, redo several more and then paste. Then it hit me, why don't we have an undo within selected text? We have a search and replace within selection. Undo within selection complements the search and replace really well, and further, allows for quicker retrieval of code several edits ago. Particularly when the change was a single iteration ago in a particular location… In a sense spatial undo versus temporal undo. Hopefully this will make it into Visual Studio some day, either as a power tool or third party plug-in. read more...

add a comment |category: Tips & Tricks |Views: 3

tags: Tips another

Installation and Configuration of Microsoft Velocity(aspnetpodcast.com)

submitted by wallym(2085) 3 years, 2 months ago

David walks us through how to install and configure Microsoft Velocity. read more...

add a comment |category: Architecture |Views: 518

tags: Architecture another

ASP.NET MVC goes RTM before MIX09(codeclimber.net.nz)

submitted by simonech(10.1k) 3 years, 2 months ago

Not sure if the release was intentional or just someone that forgot to set the timezone field while publishing the download, but ASP.NET MVC has been RTMed before MIX09. read more...

1 comment |category: MVC |Views: 169

tags: ASPNETMVC MVC CodeClimber another

ASP.NET MVC 1.0 released(microsoft.com)

submitted by alexandrul.ct(475) 3 years, 2 months ago

ASP.NET MVC 1.0 RTM is released read more...

7 comments |category: MVC |Views: 458

tags: asp.netmvc ASPNETMVC MVC another

Getting Mono and Visual Studio to play nice together(chriscyvas.wordpress.com)

submitted by ccyvas(635) 3 years, 3 months ago

The goal was to get some Mono project templates working with Mono assemblies and the Mono compiler in Visual Studio. The trick was to do it in a way that would be able to survive upgrades of Mono installations. read more...

add a comment |category: MVC |Views: 300

tags: Mono VisualStudio OpenSource another

ASP.NET MVC 1.0 Release Candidate Now Available(weblogs.asp.net)

submitted by sharplife(4570) 3 years, 3 months ago

Finally Scott Guthrie announced ASP.NET MVC 1.0 RC. Check it out. read more...

2 comments |category: MVC |Views: 239

tags: MVC ASPNETMVC ScottGu Pick another

jQuery Playground from Google(code.google.com)

submitted by verbalKint(585) 3 years, 4 months ago

Awsome tool to test jquery online read more...

1 comment |category: jQuery |Views: 2419

tags: jQuery another

Developer Productivity - 5 Ways To Kill It(geekdaily.net)

submitted by justinbezanson(1555) 3 years, 4 months ago

In keeping with the sarcastic tone of my How To Be The Worst Developer Ever post I’m going to explore several ways for managers to systematically destroy productivity among their developers. Unfortunately I am writing some of these from experience, then again, I’m sure we have all experienced some of these at one time or another. read more...

5 comments |category: Community |Views: 763

tags: Community another

What Part Of The Process Are Your Tools Optimized For?(codethinked.com)

submitted by justin_etheredge(8539) 3 years, 4 months ago

I'm writing this post because I am getting tired and weary of people pointing to "drag and drop tools", "visual designers", and "wizards" as reasons to use a particular tool. Only in Microsoft-land are developers so enamored with "wizards" and "drag and drop" and I think this is because Microsoft is the proverbial "crack dealer" when it comes to providing these tools. read more...

add a comment |category: Architecture |Views: 223

tags: CodeThinked Architecture another

jQuery 1.3.1 Released(blog.jquery.com)

submitted by sharplife(4570) 3 years, 4 months ago

This is a fix to recently released jQuery 1.3 read more...

add a comment |category: jQuery |Views: 332

tags: jQuery another

SQL SERVER - Rules for Optimizining Any Query - Best Practices(blog.sqlauthority.com)

submitted by pinaldave(9662) 3 years, 4 months ago

This subject is very deep subject but today we will see it very quickly and most important points. May be following up on few of the points of this point will help users to right away improve the performance of query. In this article I am not focusing on in depth analysis of database but simple tricks which DBA can apply to gain immediate performance gain. read more...

4 comments |category: Database |Views: 647

tags: BUT CAT ABIT pinaldave WANK another

Whitehouse.gov: an ASP.NET site(dotnetperls.com)

submitted by samdnp(980) 3 years, 4 months ago

This article looks into the JavaScript libraries, HTTP headers, platform and more of the new Whitehouse website. It includes statistics and some suggestions. read more...

5 comments |category: ASP.NET |Views: 676

tags: ASP.NET another

A new breed of magic strings in ASP.NET MVC(lostechies.com)

submitted by johnsheehan(4785) 3 years, 4 months ago

One of the common patterns in Ruby on Rails is the use of hashes in place of large parameter lists. Instead of hashes, which don’t exist in C#, ASP.NET MVC uses anonymous types for quite a few HTML generators on the view side. This is a trick used by the MVC team to simulate hashes. Since the dictionary initializer syntax is quite verbose, with lots of angly-bracket cruft, anonymous types provide a similar effect to hashes. However, don’t let the magic fool you. Anonymous types used to create dictionaries are still dictionaries. read more...

2 comments |category: MVC |Views: 373

tags: MVC another

How to Calculate Network Utilization in .NET(nayyeri.net)

submitted by niik(365) 3 years, 4 months ago

How to calculate utilization of a particular network interface in .NET using performance counters and a bit of math. read more...

add a comment |category: C# |Views: 519

tags: .Net KeyvanNayyeri C# Performance another

jQuery 1.3 Released(blog.jquery.com)

submitted by gavinjoyce(25.7k) 3 years, 4 months ago

"The jQuery team is pleased to release the latest major release of the jQuery JavaScript library! A lot of coding, testing, and documenting has gone in to this release and we're really quite proud of it. " read more...

add a comment |category: jQuery |Views: 480

tags: jQuery another