I had a large number of XML files that each contained hourly prices for a lot of different locations. I needed to get all of the prices for a single location. I did this by loading all of the files into a table and then querying the table. First, I needed to change the rights […]
Uploading XML Files to SQL Server Read More »
I needed to display some parent data with its child data on the same row as shown in the image above. I happen to be combining a few tables together into a new table (called dtPlan) and then binding the GridView to that new table. So this was my approach while moving the data into
Grid within a GridView Cell Read More »
In the past we would use a Varchar to pass a comma delimited list of IDs to a stored proc. We would then build a big varchar string of the full SQL and run the dynamic SQL. Starting with SQL Server 2005 you can pass the stored proc XML and do your select without using
Passing IDs to Stored Procs Using XML Read More »
Not many developers realize that you can change a plain HTML object’s attributes in the code behind without having to convert it into an ASP.NET control. So if I have a checkbox like this: Copy Text Copied Use a different Browser <input type="checkbox" id="cbShowDef" name="cbShowDef" onclick="javascript: show()" /> I can hide this in the code
Changing HTML Attributes on ASP.NET Pages in the Code Behind Read More »
A lot of times, you have something like a description column and you want to display it in a GridView. But since for some of the rows the description column can be very long, it doesn’t always work very well. One solution is where you set the TD’s attribute NOWRAP, then the column runs off
Displaying a Long Description Column in a GridView Read More »
I have a page where the user can select which users are active (using check boxes), and also select one (only one) to be the administrator. I put together this sample to show how I did it. The sample uses technologies instead of the user. The picture below gives you an idea. I didn’t want
Select One Row From a GridView Read More »
The question came up asking how to change something in a GridView row based on something else in that row without doing a postback. So I created a simple example where if you check a CheckBox, then another column in that row would have its background color changed. I did this in a generic way
How to Work With a GridView Row in JavaScript Read More »
One of our applications features a page where users can report bugs. We wanted to allow them to “attach” one or more files to the bug record. The files could be screenshots, spreadsheets, etc. So the bug entry page would have the normal data entry part and have the following box at the bottom of
Attaching upload files to a record. Read More »
Another way to store your connection string in a way that it doesn’t get in the way when you promote your web site from Test to QA to Prod is the following: Have your web site under a given directory, say d:\WebSites\MyWebsite. And you also have another directory to hold your connection strings that isn’t
Another Place to Put the Connection String Read More »
Our experience with the Visual Source Safe to Subversion conversion. BACKGROUND Visual Source Safe In general Visual Source Safe is known to have problems when the database gets large, if there are a lot of users, or if it is used over a network. On Microsoft’s site they have the following warnings: (http://support.microsoft.com/kb/q133054/) Many factors
Visual Source Safe to Subversion Conversion Read More »
