 |
Select Column Information using SQL Server
Dave Howard (31344 views)
Select Column Information using SQL Server
#$#<a href="http://www.dotnetkicks.com/kick/?url=http://www.geekzilla.co.uk/ViewF3E9658C-7B7A-472C-BE4A-5C25CD26C0E8.htm"><img src="http://www.dotnetkicks.com/Services/Images/KickItImageGenerator.ashx?url=http://www.geekzilla.co.uk/ViewF3E9658C-7B7A-472C
|
 |
Authenticated HTTPRequests (Using Credentials)
Dave Howard (17762 views)
Authenticated HTTPRequests (Using Credentials)
#$#<a href="http://www.dotnetkicks.com/kick/?url=http://www.geekzilla.co.uk/ViewC5E6201A-DFC1-4091-8145-5A893504C0E4.htm"><img src="http://www.dotnetkicks.com/Services/Images/KickItImageGenerator.ashx?url=http://www.geekzilla.co.uk/ViewC5E6201A-DFC1-
|
 |
T-SQL script automatically adds auditing to a table
Dave Howard (14573 views)
T-SQL script automatically adds auditing to a table
#$#<a href="http://www.dotnetkicks.com/kick/?url=http://www.geekzilla.co.uk/ViewECBC0CC3-1C7E-4E7E-B243-F2F259A5C920.htm"><img src="http://www.dotnetkicks.com/Services/Images/KickItImageGenerator.ashx?url=http://www.geekzilla.co.uk/ViewECBC0CC3-
|
 |
Return new identity from Strongly Typed Dataset DataTable.Insert method
Dave Howard (14434 views)
Return new identity from Strongly Typed Dataset DataTable.Insert method
#$#<a href="http://www.dotnetkicks.com/kick/?url=http://www.geekzilla.co.uk/ViewF2737CEE-4FCE-4215-B8CA-74D77EF64A5F.htm"><img src="http://www.dotnetkicks.com/Services/Images/KickItImageGenerator.ashx?url=http://www.geekzil
|
 |
Why we use C# for .NET development
Dave Howard (11431 views)
Why we use C# for .NET development
#$#<a href="http://www.dotnetkicks.com/kick/?url=http://www.geekzilla.co.uk/View026313AC-108F-4EA1-90A2-5E5BE0DEE0F2.htm"><img src="http://www.dotnetkicks.com/Services/Images/KickItImageGenerator.ashx?url=http://www.geekzilla.co.uk/View026313AC-108F-4EA1-90A2-5E
|
 |
Enabling Agent XPs on a new SQL Server 2005 install
Dave Howard (9852 views)
Enabling Agent XPs on a new SQL Server 2005 install
I had to do this prior to creating a maintainence plan for a database on my development box.
When i first tried to create the plan I was given a message that Agent XPs are not enabled and that I should run sp_reconfigure.
Run this state
|
 |
Garmin and Google Maps
Dave Howard (9332 views)
Garmin and Google Maps
The bought a Garmin Forerunner recently which is a really cool piece of kit but the maps that come with it are very poor.
Google maps has an API that allows you to integrate these rich maps into your own web applications.
Garmin has the option to export your traini
|
 |
Using Enum.Parse()
Dave Howard (9255 views)
Using Enum.Parse()
#$#<a href="http://www.dotnetkicks.com/kick/?url=http://www.geekzilla.co.uk/View3C1F25C4-1681-44D6-A34C-133ECC79FA24.htm"><img src="http://www.dotnetkicks.com/Services/Images/KickItImageGenerator.ashx?url=http://www.geekzilla.co.uk/View3C1F25C4-1681-44D6-A34C-133ECC79FA24.htm
|
 |
Bug in VS2005? Using Typed DataSets with SQL 2005 and stored procedures
Dave Howard (7085 views)
Bug in VS2005? Using Typed DataSets with SQL 2005 and stored procedures
#$#<a href="http://www.dotnetkicks.com/kick/?url=http://www.geekzilla.co.uk/View72C81AA0-44A5-4E2C-8903-B1EA7D7643EA.htm"><img src="http://www.dotnetkicks.com/Services/Images/KickItImageGenerator.ashx?url=http://www.geekzilla
|
 |
System tray and balloon tips
Dave Howard (6910 views)
Balloon Tips from the System Tray
You can really easily add system tray function to .NET windows forms by dragging the NotifyIcon object onto your form.
You can then use this to display balloon tips from the system tray with the code below:
#c#myNotifyIcon.ShowBalloonTip(500, "Title", "Ti
|
 |
Serializing abstract classes to XML
Dave Howard (6495 views)
Serializing abstract classes to XML
Digg it: http://digg.com/programming/Serializing_abstract_classes_to_XML_in_c
It is often useful to have abstract classes with several derived types to allow use of strongly typed lists and the such.
For example you might have a DocumentFragment class w
|
 |
Typed Masterpage reference
Dave Howard (6320 views)
Typed Masterpage reference
#$#<a href="http://www.dotnetkicks.com/kick/?url=http://www.geekzilla.co.uk/View674ECBC1-7CC3-486E-A580-E4B048E1E3D5.htm"><img src="http://www.dotnetkicks.com/Services/Images/KickItImageGenerator.ashx?url=http://www.geekzilla.co.uk/View674ECBC1-7CC3-486E-A580-E4B048E1E3
|
 |
Changing Schema for a group of objects
Dave Howard (6200 views)
Changing Schema for a group of objects
#$#<a href="http://www.dotnetkicks.com/kick/?url=http://www.geekzilla.co.uk/View4384ACEC-8C9D-452A-83F6-230FFE43C17B.htm"><img src="http://www.dotnetkicks.com/Services/Images/KickItImageGenerator.ashx?url=http://www.geekzilla.co.uk/View4384ACEC-8C9D-452A-83F
|
 |
Strongly Typed DataSets and GridViews
Dave Howard (6003 views)
Strongly Typed DataSets and GridViews
#$#<a href="http://www.dotnetkicks.com/kick/?url=http://www.geekzilla.co.uk/ViewF9581DAE-CCF8-49FF-844C-7498603E0005.htm"><img src="http://www.dotnetkicks.com/Services/Images/KickItImageGenerator.ashx?url=http://www.geekzilla.co.uk/ViewF9581DAE-CCF8-49FF-84
|
 |
Auto-complete using ATLAS
Dave Howard (5850 views)
Auto-complete using ATLAS
#$#<a href="http://www.dotnetkicks.com/kick/?url=http://www.geekzilla.co.uk/View7585D539-C094-4211-9FFC-32FABE4D09B5.htm"><img src="http://www.dotnetkicks.com/Services/Images/KickItImageGenerator.ashx?url=http://www.geekzilla.co.uk/View7585D539-C094-4211-9FFC-32FABE4D09B
|
 |
Updating Foreign keys in a GridView
Dave Howard (5428 views)
Updating Foreign keys in a GridView
#$#<a href="http://www.dotnetkicks.com/kick/?url=http://www.geekzilla.co.uk/ViewD7E7F40C-85F7-47D8-89DE-0FB5F7AFAAE5.htm"><img src="http://www.dotnetkicks.com/Services/Images/KickItImageGenerator.ashx?url=http://www.geekzilla.co.uk/ViewD7E7F40C-85F7-47D8-89DE
|
 |
Lightweight Ajax
Dave Howard (5303 views)
Lightweight Ajax
#$#<a href="http://www.dotnetkicks.com/kick/?url=http://www.geekzilla.co.uk/ViewC77497B2-2CD6-4FBC-968C-93AFF2F397EB.htm"><img src="http://www.dotnetkicks.com/Services/Images/KickItImageGenerator.ashx?url=http://www.geekzilla.co.uk/ViewC77497B2-2CD6-4FBC-968C-93AFF2F397EB.htm" bo
|
 |
Web service calls from javascript using ATLAS (part 2) - Complex return types
Dave Howard (4864 views)
Web service calls from javascript using ATLAS (part 2) - Complex return types
#$#<a href="http://www.dotnetkicks.com/kick/?url=http://www.geekzilla.co.uk/ViewF266ADEB-8F62-4E92-8036-1D2436C2DE3A.htm"><img src="http://www.dotnetkicks.com/Services/Images/KickItImageGenerator.ashx?url=http://www.g
|
 |
XMLHTTPRequest in Stored Procedure
Dave Howard (4722 views)
XMLHTTPRequest in Stored Procedure
I recently had a requirement to call a webservice from a stored procedure. I looked into doing this by writing a CLR assembly in SQL 2005.
There were a few articles online describing this but working in a large organisation I knew that getting the thing wor
|
 |
Strongly Typed Dataset doesn't always auto generate DELETE and UPDATE stored procedures
Dave Howard (4026 views)
Strongly Typed Dataset doesn't always auto generate DELETE and UPDATE stored procedures
I found this problem whilst creating a STD that included a many to many relationship between two tables.
I created a table consisting of the two foreign keys and appropriate constraints to support the rel
|
 |
Encoding string to Base64 / UTF8
Dave Howard (3940 views)
Encoding string to Base64 / UTF8
Sometimes you need to convert strings to Base64, for example in security components. The function below does this:
#c#public string stringToBase64(string s)
#c#{
#c# try
#c# {
#c# byte[] bytes = new byte[s.Length];
#c# bytes = Syste
|
 |
Web service calls from javascript using ATLAS (part 1)
Dave Howard (3879 views)
Web service calls from javascript using ATLAS (part 1)
#$#<a href="http://www.dotnetkicks.com/kick/?url=http://www.geekzilla.co.uk/View91E6FCCB-DB0A-499C-A2CC-9854452D2086.htm"><img src="http://www.dotnetkicks.com/Services/Images/KickItImageGenerator.ashx?url=http://www.geekzilla.co.uk/View91E6FC
|
 |
Handling hierachical structures in SQL
Dave Howard (3563 views)
Handling hierachical structures in SQL
#$#<a href="http://www.dotnetkicks.com/kick/?url=http://www.geekzilla.co.uk/View96264E4E-52EE-42BD-9494-2F33947A9063.htm"><img src="http://www.dotnetkicks.com/Services/Images/KickItImageGenerator.ashx?url=http://www.geekzilla.co.uk/View96264E4E-52EE-42BD-9
|
 |
Extending Strongly Typed Datasets
Dave Howard (3400 views)
Extending Strongly Typed Datasets
Strongly Typed Datasets are a rather nice addition to VS2005 (they don't lend themselves well to acronyms however)
You still need to create a database and tables and realationships but using STDs saves a writing huge amount of code.
If this code were gene
|
 |
Web service calls from javascript using ATLAS (part 3) - Complex properties
Dave Howard (3343 views)
Web service calls from javascript using ATLAS (part 3) - Complex properties
#$#<a href="http://www.dotnetkicks.com/kick/?url=http://www.geekzilla.co.uk/View7DA902AA-513E-48D2-AD02-0F1A1946A999.htm"><img src="http://www.dotnetkicks.com/Services/Images/KickItImageGenerator.ashx?url=http://www.gee
|
 |
Updating controls from another thread
Dave Howard (2757 views)
Updating form controls from another thread.
Form controls, by default, can only be updated by the forms thread. Otherwise an invoke must be used.
The example below shows a simple logging function that can be called by threads other than the forms.
#c#delegate void LogSafeCall(string s);
|
 |
Json converters lacking in Microsoft AJAX RTM
Dave Howard (2458 views)
Json converters lacking in Microsoft AJAX RTM
Having spent some time developing a project using a CTP version of Microsoft Ajax ("ATLAS" back in the day) I finally came to migrate the project to the RTM version.
After uninstalling the CTP release, and installing the RTM release I wasn't sur
|
 |
How to add a Digg This counter to your article
Dave Howard (1156 views)
How to add a Digg This counter to your article
#$#<script>
#$#digg_url = 'http://digg.com/programming/How_to_add_a_Digg_This_link_to_your_web_site';
#$#</script>
#$#<script src="http://digg.com/api/diggthis.js"></script>
Simply by adding the HTML below to this page...
#h#<script>
#h#digg_ur
|
 |
Should I use C# or VB .Net?
Dave Howard (630 views)
Should I use C# or VB .Net?
What a conundrum, each developer has their favourite. In this article I will try to document the pro's and con's, or at least the differences of each language.
I will admit that I am a C# developer but I will try to keep this unbiased.
||||'''VB'''||'''C#'''||
|
 |
Presenting Leading Zeroes in a Query
Dave Howard (478 views)
Presenting Leading Zeroes in a Query
This little tip came in handy for me when sorting objects by their position within a tree structure.
If you build up a string such as 0.0.1.0 representing the nodes position within a tree structure then sorting will result in an ascii sort where 0.0.10.0
|