<?xml version="1.0" encoding="UTF-8"?><!-- generator="WordPress/2.9.2" -->
<rss version="0.92">
<channel>
	<title>TechKnowSolve Blog</title>
	<link>http://www.techknowsolve.com/blog</link>
	<description>Technical Hints and Tips from TechKnowSolve.com</description>
	<lastBuildDate>Thu, 17 Jun 2010 17:33:05 +0000</lastBuildDate>
	<docs>http://backend.userland.com/rss092</docs>
	<language>en</language>
	
	<item>
		<title>DELETE button not captured by KeyPress event</title>
		<description><![CDATA[A small but important thing &#8211; if you want to capture pressing the DELETE button in a WinForms project, you&#8217;ll need to do it in the KeyDown or KeyUp event, not the KeyPress event.  As the documentation (here and here) points out, KeyPress deals mostly with character keys, and non-character keys won&#8217;t raise it.
]]></description>
		<link>http://www.techknowsolve.com/blog/?p=63</link>
			</item>
	<item>
		<title>Remove items from Visual Studio Recent Projects list</title>
		<description><![CDATA[Here are a couple handy links describing how to remove items from the Recent Projects list on the Visual Studio start page.  Basically, in versions prior to VS2010, it&#8217;s a registry hack (I&#8217;ve read that VS2010 provides a way to do this within the IDE, but I haven&#8217;t played with 2010 yet so I can&#8217;t [...]]]></description>
		<link>http://www.techknowsolve.com/blog/?p=59</link>
			</item>
	<item>
		<title>Working with winmm.dll to play audio files in .NET</title>
		<description><![CDATA[I&#8217;m working on a little utility application that will transfer audio files from a recorder to a computer drive.  Part of the functionality is to display the audio files, and let users listen to a little snippet of the audio file if they so desire.  A quick google search led me to this page containing [...]]]></description>
		<link>http://www.techknowsolve.com/blog/?p=55</link>
			</item>
	<item>
		<title>DataGridViewComboBox Column Properties</title>
		<description><![CDATA[I am copying this verbatim from a post I found by Kevin Spencer which is the clearest explanation I have seen of the main properties of a DataGridViewComboBox.  It&#8217;s here for my reference.  Yay if it helps you too!
The DataGridView itself has a DataSource property that determines what columns are in it. The [...]]]></description>
		<link>http://www.techknowsolve.com/blog/?p=45</link>
			</item>
	<item>
		<title>System.Data.OleDb.OleDbException: Unspecified error</title>
		<description><![CDATA[I ran across this error in an ASP.NET project that was using ADO.NET to access the data in a .csv file (more info here). After much gnashing of teeth, I finally ran across this blog post, that explained the problem and provided a link to this MSDN article.
Basically, you need to make sure that the [...]]]></description>
		<link>http://www.techknowsolve.com/blog/?p=16</link>
			</item>
	<item>
		<title>How to Query SQL Server Role Members</title>
		<description><![CDATA[You can use SQL Server Database Roles to control access to various parts of your application.  Let&#8217;s say I have created a .NET application.  I have a menu called Administration and I only want certain users to be able to see the menu.  One way to do this is to use Active [...]]]></description>
		<link>http://www.techknowsolve.com/blog/?p=39</link>
			</item>
	<item>
		<title>Use HttpModule to turn tracing on via the querystring</title>
		<description><![CDATA[Sometimes I want to turn tracing on in a production application to troubleshoot issues that I can&#8217;t replicate on my development machine.  It&#8217;s easy enough to do this by turning on application-level tracing in the web.config file, like so:
&#60;configuration&#62;
 &#60;system.web&#62;
  &#60;trace enabled=&#8221;true&#8221; pageOutput=&#8221;true&#8221; /&#62;
 &#60;/system.web&#62;
&#60;/configuration&#62;
The problem with this is that changes to the web.config file cause the app domain to [...]]]></description>
		<link>http://www.techknowsolve.com/blog/?p=37</link>
			</item>
	<item>
		<title>Ordinal Numbers in T-SQL</title>
		<description><![CDATA[I wanted to write a query that took numbers and turned them into ordinal numbers – re: 1 = 1st, 2 = 2nd, 3 = 3rd, etc.
I took this code from Chip Pearson&#8217;s web site. His posting was about ordinal numbers in Excel. I converted the code to a T-SQL function, and I can now [...]]]></description>
		<link>http://www.techknowsolve.com/blog/?p=36</link>
			</item>
	<item>
		<title>Using &#8220;Execute As&#8221; to Test a Stored Procedure as a Different User</title>
		<description><![CDATA[In an earlier blog post, I wrote about how to use “Execute As” in a stored procedure to access a separate database. When you include “Execute As” in a stored procedure, you can pull data from a separate database without giving your users direct permissions on that database.
Another way I really like to use “Execute [...]]]></description>
		<link>http://www.techknowsolve.com/blog/?p=34</link>
			</item>
	<item>
		<title>Simple way to renumber records in SQL Server</title>
		<description><![CDATA[Recently I needed to renumber a column in a database.  Specifically, I needed to be able to take a Report Number series that started with 1 (1, 2, 3, 4) and change the start number and renumber all subsequent Report Numbers (e.g, change above to 14, 15, 16, 17).
I thought I&#8217;d probably be able to [...]]]></description>
		<link>http://www.techknowsolve.com/blog/?p=29</link>
			</item>
</channel>
</rss>
