Use a DataAdapter fill a DataTable from a basic SQL statement, like this: SELECT ID, Desc, UseCode, Active, UpdateDate FROM SomeTable. The key to the flexibility and reuse of this code is the use of ...

Visual Basic or C#? I've illustrated the process of creating useful SQL Server CLR functions using Visual Basic, but functions written in C# work equally well. In fact, the code download for this ...