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: TableAdapter, TableAdapters, Select, ASP.NET, DataGrid GridView Paging, DataSet, SQL Server ADO.NET Transactions, ADO.NET, Performance : Stored Procedure with many params, Table Adapter, DAL, Data, data Acces, Data Access, Data Access connections, Paramter, outputparameter, data connections, data set, DataAdapter, Database, databind, Asp.Net 2.0, DataSource