Database

DECLARE @iColumns INT, @sql VARCHAR(2500),@cInstruction VARCHAR(50), @nInstruction int 

SET @sql = ''

DECLARE curInstructions CURSOR FOR SELECT DISTINCT InstructionDesc,InstructionID FROM TB_InstructionMaster
OPEN curInstructions
FETCH NEXT FROM curInstructions INTO @cInstruction,@nInstruction
WHILE @@FETCH_STATUS = 0
BEGIN
	SET @sql = @sql + ', (SELECT ''' + @cInstruction + ''' as fld 
                              FROM TB_ProductInstruction P2 
                              WHERE P2.ProductID = ProdInst.ProductID and InstructionID = ''' + 
                                    cast(@nInstruction as varchar) + ''') as [' + @cInstruction + ']'
	FETCH NEXT FROM curInstructions INTO @cInstruction,@nInstruction
END

close  curInstructions
DEALLOCATE curInstructions

SET @sql =  'SELECT distinct ProdMast.ProductID ' + @sql + ' 
FROM TB_ProductInstruction ProdInst 
right join tb_productmaster ProdMast on ProdInst.ProductID = ProdMast.ProductID'
exec(@sql)

select * from train 
LEFT OUTER JOIN trainarrivals ta1 ON train.PreviousArrival = ta1.UniqueID
LEFT OUTER JOIN trainarrivals ta2 ON train.NextArrival = ta2.UniqueID
ORDER BY train.UniqueID

if(myDataTable.Rows[row][col].ToString() == "")<br />
{<br />
....