Use iif construct for creating new column in datatable

Tuesday, 31 January 2012 09:49
good-systemtypegettypesystemstringiifcustomertotal1000-customer-bad-customer
IF construct in expression while adding new column to datatable


mydatatable.Columns.Add("CustomerTypeBasedOnExpenditure", System.Type.GetType("System.String"),"IIF(customertotal>1000, 'Good customer', 'Bad Customer')" );

Read more: http://feeds.dzone.com/~r/dzone/snippets/~3/c7WxjRQoRkY/14589

Scroll To Top