C#

<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 />

ConnectionOptions options = new ConnectionOptions();

          ManagementScope scope = new ManagementScope("\\\\" + sRemoteMachine + "\\root\\cimv2", options);
          scope.Connect();
          ManagementPath mp = new ManagementPath("Win32_Product");

          ManagementClass classInstance = new ManagementClass(scope, mp, null);

          // Obtain in-parameters for the method

          ManagementBaseObject inParams =  classInstance.GetMethodParameters("Install");

           inParams["AllUsers"] = true;
          //inParams["Options"] = installationParameters;  // problem lies here
          inParams["PackageLocation"] = sourceFilePath ;  //source file must be on the remote machine


          // Execute the method and obtain the return values.

          ManagementBaseObject outParams =  classInstance.InvokeMethod("Install", inParams, null);

System.IO.FileStream stream = new System.IO.FileStream(FileDir.Text, System.IO.FileMode.Open, System.IO.FileAccess.Read);<br />
// Create a buffer to hold the stream bytes<br />
byte[] buffer = new byte[stream.Length];<br />
// Read the bytes from this stream<br />
stream.Read(buffer, 0, (int)stream.Length);<br />
// Now we can close the stream<br />
stream.Close();<br />
InsertImage(ref buffer);<br />
buffer = null;