隨手筆記

private string GetHttpTxt(string strUrl)
{
HttpWebRequest request = (HttpWebRequest)WebRequest.Create(strUrl);
HttpWebResponse webresponse = (HttpWebResponse)request.GetResponse();
StreamReader streamReader = new StreamReader(webresponse.GetResponseStream(), Encoding.UTF8);
webresponse.Close();
return streamReader.ReadToEnd();
}

*****************************************************************************
長條圖
string[] xValues = { "數值1", "數值2" };
string[] titleArr = {"活動1", "活動2"};
int[] yValues = {269000, 94};
int[] yValues2 = {120300, 116};



//ChartAreas,Series,Legends 基本設定--------------------------------------------------

Chart Chart1 = new Chart();
Chart1.ChartAreas.Add("ChartArea1"); //圖表區域集合
Chart1.Series.Add("Series1"); //數據序列集合
Chart1.Series.Add("Series2");
Chart1.Legends.Add("Legends1"); //圖例集合

//設定 Chart

Chart1.Width = 700;
Chart1.Height = 400;

Title title = new Title();
title.Text = "長條圖";
title.Alignment = ContentAlignment.MiddleCenter;
title.Font = new System.Drawing.Font("Trebuchet MS", 14F, FontStyle.Bold);
Chart1.Titles.Add(title);



//設定 ChartArea----------------------------------------------------------------------

Chart1.ChartAreas["ChartArea1"].Area3DStyle.Enable3D = true; //3D效果
Chart1.ChartAreas["ChartArea1"].Area3DStyle.IsClustered = true; //並排顯示
Chart1.ChartAreas["ChartArea1"].Area3DStyle.Rotation = 40; //垂直角度
Chart1.ChartAreas["ChartArea1"].Area3DStyle.Inclination = 50; //水平角度
Chart1.ChartAreas["ChartArea1"].Area3DStyle.PointDepth = 30; //數據條深度
Chart1.ChartAreas["ChartArea1"].Area3DStyle.WallWidth = 0; //外牆寬度
Chart1.ChartAreas["ChartArea1"].Area3DStyle.LightStyle = LightStyle.Realistic; //光源
Chart1.ChartAreas["ChartArea1"].BackColor = Color.FromArgb(240, 240, 240); //背景色
Chart1.ChartAreas["ChartArea1"].AxisX2.Enabled = AxisEnabled.False; //隱藏 X2 標示
Chart1.ChartAreas["ChartArea1"].AxisY2.Enabled = AxisEnabled.False; //隱藏 Y2 標示
Chart1.ChartAreas["ChartArea1"].AxisY2.MajorGrid.Enabled = false; //隱藏 Y2 軸線

//Y 軸線顏色

Chart1.ChartAreas["ChartArea1"].AxisY.MajorGrid.LineColor = Color.FromArgb(150, 150, 150);

//X 軸線顏色

Chart1.ChartAreas["ChartArea1"].AxisX.MajorGrid.LineColor = Color.FromArgb(150, 150, 150);
Chart1.ChartAreas["ChartArea1"].AxisY.LabelStyle.Format = "#,###";

//Chart1.ChartAreas["ChartArea1"].AxisY2.Maximum = 160;
//Chart1.ChartAreas["ChartArea1"].AxisY2.Interval = 20;



//設定 Legends------------------------------------------------------------------------

Chart1.Legends["Legends1"].DockedToChartArea = "ChartArea1"; //顯示在圖表內
//Chart1.Legends["Legends1"].Docking = Docking.Bottom; //自訂顯示位置
Chart1.Legends["Legends1"].BackColor = Color.FromArgb(235, 235, 235); //背景色

//斜線背景

Chart1.Legends["Legends1"].BackHatchStyle = ChartHatchStyle.DarkDownwardDiagonal;
Chart1.Legends["Legends1"].BorderWidth = 1;
Chart1.Legends["Legends1"].BorderColor = Color.FromArgb(200, 200, 200);

//設定 Series-----------------------------------------------------------------------

Chart1.Series["Series1"].ChartType = SeriesChartType.Column; //直條圖
//Chart1.Series["Series1"].ChartType = SeriesChartType.Bar; //橫條圖
Chart1.Series["Series1"].Points.DataBindXY(xValues, yValues);
Chart1.Series["Series1"].Legend = "Legends1";
Chart1.Series["Series1"].LegendText = titleArr[0];
Chart1.Series["Series1"].LabelFormat = "#,###"; //金錢格式
Chart1.Series["Series1"].MarkerSize = 8; //Label 範圍大小
Chart1.Series["Series1"].LabelForeColor = Color.FromArgb(0, 90, 255); //字體顏色

//字體設定

Chart1.Series["Series1"].Font = new System.Drawing.Font("Trebuchet MS", 10, System.Drawing.FontStyle.Bold);

//Label 背景色

Chart1.Series["Series1"].LabelBackColor = Color.FromArgb(150, 255, 255, 255);
Chart1.Series["Series1"].Color = Color.FromArgb(240, 65, 140, 240); //背景色
Chart1.Series["Series1"].IsValueShownAsLabel = true; // Show data points labels

Chart1.Series["Series2"].Points.DataBindXY(xValues, yValues2);
Chart1.Series["Series2"].Legend = "Legends1";
Chart1.Series["Series2"].LegendText = titleArr[1];
Chart1.Series["Series2"].LabelFormat = "#,###"; //金錢格式
Chart1.Series["Series2"].MarkerSize = 8; //Label 範圍大小
Chart1.Series["Series2"].LabelForeColor = Color.FromArgb(255, 103, 0);
Chart1.Series["Series2"].Font = new System.Drawing.Font("Trebuchet MS", 10, FontStyle.Bold);
Chart1.Series["Series2"].LabelBackColor = Color.FromArgb(150, 255, 255, 255);
Chart1.Series["Series2"].Color = Color.FromArgb(240, 252, 180, 65); //背景色
Chart1.Series["Series2"].IsValueShownAsLabel = true; //顯示數據

d1.Controls.Add(Chart1);

建立一個Windows的背景程式
可在以下路徑查詢到所建立的Service
電腦(右鍵) -> 服務與應用程式 -> 服務 建立程式過程: 新增專案 -> 建立Windows Service -> Service1.cs在Design模式下點click here to switch code view -> 回到Service1.cs的Design模式右鍵選 Add Installer
點選serviceInstaller1做設定:
Displayname：服務要顯示的名稱   
Description：描述
ServiceName：服務的唯一名稱
StartType：啟動方式，預設為Manual(手動)，這邊改為Automatic(自動)
DelayedAutoStart：開機之後是否延遲啟動
 
點選serviceProcessInstaller1做設定:
Account：設定服務的帳號與權限，LocalSystem為最大權限

*****************************************************************************
長條圖
string[] xValues = { "數值1", "數值2" };
string[] titleArr = {"活動1", "活動2"};
int[] yValues = {269000, 94};
int[] yValues2 = {120300, 116};



//ChartAreas,Series,Legends 基本設定--------------------------------------------------

Chart Chart1 = new Chart();
Chart1.ChartAreas.Add("ChartArea1"); //圖表區域集合
Chart1.Series.Add("Series1"); //數據序列集合
Chart1.Series.Add("Series2");
Chart1.Legends.Add("Legends1"); //圖例集合

//設定 Chart

Chart1.Width = 700;
Chart1.Height = 400;

Title title = new Title();
title.Text = "長條圖";
title.Alignment = ContentAlignment.MiddleCenter;
title.Font = new System.Drawing.Font("Trebuchet MS", 14F, FontStyle.Bold);
Chart1.Titles.Add(title);



//設定 ChartArea----------------------------------------------------------------------

Chart1.ChartAreas["ChartArea1"].Area3DStyle.Enable3D = true; //3D效果
Chart1.ChartAreas["ChartArea1"].Area3DStyle.IsClustered = true; //並排顯示
Chart1.ChartAreas["ChartArea1"].Area3DStyle.Rotation = 40; //垂直角度
Chart1.ChartAreas["ChartArea1"].Area3DStyle.Inclination = 50; //水平角度
Chart1.ChartAreas["ChartArea1"].Area3DStyle.PointDepth = 30; //數據條深度
Chart1.ChartAreas["ChartArea1"].Area3DStyle.WallWidth = 0; //外牆寬度
Chart1.ChartAreas["ChartArea1"].Area3DStyle.LightStyle = LightStyle.Realistic; //光源
Chart1.ChartAreas["ChartArea1"].BackColor = Color.FromArgb(240, 240, 240); //背景色
Chart1.ChartAreas["ChartArea1"].AxisX2.Enabled = AxisEnabled.False; //隱藏 X2 標示
Chart1.ChartAreas["ChartArea1"].AxisY2.Enabled = AxisEnabled.False; //隱藏 Y2 標示
Chart1.ChartAreas["ChartArea1"].AxisY2.MajorGrid.Enabled = false; //隱藏 Y2 軸線

//Y 軸線顏色

Chart1.ChartAreas["ChartArea1"].AxisY.MajorGrid.LineColor = Color.FromArgb(150, 150, 150);

//X 軸線顏色

Chart1.ChartAreas["ChartArea1"].AxisX.MajorGrid.LineColor = Color.FromArgb(150, 150, 150);
Chart1.ChartAreas["ChartArea1"].AxisY.LabelStyle.Format = "#,###";

//Chart1.ChartAreas["ChartArea1"].AxisY2.Maximum = 160;
//Chart1.ChartAreas["ChartArea1"].AxisY2.Interval = 20;



//設定 Legends------------------------------------------------------------------------

Chart1.Legends["Legends1"].DockedToChartArea = "ChartArea1"; //顯示在圖表內
//Chart1.Legends["Legends1"].Docking = Docking.Bottom; //自訂顯示位置
Chart1.Legends["Legends1"].BackColor = Color.FromArgb(235, 235, 235); //背景色

//斜線背景

Chart1.Legends["Legends1"].BackHatchStyle = ChartHatchStyle.DarkDownwardDiagonal;
Chart1.Legends["Legends1"].BorderWidth = 1;
Chart1.Legends["Legends1"].BorderColor = Color.FromArgb(200, 200, 200);

//設定 Series-----------------------------------------------------------------------

Chart1.Series["Series1"].ChartType = SeriesChartType.Column; //直條圖
//Chart1.Series["Series1"].ChartType = SeriesChartType.Bar; //橫條圖
Chart1.Series["Series1"].Points.DataBindXY(xValues, yValues);
Chart1.Series["Series1"].Legend = "Legends1";
Chart1.Series["Series1"].LegendText = titleArr[0];
Chart1.Series["Series1"].LabelFormat = "#,###"; //金錢格式
Chart1.Series["Series1"].MarkerSize = 8; //Label 範圍大小
Chart1.Series["Series1"].LabelForeColor = Color.FromArgb(0, 90, 255); //字體顏色

//字體設定

Chart1.Series["Series1"].Font = new System.Drawing.Font("Trebuchet MS", 10, System.Drawing.FontStyle.Bold);

//Label 背景色

Chart1.Series["Series1"].LabelBackColor = Color.FromArgb(150, 255, 255, 255);
Chart1.Series["Series1"].Color = Color.FromArgb(240, 65, 140, 240); //背景色
Chart1.Series["Series1"].IsValueShownAsLabel = true; // Show data points labels

Chart1.Series["Series2"].Points.DataBindXY(xValues, yValues2);
Chart1.Series["Series2"].Legend = "Legends1";
Chart1.Series["Series2"].LegendText = titleArr[1];
Chart1.Series["Series2"].LabelFormat = "#,###"; //金錢格式
Chart1.Series["Series2"].MarkerSize = 8; //Label 範圍大小
Chart1.Series["Series2"].LabelForeColor = Color.FromArgb(255, 103, 0);
Chart1.Series["Series2"].Font = new System.Drawing.Font("Trebuchet MS", 10, FontStyle.Bold);
Chart1.Series["Series2"].LabelBackColor = Color.FromArgb(150, 255, 255, 255);
Chart1.Series["Series2"].Color = Color.FromArgb(240, 252, 180, 65); //背景色
Chart1.Series["Series2"].IsValueShownAsLabel = true; //顯示數據

d1.Controls.Add(Chart1);

--方法一
select *
from INFORMATION_SCHEMA.TABLES

--方法二
select *
from sys.tables

--方法三-使用OBJECT_ID
select OBJECT_ID('TableName')
----若為暫存表格，因存放於tempdb，語法改寫為
select OBJECT_ID('tempdb..TableName')

--如果表格存在要一併刪除，可使用下述語法
IF (select OBJECT_ID('TableName')) IS NOT NULL Drop Table TableName

set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go

Create Proc [dbo].[usp_test]
As

Declare rs Cursor For (select top 10 taxcode from test_table)
declare @str nvarchar(100)
declare @result nvarchar(255)

set @result = ''

Open rs

Fetch NEXT From rs into @str--將值放入變數

while @@Fetch_Status = 0--有回傳值

Begin

set @result = @result + ',' + @str

Fetch NEXT From rs into @str --將值放入變數
END

close rs --關閉Cursor
Deallocate rs --釋放Cursor

select @result

--exec usp_test 執行

TRUNCATE TABLE tableName

//讀取回條

MailMessage msg = new MailMessage("send mail", email, subject, msgbody);

msg.Headers.Add("Disposition-Notification-To", "接收回條信箱");


//送達回條

msg.DeliveryNotificationOptions = DeliveryNotificationOptions.OnSuccess;

SmtpClient MailClient = new SmtpClient();

MailClient.DeliveryMethod = SmtpDeliveryMethod.Network;

紀錄記錄~!
下圖記錄幾個方法:
1.在Gridview中滑鼠移動到該欄位可改變欄位顏色(光棒效果)
2.可以調整gridview欄位寬度

紀錄 gridview 相關用法:
 
gridview 直接使用控制象的設定隱藏欄位,這樣的做法會無法取得被隱藏欄位的值,
如何在隱藏欄位的值,就要直接在程式裡完成隱藏欄位跟取值,

紀錄一下此方法如何完成:
 
主要利用onunload的方法去擷取關閉視窗的事件,並且觸發父視窗的postback的發生,如下圖
子視窗

記錄SQL語法:
很常使用到在下達查詢語法時,同時擁有多條件,在程式部分即要做很多判斷,
例如:
if(條件1 == "")

{

--執行SQL 1 語法;

}

else

{

--執行SQL 2 語法;

}