VB.ET及C# 程式碼轉換
推薦此網站:
http://labs.developerfusion.co.uk/

janema66 發表在 痞客邦 留言(0) 人氣()

語言: Transact-SQL
功能: 字串空白補零
語法:
DECLARE @strNo varchar(4)
SET @strNo = CAST(12 as varchar(4))
SET @strNo = REPLICATE('0',4-LEN(@strNo))+@strNo
print @strNo

結果:0012

janema66 發表在 痞客邦 留言(0) 人氣()

語言: C#
功能: FTP下載檔案
語法:

        public static StreamReader FtpDownLoad(Uri UriFpt, string strUserName, string strPassword)
        {
            FtpWebRequest request = (FtpWebRequest)WebRequest.Create(UriFpt);
            request.Method = WebRequestMethods.Ftp.DownloadFile;

            request.Credentials = new NetworkCredential(strUserName, strPassword);
            FtpWebResponse response = (FtpWebResponse)request.GetResponse();
            Stream responseStream = response.GetResponseStream();
            StreamReader reader = new StreamReader(responseStream, Encoding.Default);
            return reader;
        }


呼叫時
 Uri  UriFtp = new Uri ("ftp:// ip / filename ")
string  strUserName = "username";
string  strPassword = "password";

StreamReader reader =  FtpDownLoad(UriFtp, strUserName, strPassword);
   while (reader.Peek() >= 0)
    {
           StringBuilder s = new StringBuilder();
           s.Append(reader.ReadLine());
           
   }
 reader.Close();

janema66 發表在 痞客邦 留言(0) 人氣()