I am trying to use a Decode Query to define a DataTable method which looks like this: SELECT CDTS, '', '', '', LOC, NULL, DECODE(DTYPE, 'L', CONCAT(CONCAT(CONCAT('***** LOI MATCH:', LOI_DATA.NUM_1), ' ADDRESS: '), LOI_DATA.LOC), 'D', CONCAT('CLETS...
Posted to
Data Access and ObjectDataSource Control
(Forum)
by
Chabo
on
05-22-2007, 12:00 AM
Filed under: outputparameter, Paramter, Performance : Stored Procedure with many params, Table Adapter, TableAdapter, TableAdapters, ADO.NET, ASP.NET, Asp.Net 2.0, DAL, Data, data Acces, Data Access, Data Access connections, data connections, data set, DataAdapter, Database, databind, DataGrid GridView Paging, DataSet, DataSource, Select, SQL Server ADO.NET Transactions