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