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:

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.

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.

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.

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.

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 ...

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. At this point, I only allow 100 payments to be returned, just in case .

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.

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.

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.

Newer

Older

Search

Links of Note

Support This Site

If my blog was helpful to you, then please consider visiting my Amazon Wishlist.

Programmatic SQL command timeout using a SqlDataSource (C#)

iTunes Playlists to Xml - version 1.2 released

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

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

iTunes Playlists to Xml - version 1.1 released

iTunes Playlists to Xml - version 1.0 released

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

iTunes Playlists to Xml - version 0.6b released

Configuration files for Windows Forms Applications

iTunes Playlists to Xml - version 0.4b released

Search

Links of Note

Recent Posts

categories

Support This Site