Programmatic SQL command timeout using a SqlDataSource (C#)

  • June 24, 2009
  • James Skemp
Granted, in the case where this came up, I should have moved away from a SqlDataSource, but I wrote it using one, and a re-write isn't possible at the moment. So, I had to find a way yesterday to programmatically set the command timeout of a select, using a SqlDataSource (that was programmatically written). After much research, I found that you have to set the timeout on selecting. After opening a dummy document to see if I could determine how it was normally done, I came up with something like the following:

Read More

iTunes Playlists to Xml - version 1.2 released

  • June 13, 2009
  • James Skemp
This application has since been updated. Read about the current version of iTunes Playlists to Xml. Version 1.2 of iTunes Playlists to Xml is now ready for download. Download iTunes Playlists to Xml version 1.2. This update should correct issues when the playlists are changed, as well as when the source is ejected. Instead of immediately connecting to iTunes, the application now allows (and requires) that you manually begin that process.

Read More

Programmatic MSSQL data source in ASP.NET (C#) without System.Web

  • June 6, 2009
  • James Skemp
In a similar article I detailed how I was doing programmatic access of Microsoft SQL Server. However, on another project I was creating a class in App_Code. Using my method required the use of a couple additional namespaces from System.Web. That seemed a bit excessive. So I did some digging around and came up with what I believe is a better solution, for use in classes/non-Web code. First, the following must be included in.

Read More

Programmatic MSSQL data source in ASP.NET (C#)

  • June 1, 2009
  • James Skemp
I keep having to search through code to find it, so, since writing about it makes it easier for me to find ... here's how I've been programmatically making calls to Microsoft SQL Server. If I'm doing something wrong, please comment below or send me an email. Some times have been changed to dummy values. SqlDataSource dataSource = new SqlDataSource(); dataSource.ConnectionString = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString; dataSource.SelectCommand = "stored_proc"; dataSource.SelectCommandType = SqlDataSourceCommandType.StoredProcedure; dataSource.SelectParameters.Add("id", value); dataSource.

Read More

iTunes Playlists to Xml - version 1.1 released

  • May 15, 2009
  • James Skemp
This application has since been updated. Read about the current version of iTunes Playlists to Xml. Update: Version 1.1.1 is available for download, which corrects the progress bar bug, noted in the comments below. To upgrade, simply replace your executable with the one in the above zip file. Version 1.1 of iTunes Playlists to Xml has been released. Download iTunes Playlists to Xml version 1.1. This update now appends the saved xml file with the current date and time, for ease.

Read More

iTunes Playlists to Xml - version 1.0 released

  • March 29, 2009
  • James Skemp
This application has since been updated. Read about the current version of iTunes Playlists to Xml. Version 1.0 of iTunes Playlists to Xml has been released. Download iTunes Playlists to Xml version 1.0. Unlike the previous versions, this includes an installer (setup.exe in the zip file). Comments/suggestions welcome. New program icon will, naturally, be accepted; I know mine isn't very good, but ...

Read More

Test application in ASP.NET (C#): Amortization schedule

  • March 16, 2009
  • James Skemp
Having used a number of amortization schedule generators this past weekend, I thought I could do better. It's still in-progress, but after (exactly) 2 hours of work, it functions. View the Amortization schedule generator. Developed in ASP.NET C#, with a limited amount of JS. Unlike the site I crashed this weekend, this should tell you if you attempt to pay less per month than you owe in interest.

Read More

iTunes Playlists to Xml - version 0.6b released

  • March 5, 2009
  • James Skemp
This application has since been updated. Read about the current version of iTunes Playlists to Xml. iTunes Playlists to Xml, version 0.6b, is now available for download. Download iTunes Playlists to Xml - version 0.6b. This version now handles the bug where playlists could be out of date, by alerting the user. This version also includes functionality to save the Xml file, as well as configure the name the application will use when generating the Xml file.

Read More

Configuration files for Windows Forms Applications

  • March 5, 2009
  • James Skemp
Since I know I'll run across this again ... In my iTunes Playlists to Xml application I wanted to allow users the ability to persist their name across sessions. The supported method seems to be using application configuration files; in my case, something like iTunesApplication.exe.config. However, try as I could, I just couldn't find anything solid on how to create the configuration file. First, I had to add a reference to "System.

Read More

iTunes Playlists to Xml - version 0.4b released

  • March 2, 2009
  • James Skemp
This application has since been updated. Read about the current version of iTunes Playlists to Xml. Having just released version 0.3b of iTunes Playlists to Xml, I've got yet another release. This release includes menus, the ability to select what data you want in the Xml, and a schema for validation. Unfortunately, I've discovered one bug (that would have existed before) with playlists getting updated in iTunes, between the refresh in this application, and the time it was clicked on.

Read More