super-cooper

Are you kidding me? I’m a major amatuer at anything .NET, and after some Googling and about 15 minutes of coding, this works. How ridiculously easy.

1. using System;
2. using System.Collections.Generic;
3. using System.Text;
4. using System.Data;
5. using System.Data.SqlClient;
6.  
7. namespace ExecuteStoredProcedure
8. {
9. class Program
10. {
11. static void Main(string[] args)
12. {
13. SqlConnection conn;
14. try
15. {
16. conn = new SqlConnection("server=server;database=db;Trusted_Connection=yes");
17. conn.Open();
18. Console.WriteLine("Connection successful…");
19. }
20. catch (Exception ex)
21. {
22. Console.WriteLine(ex.Message);
23. return;
24. }
25.  
26. SqlCommand db_cmd = new SqlCommand("dbo.usp_c_sharp_test",conn);
27. db_cmd.CommandType = CommandType.StoredProcedure;
28.  
29. SqlDataReader data_reader;
30. data_reader = db_cmd.ExecuteReader();
31. data_reader.Close();
32. conn.Close();
33. }
34. }
35. }
36. Download this code: execute-stored-procedure.cs

Tags: c#, sqlserver

My (hopefully first of many) article on GIS and Python has been published in the Spring 2008 edition of ESRI’s ArcUser magazine. You can get the pdf here , and the code listings here .

Tags: gis, publications, python

I finally got around to getting a Subversion repository setup, so the latest development version of my flickuploadr.py can be checked out:

svn co http://svn.super-cooper.com/flickruploadr/trunk

or you can just get it at:

http://svn.super-cooper.com/flickruploadr/trunk

Tags: flickr, photography, python

I just turned the corner from the kitchen to the dining room, and met up with our three year old son, and he hit me with this:

Son:

There was a booger in my nose.

Me:

And…what did you do with it?

Son:

I ate it.

Oh, the brutal honesty that is childhood.

Tags: boys, conversation