Finding Text in SQL Server Stored Procedures(blog.reamped.net)

submitted by kayos(890) 2 years, 9 months ago

So, I'm sure you have been met with a similar scenario during development. You know the one that you have to rename a column or even drop a column in the database. This can be quite annoying if you are doing stored procedure based data access for your application. read more...

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

tags: SQLServer TipsAndTricks SQL Database Tips another

SharePoint 2007 Project Template for Timer Jobs in Visual Studio 2005 (saftsack.fs.uni-bayreuth.de)

submitted by agnes_(290) 3 years, 11 months ago

What are SharePoint Timer Jobs? SharePoint timer jobs are tasks executed on a scheduled basis by the SharePoint Timer service. Nobody wants to do all the steps necessary to create such a job for each new timer job. So in order to make it simpler to start a new timer job project, I created a visual studio template containing all the neccessary stuff you need. read more...

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

tags: vs2005 TipsAndTricks SharePoint Tips another

Howto savely move a file using C# (saftsack.fs.uni-bayreuth.de)

submitted by agnes_(290) 3 years, 11 months ago

If possible this version uses the special File.Replace on NTFS and gracially falls back on Delete+Move on any other filesystem. Nothing else to comment about here. I am just amazed that this kind of save moving is not supported by the framework itself. Instead the framework's move routine throws an exception if there is an file existing at the target location. Weird. ;) read more...

1 comment |category: Tips & Tricks |Views: 86

tags: .Net C# TipsAndTricks Tips another

Creating a transparent Panel in .NET(saftsack.fs.uni-bayreuth.de)

submitted by mister_t(90) 4 years ago

Today I wanted to create a transparent Panel-Control in .NET in order to superimpose it on the WebBrowser Control in order to record click events. The goal was to code a simple macro recorder for websites. Unfortunatelly the .NET framework does not allow (in an easy way) to make a control fully transparent. So it was back to the good ol' winuser.h and the extended window styles. Namely 0x00000020L or as it is better known WS_EX_TRANSPARENT. read more...

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

tags: TipsAndTricks Control CustomControls .Net C# another

Creating a transparent Panel in .NET(saftsack.fs.uni-bayreuth.de)

submitted by mister_t(90) 4 years ago

Today I wanted to create a transparent Panel-Control in .NET in order to superimpose it on the WebBrowser Control in order to record click events. The goal was to code a simple macro recorder for websites. Unfortunatelly the .NET framework does not allow (in an easy way) to make a control fully transparent. So it was back to the good ol' winuser.h and the extended window styles. Namely 0x00000020L or as it is better known WS_EX_TRANSPARENT. read more...

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

tags: TipsAndTricks .Net CustomControls C# Control another

Creating a transparent Panel in .NET(saftsack.fs.uni-bayreuth.de)

submitted by mister_t(90) 4 years ago

Today I wanted to create a transparent Panel-Control in .NET in order to superimpose it on the WebBrowser Control in order to record click events. The goal was to code a simple macro recorder for websites. Unfortunatelly the .NET framework does not allow (in an easy way) to make a control fully transparent. So it was back to the good ol' winuser.h and the extended window styles. Namely 0x00000020L or as it is better known WS_EX_TRANSPARENT. read more...

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

tags: TipsAndTricks .Net CustomControls C# Control another

Using SingleTagSectionHandler Instead Of appSettings(vaultofthoughts.net)

submitted by mikeon(5200) 4 years, 5 months ago

As an alternative to appSettings you can use SingleTagSectionHandler to store settings in a web.config file. Learn how. read more...

4 comments |category: ASP.NET |Views: 419

tags: Configuration web.config TipsAndTricks another

Gridview: Where is the Row in RowCommand? DisplayIndex(mhinze.com)

submitted by chrismo111(47) 4 years, 7 months ago

Provides solutions to a frustrating issue: GridViewCommandEventArgs doesn't expose the Row that raised the event. Say you need an itemTemplate for a link button to execute deletes.; how do you get a reference to the correct row? While the datagrid's DataGridCommandEventArgs exposed the row through it's Item property & e.Item.ItemIndex GridViewCommandEventArgs only three properties: CommandName, CommandArgument & CommandSource (which provides a reference to the gridview itelf). Wtf?! Solutions provided in story. read more...

add a comment |category: ASP.NET |Views: 263

tags: Gotchas GridViewCommandEventArgs TipsAndTricks ASPNET GridView another

Increase Your Productivity With Query Analyzer(sqlservercode.blogspot.com)

submitted by gavinjoyce(25.7k) 5 years, 1 month ago

Did you know that you can have CTRL + Number key combinations/shortcuts in Query Analyzer? You can set it up so that CTRL + 5 executes sp_who2 for example. I thought everyone already knew this but apparently not; I showed this to 3 coworkers yesterday and they didn't know about it. So how do you set this up? It is pretty easy, select Tools -->Customize from the toolbar. read more...

add a comment |category: Database |Views: 32

tags: QueryAnalyser TipsAndTricks SQL another

Code Better - Use String.Format(codebetter.com)

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

Poorly handled exceptions might speak volumes about someone's coding abilities, but it's string concatenation that's a sure bet to kill a programs readability (thus maintainability). Everyone knows that they should use StringBuilder's for better performance when concatenating a lot, but to improve maintainability, string.format is king! read more...

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

tags: String.Format TipsAndTricks CodeBetter another

Click on a tab to close a document window(extraview.co.uk)

submitted by hebbja(390) 5 years, 5 months ago

How to close a document window in Visual Studio with one click of the mouse. read more...

add a comment |category: Visual Studio |Views: 35

tags: TipsAndTricks another