Unidev .NET Technology Blog

Selecting An Old Value While Binding a DropDownList

Kevin — Wed, 14 Jul 2010 21:18:50 +0000

I had a usual instance where a DropDownList was bound to a table in a database. However, that list of data could change in the database without regard to those values having been previously stored (as text, not IDs, unfortunately) in another table. Meaning that when the DropDownList would now be loaded with the newly [...]

Dynamically Loading External Controls from a DropDownList

Kevin — Mon, 12 Apr 2010 14:24:15 +0000

Displaying a specific web user control (.ascx) from a dropdown selection is a fairly straightforward process. Create an asp:DropDownList with OnSelectedIndexChanged set to a function. This function will load a user control file based on the selected value of the dropdown. Also, create an asp:PlaceHolder where the control will be placed. <asp:DropDownList ID=”ddDataTables” runat=”server” AutoPostBack=”true” OnSelectedIndexChanged=”ddDataTables_Changed” > [...]

Triggering a Specific GridView Row Command When Page Loads

Kevin — Thu, 11 Feb 2010 15:14:12 +0000

I have an asp.net page with a gridview and each row uses a TemplateField to make a LinkButton to select the row. In my case, the action of clicking the text link triggers a FormView to appear in order to edit the data. I needed a way to open the editing form automatically for the first [...]

Display a Nested List Inside Another Repeater

Kevin — Wed, 13 Jan 2010 22:28:27 +0000

A simple way to display a list of data is to use an asp:Repeater. If the data also needs to show a nested list of related data for each main item, one can place another Repeater inside the first. In the code behind, the queries used for each Repeater can be linked in a dataset as a [...]

Article Series and Planned Topics

Allan — Tue, 15 Dec 2009 14:32:36 +0000

by Allan Sieker When it comes time to write an interesting article about a technical topic my mind goes into a deadlock in trying to find the balance between space/time constraints and keeping the content interesting. Too short of an article and it seems trivial because the technical stuff doesn’t get covered enough. Too technical, and [...]

Importing Mixed ZIP Codes into SQL Server from Excel

Kevin — Thu, 29 Oct 2009 16:51:07 +0000

I had a spreadsheet with tens of thousands of mailing addresses. One of the columns was the ZIP code for each address row. Some of those ZIP codes were in the ZIP + 4 format (12345-6789) and others were not. Those others were 3, 4 or 5 digit numbers. When the data was put into [...]

Using A Data Container Column as an Inline IF Condition

Kevin — Thu, 01 Oct 2009 19:02:51 +0000

I find myself using .net data containers in many web applications. Binding controls such as asp:Repeater and asp:DataList to data sources can make displaying your data more manageable. In a few of those instances I need to have some of the data display in a little different manner depending on that particular info. For example, a [...]

Before You Start Increasing the CommandTimeout Value…

Allan — Thu, 03 Sep 2009 21:51:49 +0000

by Allan Sieker Just recently I had the opportunity to investigate a timeout error happening on an ASP.NET web application of a new client. This web application is a very intense and complex business solution involving tiered hierarchies of entities for companies, resources, processes, and projects. Definitely not your typical web site. The source of the timeout was an embedded SQL query consisting of a [...]

Could not load file or assembly ‘apache fop.net’ or one of its dependencies

George — Tue, 04 Aug 2009 13:31:22 +0000

By George Zheng When we deploy one of our web sites to a 64 bit web server, we get following error: “Could not load file or assembly ‘apachefop.net’ or one of its dependencies. An attempt was made to load a program with an incorrect format.” This web site is using fop.net to generate the PDF for [...]

Process XML in C#.net

George — Tue, 14 Jul 2009 14:57:13 +0000

By George Zheng XML has been used in a lot of places for transferring data because of its platform independence and its simple, text-based, self-describing format. It is a common requirement for preparing and consuming XML data. Microsoft provides several convenience tools to help developers deal with XML under .NET platform. System.Xml.XmlTextReader/System.Xml.XmlTextWriter System.Xml.Serialization.XMLSerializer System.Xml.Linq XmlTextReader/XmlTextWriter XmlDocument objects are easy to use [...]