C#

	StreamReader   reader = new StreamReader("Some Path");			<br />
	StreamWriter   writer = new StreamWriter( "Some Path", false );<br />
        string line;<br />
<br />
        while ( (line = reader.ReadLine()) != null )<br />
        {<br />
             if(some condition)<br />
             {<br />
               throw new ApplicationException("Unrecognised File Format");<br />
             }<br />
             .....<br />
             .....some more "if" conditions..<br />
<br />
             writer.WriteLine( "\n    {0} = {1},",  sometext, somevalue);<br />
        }<br />
        writer.Close();<br />
	reader.Close();

<br />
CREATE VIEW titles_view<br />
AS<br />
select A.transID,A.Machine,Qlityno,batchnno,b.BTDes,color,startime,endtime,Cast((datediff(n,startime,endtime)-<br />
(SELECT ISNULL(SUM(DATEDIFF( n , TStoptime , Restarttime )),0)<br />
FROM FINTransTempstops B<br />
WHERE B.tranid = A.transid and B.TStoptime is not null))as integer)  as cf_TimeTook,exp_weight,actual_meters,specspeed,isrefish,next_process<br />
from finbatchinfo A left join FINTransTempstops c on A.transID = c.TranID <br />
left join FINBatchType B on A.BTID = B.BTID<br />
where endtime is not null --and startime >=convert(datetime,'2006-08-21',121) and<br />
--startime <= convert(datetime,'2006-08-31',121)<br />
group by A.transID,A.Machine,Qlityno,batchnno,b.BTDes,color,startime,endtime,exp_weight,actual_meters,specspeed,isrefish,next_process<br />
--order by A.machine<br />
GO<br />