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.

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 27, 2009
James Skemp

The following article will contain spoilers of Ayn Rand's The Fountainhead. If you wish to read the book without my bias, do so before reading this article. As with the previous parts, it seems that Ayn Rand has written the final part of The Fountainhead with two people as the focus of the part. Howard Roark is associated with this part, but Gail Wynand is obviously the secondary character. Yet, Ellsworth's speech to Keating, which gives us a glimpse into what Ayn Rand fears, clarifies his character for us.

May 25, 2009
James Skemp

The following article will contain spoilers of Ayn Rand's The Fountainhead. If you wish to read the book without my bias, do so before reading this article. Having finished Part 3 of The Fountainhead in less than a day, the whole should be fairly fresh in my memory. Yet, I have a hard time putting a second name to this part, to go along with Gail Wynand's, and as I did for my thoughts on part 2.

May 24, 2009
James Skemp

In part 1 of this series I wrote about the first part of Ayn Rand's The Fountainhead. Having now finished part 2, I can write on it. The following will contain spoilers. I highly recommend you do not continue if you wish to read The Fountainhead with fresh eyes. The second part of The Fountainhead is devoted to Ellsworth M. Toohey, as the subtitle suggests. This further introduces a character we had met in part one, but gives us the chance to get to know him further.

May 19, 2009
James Skemp

I've known of Ayn Rand for quite a number of years. The first time I can remember her being talked about was by a fellow philosophy student, approximately one year ahead of me, who was a rather big fan of her work. At least one professor got into arguments with this student, as she'd bring up Rand's approach. In 2002 and 2003 I read We the Living and Anthem, and enjoyed them well enough.

May 16, 2009
James Skemp

To a very large extent, I consider myself to be a gamer. Around the time the NES came out, my family picked up an Atari 2600, used. I don't know who sold it to us, but I can remember going with my dad to pick it up at my school's playground (that was the meeting place). At a later point we picked up an NES, via my dad, and then my mom bought us a SNES.

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.

May 14, 2009
James Skemp

I don't really believe in making New Year's resolutions, since it's something people do, knowing that they're going to fail at. In my opinion. So, for my 28th, I'm doing something a little different, in that I'm declaring that I will continue to do what I've been doing, for a couple of key items. No more soda I've been off soda for a couple of months, and before that I was down to just one-ish a day.

May 3, 2009
James Skemp

I back-dated my first piece of jQuery code, but have decided not to with my second. Anyways, I had a hard time finding code, written in jQuery, to pull data from an Xml file and add it to a page. Combining a couple of tutorials online, I created the following (on April 27). This was for a message, so I started out with the Xml file, creating something like this:

Newer

Older

Search

Links of Note

Support This Site

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

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

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

Thoughts on Ayn Rand's The Fountainhead: Part 4

Thoughts on Ayn Rand's The Fountainhead: Part 3

Thoughts on Ayn Rand's The Fountainhead: Part 2

Thoughts on Ayn Rand's The Fountainhead: Part 1

On Achievements and Trophies

iTunes Playlists to Xml - version 1.1 released

Resolutions - 28

jQuery: Query an Xml document and output data

Search

Links of Note

Recent Posts

categories

Support This Site