Development – Page 3 – The Moore Dynasty

LINQ and a Multi-column Join Problem

by Marc MooreJuly 7, 2010December 18, 20140

What causes the following LINQ query to generate a "The type of one of the expressions in the join clause is incorrect. Type inference failed in the call to ‘Join’" error? from doc in BvdDoc join job in BvdJob on doc.BvdDocID equals job.BvdDocID join iter in BvdIteration on job.BvdJobID equals …

SQL Temp Table, Nested Proc Calls

by Marc MooreSeptember 26, 2008December 18, 20140

CREATE PROCEDURE [dbo].[marctest2] AS SET NOCOUNT ON INSERT INTO #marc VALUES (4, ‘Test 4’) INSERT INTO #marc VALUES (5, ‘Test 5’) INSERT INTO #marc VALUES (6, ‘Test 6’) GO CREATE PROCEDURE [dbo].[marctest1] AS SET NOCOUNT ON CREATE TABLE #marc ( id int, data varchar(10) ) INSERT INTO #marc …

Binding DropDownList in an Editable GridView

by Marc MooreMarch 13, 2006December 18, 20140

The .NET 2.0 GridView control works much like the old DataGrid in .NET 1.1, but giving in to the tempation of the ObjectDataSource and its ability to automatically bind your list controls can lead to trouble in non-trivial situations. For example, take an editable GridView with a DropDownList control in …

ASP.NET 2.0 Namespace Issues

by Marc MooreJanuary 31, 2006December 18, 20140

A nifty feature of ASP.NET 2.0 is the ability to store all of your application’s code in the App_Code folder and automatically have it be compiled into one big, happy namespace. Most of the time this works well; however, when you’re doing a forms authentication-based application and are: A) too …