夏天的雙重性格

 FtpWebRequest request = (FtpWebRequest)WebRequest.Create("ftp://帳號@ftp.XXXX.com.tw/ExcelFile.xls");
            request.Method = WebRequestMethods.Ftp.UploadFile;
            // FTP的帳密.
            request.Credentials = new NetworkCredential("帳號", "密碼");
            // 要上傳的檔案
            StreamReader sourceStream = new StreamReader("ExcelFile.xls");
            byte[] fileContents = Encoding.UTF8.GetBytes(sourceStream.ReadToEnd());
            sourceStream.Close();
            request.ContentLength = fileContents.Length;
            Stream requestStream = request.GetRequestStream();
            requestStream.Write(fileContents, 0, fileContents.Length);
            requestStream.Close();
            FtpWebResponse response = (FtpWebResponse)request.GetResponse();
            Console.WriteLine("Upload File Complete, status {0}", response.StatusDescription);
            response.Close();

--刪除主鍵
ALTER TABLE [dbo].[cuspayrec]  DROP CONSTRAINT [PK_CuspayRec]
GO
--刪除cp_id欄位
alter   table   [dbo].[cuspayrec]   drop   column   cp_id  
Go

宣告
        Dim NewColumn As New DataGridViewButtonColumn
名稱="button"      
        NewColumn.Name = "button"
DGV新增Column

'假設dt1已有資料，宣告新的dt2
Dim dt2 As DataTable
'復製dt1的結構
dt2 = dt1.Clone

public static bool IsNumeric(string anyString)
{
if (anyString == null)
{
anyString = "";
}
if (anyString.Length > 0)
{
double dummyOut = new double();
System.Globalization.CultureInfo cultureInfo =
new System.Globalization.CultureInfo("en-US", true);
return Double.TryParse(anyString, System.Globalization.NumberStyles.Any,
cultureInfo.NumberFormat, out dummyOut);
}
else
{
return false;
}
}

現在有一個資料表，欄位有日期、件數、金額、類型等等
類型有A、B、C三種
我想要依每天做統計，
所以語法是select count(*),sum(件數),sum(金額) from table gruop by 日期
但是我想加上欄位是每一天類型為A、B、C的金額
count(*),sum(件數),sum(A類的金額),sum(B類的金額),sum(C類的金額), sum(金額)
每一天ABC三個金額加起來為sum(金額)

這是在DataGridView做像TextBox的隱藏密碼的功能，
在DataGridView中的CellFormatting事件中貼上這幾行程式即可將資料用*替代
if (e.ColumnIndex != -1 && this.dataGridView1.Columns[e.ColumnIndex].Name ==  "Column.Name")
     {

譬如:
-------細目-------
2008/1/1~2008/1/3
2008/1/4~2008/1/5
2008/1/6~2008/1/8
2008/1/9~2008/1/10
改成以並排顯示
-------細目-------
2008/1/1~2008/1/3 2008/1/4~2008/1/5

2008/1/6~2008/1/8 2008/1/9~2008/1/10
方法

//加密
public   static   string   Base64Encode(string   AStr)
{
        return   Convert.ToBase64String(Encoding.UTF8.GetBytes(AStr));
}