已經好幾個月了,我對一切都失去了一些熱情,畢竟這一年我多了不少的煩惱「愛情、友情、事業、理想、家庭‧‧‧」這些事情在我腦中縈繞不去,總是找不到快樂的位置,也不敢面對自己的軟弱無能,一直找一些事情來逃避現實,記得十月多的時候我寫了一段給自己的話,在這兩個月裡我常常去看那段話,慢慢的調整自己的心態,也該長大了.
或許幸福與快樂並不如我所想的那麼困難,簡單的幸福以及簡單的快樂離我並不遠,只是我對於一切的要求似乎太多了,忘記誰跟我說過「如果不知道自己該往哪裡走,那就往前走吧」,如果不移動是不會找到新的十字路口的,人生是不能停下來太多次的,那我只能對自己說聲
出發了,朝一個看不見的未來前進,沿途收集簡單的幸福與快樂,來找尋自己的下一個路口.
select [name],create_date,modify_date FROM sys.all_objects where type_desc = 'USER_TABLE'
select [name],create_date,modify_date FROM sys.all_objects where type_desc = 'SQL_STORED_PROCEDURE'
and substring([name],1,3) not in ('sp_','dt_','xp_')
ReportViewer1.Attributes.Add("style", "margin-bottom: 70px;");
echo off
@REM 是否啟用DHCP yes/no
SET DHCP=no
@REM 連線名稱
SET netName="無線網路連線"
@REM IP 設定
SET IP=192.168.1.14
@REM 子網路遮罩(SubMask) 設定
SET SubMask=255.255.255.0
@REM 預設閘道(Default Geteway) 設定
SET Gateway=192.168.1.1
@REM 第一DNS 設定
SET DNS_1=61.64.127.1
@REM 第二DNS 設定
SET DNS_2=61.64.127.2
IF %DHCP%==yes (
echo #設定DHCP取得IP
netsh interface ip set address name=%netName% source=dhcp
netsh interface ip set dns name=%netName% source=dhcp register=PRIMARY
) ELSE (
echo #設定 指定IP ,Mask,Getway
netsh interface ip set address name=%netName% source=static addr=%IP% mask=%SubMask% gateway=%Gateway%
echo #設定 指定DNS
netsh interface ip set dns name=%netName% source=static addr=%DNS_1% register=PRIMARY
netsh interface ip add dnsserver name=%netName% %DNS_2%
)
switch (e.Row.RowType)
{
case DataControlRowType.DataRow:
DataRowView Row = (DataRowView)e.Row.DataItem;
sum1 += Convert.ToInt32(Row[2].ToString());
sum2 += Convert.ToInt32(Row[3].ToString());
e.Row.Cells[3].Text = Row[3].ToString() + "%";
break;
case DataControlRowType.Footer:
e.Row.Cells[0].Text = "小計";
e.Row.Cells[2].Text = sum1.ToString();
e.Row.Cells[3].Text = sum2.ToString() + "%";
sum1=0;
sum2=0;
break;
default:
break;
}
//新增Footer
GridViewRow footer = new GridViewRow(-1, -1, DataControlRowType.Footer, DataControlRowState.Normal);
TableCell dtc0 = new TableCell();
TableCell dtc1 = new TableCell();
TableCell dtc2 = new TableCell();
TableCell dtc3 = new TableCell();
DataTable dt = new DataTable();
DataView dv = new DataView();
int iCount = 0;
int iPercent = 0;
dv = (DataView)SqlDataSource1.Select(DataSourceSelectArguments.Empty); //Get DataView
dt = dv.ToTable();
iCount = Convert.ToInt32(dt.Compute("sum(Count)", ""));
iPercent = Convert.ToInt32(dt.Compute("sum(Percent)", ""));
dtc0.Text = "總計";
dtc1.Text = " ";
dtc2.Text = iCount.ToString();
dtc3.Text = iPercent.ToString() + "%";
footer.Controls.Add(dtc0);
footer.Controls.Add(dtc1);
footer.Controls.Add(dtc2);
footer.Controls.Add(dtc3);
GridView1.Controls[0].Controls.AddAt(GridView1.Controls[0].Controls.Count - 1, footer);
--新增Table
CREATE TABLE [dbo].[Orders](
[ID] [int] IDENTITY(1,1) NOT NULL,
[Product] [varchar](10) NOT NULL,
[Personal_ID] [varchar](10) NOT NULL,
[Personal_Name] [varchar](10) NOT NULL,
[Purchase_Date] [datetime] NOT NULL,
CONSTRAINT [PK_Order] PRIMARY KEY CLUSTERED
(
[ID] ASC,
[Product] ASC
) ON [PRIMARY]
) ON [PRIMARY]
-----------------------------------------------------
--新增資料
insert into Orders(Product,Personal_Name,Personal_ID,Purchase_Date)
values('Wii','Andy','0001','2008/06/19')
insert into Orders(Product,Personal_Name,Personal_ID,Purchase_Date)
values('PSP','Andy','0001','2008/06/19')
insert into Orders(Product,Personal_Name,Personal_ID,Purchase_Date)
values('NDSL','Andy','0001','2008/06/19')
insert into Orders(Product,Personal_Name,Personal_ID,Purchase_Date)
values('XBOX','Andy','0001','2008/06/19')
insert into Orders(Product,Personal_Name,Personal_ID,Purchase_Date)
values('PS3','Andy','0001','2008/06/19')
insert into Orders(Product,Personal_Name,Personal_ID,Purchase_Date)
values('Wii','Bill','0002','2008/06/19')
insert into Orders(Product,Personal_Name,Personal_ID,Purchase_Date)
values('PSP','Bill','0002','2008/06/19')
insert into Orders(Product,Personal_Name,Personal_ID,Purchase_Date)
values('NDSL','Jay','0003','2008/06/19')
insert into Orders(Product,Personal_Name,Personal_ID,Purchase_Date)
values('XBOX','Jay','0003','2008/06/19')
insert into Orders(Product,Personal_Name,Personal_ID,Purchase_Date)
values('PS3','Jay','0003','2008/06/19')
insert into Orders(Product,Personal_Name,Personal_ID,Purchase_Date)
values('Wii','Ivan','0004','2008/06/19')
insert into Orders(Product,Personal_Name,Personal_ID,Purchase_Date)
values('PSP','Ivan','0004','2008/06/19')
insert into Orders(Product,Personal_Name,Personal_ID,Purchase_Date)
values('NDSL','Ivan','0004','2008/06/19')
insert into Orders(Product,Personal_Name,Personal_ID,Purchase_Date)
values('XBOX','Ivan','0004','2008/06/19')
insert into Orders(Product,Personal_Name,Personal_ID,Purchase_Date)
values('PS3','Louis','0005','2008/06/19')
insert into Orders(Product,Personal_Name,Personal_ID,Purchase_Date)
values('Wii','Louis','0005','2008/06/19')
insert into Orders(Product,Personal_Name,Personal_ID,Purchase_Date)
values('PSP','Kenny','0006','2008/06/19')
insert into Orders(Product,Personal_Name,Personal_ID,Purchase_Date)
values('NDSL','Kenny','0006','2008/06/19')
insert into Orders(Product,Personal_Name,Personal_ID,Purchase_Date)
values('XBOX','Kenny','0006','2008/06/19')
insert into Orders(Product,Personal_Name,Personal_ID,Purchase_Date)
values('PS3','Kenny','0006','2008/06/19')
ALTER PROCEDURE [dbo].[prOrderStatistic]
AS
BEGIN
SET NOCOUNT ON;
declare @Total as int
select @Total = count(*) from Orders with (nolock)
select Personal_Name,Personal_ID,'Count' = count(*), 'Percent'=count(*)*100/@Total from Orders
group by Personal_Name,Personal_ID order by 'Count' desc
END
Literal lt = new Literal();
lt.Text = "<scrupt>alert('Hellow World');</script>";
this.Page.Controls.Add(lt);
String sScript = "<scrupt>alert('Hellow World');</script>";
Page.ClientScript.RegisterClientScriptBlock(this.GetType(), "test", sScript);
方法一
System.Drawing.Color color = System.Drawing.ColorTranslator.FromHtml("#FFFFC0");
方法二
System.Drawing.Color color = System.Drawing.Color.FromArgb(255,182.193);
方法三
Gridview1.BorderColor = System.Drawing.Color.FromName("#FFFFC0");
Step1. 加入Web Services參考
服務位置：http://xxx.xxx.xxx/service.asmx
參考名稱：TestService
Step2. 程式碼中使用並動態變更
/* Create Web Services Object */
TestService oWs = new TestService();
/* Switch Service Address */
oWs.Url = "http://ooo.xxx.xxx/services.asmx";
oWs.Discover();
Use Current Service Method...
