老王 – 第 23 頁

Asp.Net 十幾行程式碼搞定 Master-Detail GridView(內含子 GridView)

2012-01-042012-01-04 老王

一直都只有找到VB版 , 能力有限 , 修改不了

找這這篇C#版,好實用忍不住要把他記下來 ... 原文出處

步驟1.創造兩個GridView+SqlDataSource

步驟2.GridView1 的 RowDataBound 事件撰寫下面

<span style="color: #0000ff">protected</span> <span style="color: #0000ff">void</span> GridView1_RowDataBound(<span style="color: #0000ff">object</span> sender, GridViewRowEventArgs e)

				1

						<span style="color: #0000ff">protected</span> <span style="color: #0000ff">void</span> GridView1_RowDataBound(<span style="color: #0000ff">object</span> sender, GridViewRowEventArgs e)

{

				1

						{

    <span style="color: #0000ff">if</span> ((e.Row.RowState & DataControlRowState.Selected) == DataControlRowState.Selected)

				1

						    <span style="color: #0000ff">if</span> ((e.Row.RowState & DataControlRowState.Selected) == DataControlRowState.Selected)

      {

				1

						      {

        GridViewRow oRow = <span style="color: #0000ff">new</span> GridViewRow(0, -1, DataControlRowType.DataRow, e.Row.RowState);

				1

						        GridViewRow oRow = <span style="color: #0000ff">new</span> GridViewRow(0, -1, DataControlRowType.DataRow, e.Row.RowState);

        GridView2.Visible = <span style="color: #0000ff">true</span>;

				1

						        GridView2.Visible = <span style="color: #0000ff">true</span>;

        GridView2.DataBind();

				1

						        GridView2.DataBind();

        <span style="color: #0000ff">string</span> sHTML = ControlToHTML(GridView2);

				1

						        <span style="color: #0000ff">string</span> sHTML = ControlToHTML(GridView2);

        GridView2.Visible = <span style="color: #0000ff">false</span>;

				1

						        GridView2.Visible = <span style="color: #0000ff">false</span>;

        TableCell oCell = <span style="color: #0000ff">new</span> TableCell();

				1

						        TableCell oCell = <span style="color: #0000ff">new</span> TableCell();

        oCell.Text = sHTML;

				1

						        oCell.Text = sHTML;

        oCell.ColumnSpan = e.Row.Cells.Count;

				1

						        oCell.ColumnSpan = e.Row.Cells.Count;

        oRow.Cells.Add(oCell);

				1

						        oRow.Cells.Add(oCell);

        e.Row.Parent.Controls.AddAt(e.Row.RowIndex + 2, oRow);

				1

						        e.Row.Parent.Controls.AddAt(e.Row.RowIndex + 2, oRow);

    }

				1

						    }

}

				1

						}

步驟3加入兩段小小程式碼不然不會動

<span style="color: #0000ff">private</span> <span style="color: #0000ff">string</span> ControlToHTML(System.Web.UI.Control Control)

				1

						<span style="color: #0000ff">private</span> <span style="color: #0000ff">string</span> ControlToHTML(System.Web.UI.Control Control)

{

				1

						{

    <span style="color: #0000ff">string</span> sHTML = <span style="color: #0000ff">string</span>.Empty;

				1

						    <span style="color: #0000ff">string</span> sHTML = <span style="color: #0000ff">string</span>.Empty;

    StringWriter oTextWriter = <span style="color: #0000ff">new</span> StringWriter();

				1

						    StringWriter oTextWriter = <span style="color: #0000ff">new</span> StringWriter();

    HtmlTextWriter oHtmlWriter = <span style="color: #0000ff">new</span> HtmlTextWriter(oTextWriter);

				1

						    HtmlTextWriter oHtmlWriter = <span style="color: #0000ff">new</span> HtmlTextWriter(oTextWriter);

				1

    Control.RenderControl(oHtmlWriter);

				1

						    Control.RenderControl(oHtmlWriter);

    sHTML = Convert.ToString(oTextWriter);

				1

						    sHTML = Convert.ToString(oTextWriter);

    <span style="color: #0000ff">return</span> sHTML;

				1

						    <span style="color: #0000ff">return</span> sHTML;

}

				1

						}

				1

				1

<span style="color: #0000ff">public</span> <span style="color: #0000ff">override</span> <span style="color: #0000ff">void</span> VerifyRenderingInServerForm(Control control)

				1

						<span style="color: #0000ff">public</span> <span style="color: #0000ff">override</span> <span style="color: #0000ff">void</span> VerifyRenderingInServerForm(Control control)

{}

				1

						{}

步驟4.在原始檔部分設定一下屬性
設定 GridView1的 EnableViewState="False"
設定 GridView2的 EnableViewState="False"，且設定 Visible="False"
Page 的 EnableEventValidation="false"
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default6.aspx.cs" Inherits="Default6" EnableEventValidation="false" %>

JavaScript 列印按鈕設定語法 , chrome OK

2012-01-032012-01-03 老王

chrome 實測正常

頁面的列印:

<span style="color: #0000ff"><</span><span style="color: #800000">a</span> <span style="color: #ff0000">href</span><span style="color: #0000ff">='#'</span> <span style="color: #ff0000">class</span><span style="color: #0000ff">='notprint'</span> <span style="color: #ff0000">onclick</span><span style="color: #0000ff">='pagesetup_null();self.print();'</span><span style="color: #0000ff">><</span><span style="color: #800000">img</span> <span style="color: #ff0000">src</span>=../<span style="color: #ff0000">images</span>/<span style="color: #ff0000">printer</span>.<span style="color: #ff0000">png</span> <span style="color: #ff0000">border</span>=<span style="color: #ff0000">0</span> <span style="color: #ff0000">title</span><span style="color: #0000ff">='列印'</span> <span style="color: #0000ff">></</span><span style="color: #800000">a</span><span style="color: #0000ff">></span>

				1

						<span style="color: #0000ff"><</span><span style="color: #800000">a</span> <span style="color: #ff0000">href</span><span style="color: #0000ff">='#'</span> <span style="color: #ff0000">class</span><span style="color: #0000ff">='notprint'</span> <span style="color: #ff0000">onclick</span><span style="color: #0000ff">='pagesetup_null();self.print();'</span><span style="color: #0000ff">><</span><span style="color: #800000">img</span> <span style="color: #ff0000">src</span>=../<span style="color: #ff0000">images</span>/<span style="color: #ff0000">printer</span>.<span style="color: #ff0000">png</span> <span style="color: #ff0000">border</span>=<span style="color: #ff0000">0</span> <span style="color: #ff0000">title</span><span style="color: #0000ff">='列印'</span> <span style="color: #0000ff">></</span><span style="color: #800000">a</span><span style="color: #0000ff">></span>

不列印頁眉頁腳:

<script language=<span style="color: #006080">"javascript"</span>>

				1

						<script language=<span style="color: #006080">"javascript"</span>>

<span style="color: #0000ff">var</span> hkey_root,hkey_path,hkey_key

				1

						<span style="color: #0000ff">var</span> hkey_root,hkey_path,hkey_key

hkey_root=<span style="color: #006080">"HKEY_CURRENT_USER"</span>

				1

						hkey_root=<span style="color: #006080">"HKEY_CURRENT_USER"</span>

hkey_path=<span style="color: #006080">"//Software//Microsoft//Internet Explorer//PageSetup//"</span>

				1

						hkey_path=<span style="color: #006080">"//Software//Microsoft//Internet Explorer//PageSetup//"</span>

<span style="color: #0000ff">function</span> pagesetup_null()

				1

						<span style="color: #0000ff">function</span> pagesetup_null()

{

				1

						{

<span style="color: #0000ff">try</span>{

				1

						<span style="color: #0000ff">try</span>{

<span style="color: #0000ff">var</span> RegWsh = <span style="color: #0000ff">new</span> ActiveXObject(<span style="color: #006080">"WScript.Shell"</span>)

				1

						<span style="color: #0000ff">var</span> RegWsh = <span style="color: #0000ff">new</span> ActiveXObject(<span style="color: #006080">"WScript.Shell"</span>)

hkey_key=<span style="color: #006080">"header"</span>

				1

						hkey_key=<span style="color: #006080">"header"</span>

RegWsh.RegWrite(hkey_root+hkey_path+hkey_key,<span style="color: #006080">""</span>)

				1

						RegWsh.RegWrite(hkey_root+hkey_path+hkey_key,<span style="color: #006080">""</span>)

hkey_key=<span style="color: #006080">"footer"</span>

				1

						hkey_key=<span style="color: #006080">"footer"</span>

RegWsh.RegWrite(hkey_root+hkey_path+hkey_key,<span style="color: #006080">""</span>)

				1

						RegWsh.RegWrite(hkey_root+hkey_path+hkey_key,<span style="color: #006080">""</span>)

}<span style="color: #0000ff">catch</span>(e){}

				1

						}<span style="color: #0000ff">catch</span>(e){}

}

				1

						}

</script>

				1

						</script>

某些元素不列印: 未測

<style> 

				1

						<style> 

<span style="color: #cc6633">@media</span> print { 

				1

						<span style="color: #cc6633">@media</span> print { 

.notprint { 

				1

						.notprint { 

display:none; 

				1

						display:none; 

} 

				1

						} 

} 

				1

						} 

				1

<span style="color: #cc6633">@media</span> screen { 

				1

						<span style="color: #cc6633">@media</span> screen { 

.notprint { 

				1

						.notprint { 

display:inline; 

				1

						display:inline; 

cursor:hand; 

				1

						cursor:hand; 

} 

				1

						} 

}

				1

						}

</style>

				1

						</style>

來源網址

Asp.Net 以動態方式在前台加入靜態文字

2012-01-032012-01-03 老王

this.Controls.Add(new LiteralControl("<b>hello there</b>"));

1	this.Controls.Add(new LiteralControl("<b>hello there</b>"));

當前台沒有可接收的控制項時 , 可用 LiteralControl 輸出

Asp.Net GridView 新增 ButtonField 刪除鍵確認視窗

2012-01-022012-01-02 老王

<span class="kwrd">C#</span>

				1

						<span class="kwrd">C#</span>

<span class="kwrd">protected</span> <span class="kwrd">void</span> GridView1_RowDataBound(<span class="kwrd">object</span> sender, GridViewRowEventArgs e)

				1

						<span class="kwrd">protected</span> <span class="kwrd">void</span> GridView1_RowDataBound(<span class="kwrd">object</span> sender, GridViewRowEventArgs e)

       {

				1

						       {

           DataRowView oDataRow;

				1

						           DataRowView oDataRow;

           <span class="kwrd">string</span> sShowField, sMessage;

				1

						           <span class="kwrd">string</span> sShowField, sMessage;

           LinkButton btnDelete;

				1

						           LinkButton btnDelete;

           <span class="kwrd">if</span> (e.Row.RowIndex != -1)

				1

						           <span class="kwrd">if</span> (e.Row.RowIndex != -1)

           {

				1

						           {

               oDataRow = (DataRowView)(e.Row.DataItem);

				1

						               oDataRow = (DataRowView)(e.Row.DataItem);

               sShowField = oDataRow[<span class="str">"序號"</span>].ToString();

				1

						               sShowField = oDataRow[<span class="str">"序號"</span>].ToString();

               sMessage = <span class="kwrd">string</span>.Format(<span class="str">"您確定要刪除第 [{0}] 筆訂單 嗎?"</span>, sShowField);

				1

						               sMessage = <span class="kwrd">string</span>.Format(<span class="str">"您確定要刪除第 [{0}] 筆訂單 嗎?"</span>, sShowField);

               btnDelete = (LinkButton)(e.Row.Cells[7].Controls[0]);

				1

						               btnDelete = (LinkButton)(e.Row.Cells[7].Controls[0]);

               btnDelete.OnClientClick = <span class="str">"if (confirm('"</span> + sMessage + <span class="str">"')==false) {return false;}"</span>;

				1

						               btnDelete.OnClientClick = <span class="str">"if (confirm('"</span> + sMessage + <span class="str">"')==false) {return false;}"</span>;

           }

				1

						           }

       }

				1

						       }

				1

				1

原文網址

Asp.Net + Javascript 複製文字到剪貼簿目前最佳解決方案 ZeroClipboard

2011-12-232011-12-23 老王

ZeroClipboard 原理是在 DOM元件上覆蓋一層flash ,在各家瀏覽器上較為通用
本範例由使用C#後台丟串字到前台( tb_link.Text) ,再經由 button 進行複製動作 IE9 ,CHrome 測試OK,
1.到 ZeroClipBoard 網站下庫javascript 程式 ,並將程式解開放入專案中

2.在 <HEAD></HEAD> 中插入

 <script src="ZeroClipboard.js" type="text/javascript"></script>
<script type="text/javascript"> ZeroClipboard.setMoviePath('ZeroClipboard.swf'); //指定code 所在路徑路徑</script>
<script type = "text/javascript">
$(function() {
ZeroClipboardInit();
});
function ZeroClipboardInit() {
var clip = new ZeroClipboard.Client();
//複製完成彈出訊息
clip.addEventListener('complete', function(client, text) {
alert("已複製到剪貼簿");
});
//指定複製來源ID
clip.setText(document.getElementById('tb_link').value);/
clip.glue('btn_copy');//'BtnExport'指某个DOM元素（如：Button）的ID
}
</script>

$(function() {

ZeroClipboardInit();

});

function ZeroClipboardInit() {

var clip = new ZeroClipboard.Client();

//複製完成彈出訊息

clip.addEventListener('complete', function(client, text) {

alert("已複製到剪貼簿");

});

//指定複製來源ID

clip.setText(document.getElementById('tb_link').value);/

clip.glue('btn_copy');//'BtnExport'指某个DOM元素（如：Button）的ID

}

</script>

3. 在 <body></body> 中插入

<asp:TextBox ID="tb_link" runat="server" Width="300"  text="要被複製的文字"></asp:TextBox>
<br />
<asp:Button ID="btn_copy" runat="server" Text="複製連結" />

<asp:TextBox ID="tb_link" runat="server" Width="300" text="要被複製的文字"></asp:TextBox>

<br />

<asp:Button ID="btn_copy" runat="server" Text="複製連結" />

2011/12/23更新:

1	2011/12/23更新:

在覆蓋DOM元件的FLASH 有時不會在正確位置上 , 目前已知原因有 page 的resize 事件,

1	在覆蓋DOM元件的FLASH 有時不會在正確位置上 , 目前已知原因有 page 的resize 事件,

zerocipboard 有提供相對應的元件

1	zerocipboard 有提供相對應的元件

reposition()

1	reposition()

有查到用法

有查到用法

<span>window.onresize = function() {clip.reposition();};</span>

1	<span>window.onresize = function() {clip.reposition();};</span>

<span><br /></span>

1	<span><br /></span>

而我遇到的是在上方加一個圖片時,FLASH 還停留在上方,我想應該該是載入順序的問題,

1	而我遇到的是在上方加一個圖片時,FLASH 還停留在上方,我想應該該是載入順序的問題,

想說用 window.onload 解決 , 可惜java 真的跟他不是很熟,轉個方向先把高成先定出來,倒也可以解決

1	想說用 window.onload 解決 , 可惜java 真的跟他不是很熟,轉個方向先把高成先定出來,倒也可以解決

所以當使用使效語法又沒有錯時 , 可以上該元件的附近找找有沒有可以點擊的地方 , 有可能是位置跑掉了 ...

1	所以當使用使效語法又沒有錯時 , 可以上該元件的附近找找有沒有可以點擊的地方 , 有可能是位置跑掉了 ...

Asp.Net 短網址實作 IN Framework 4.0

2011-12-222011-12-22 老王

在專案內新建一個 Global.asax

先import 以下兩個 namespace

" ]<%@ Import Namespace="System.Web.Routing" %>
<%@ Import Namespace="System.Web.Compilation" %>

1 2	" ]<%@ Import Namespace="System.Web.Routing" %> <%@ Import Namespace="System.Web.Compilation" %>

在 Application_Start(object 加入註冊

void Application_Start(object sender, EventArgs e)
{
// 應用程式啟動時執行的程式碼

RegisterRoutes(RouteTable.Routes);

1	RegisterRoutes(RouteTable.Routes);

}

新增虎理轉址 class

 public static void RegisterRoutes(RouteCollection routes)
{
//EX:網址為 http://xx.xx.xx/od/12345678 , 12345678 為可置換的內容 , 會對應到不網頁
routes.Add(new Route("od/{gpo_no}", new OrderRouteHandler("~/order/order_look.aspx")));
}
public class OrderRouteHandler : IRouteHandler
{
private string virtualPath;
public OrderRouteHandler(string virtualPath)
{
this.virtualPath = virtualPath;
}
public IHttpHandler GetHttpHandler(RequestContext requestContext)
{
//origquerystr 透過httpcontext 取出 gpo_no 值應用
string origQueryStr = HttpContext.Current.Request.QueryString.ToString();
string queryStr = "?gpo_no=" + requestContext.RouteData.Values["gpo_no"];
if (!string.IsNullOrEmpty(origQueryStr))
queryStr += "&" + origQueryStr;
HttpContext.Current.RewritePath(string.Concat(virtualPath, queryStr));
return BuildManager.CreateInstanceFromVirtualPath(virtualPath, typeof(Page)) as Page;
}
}

public static void RegisterRoutes(RouteCollection routes)

{

//EX:網址為 http://xx.xx.xx/od/12345678 , 12345678 為可置換的內容 , 會對應到不網頁

routes.Add(new Route("od/{gpo_no}", new OrderRouteHandler("~/order/order_look.aspx")));

}

public class OrderRouteHandler : IRouteHandler

{

private string virtualPath;

public OrderRouteHandler(string virtualPath)

{

this.virtualPath = virtualPath;

}

public IHttpHandler GetHttpHandler(RequestContext requestContext)

{

//origquerystr 透過httpcontext 取出 gpo_no 值應用

string origQueryStr = HttpContext.Current.Request.QueryString.ToString();

string queryStr = "?gpo_no=" + requestContext.RouteData.Values["gpo_no"];

if (!string.IsNullOrEmpty(origQueryStr))

queryStr += "&" + origQueryStr;

HttpContext.Current.RewritePath(string.Concat(virtualPath, queryStr));

return BuildManager.CreateInstanceFromVirtualPath(virtualPath, typeof(Page)) as Page;

}

主要的功能是把原本落落長的網址 http://xx.xx.xx/order/order_look.aspx?gpo_no=12345678

簡化為 http://x.xx.xx/od/12345678 以增加可讀性

參考網址 Jailu.NET

Outlook 2007 收到亂碼郵件處理方式

2011-12-142011-12-14 老王

1.單一郵件處理:

點開郵件後更換語系

2.另一種可能為所在 PST 檔 2002 以前的格式 , 無法自動轉換utf-8格式,解決方法:

新開一個PST 檔,再把舊資料復製過去

, 改預設值改為新的PST 檔 ,

最後關閉舊PST

Office Outlook 2007 縮小至工作列說明

2011-12-132011-12-13 老王

這個困擾我一段時間的小小小問題 , 今天終於有空來解決一下

以下註冊表可解決

Windows Registry Editor Version 5.00

				1

						Windows Registry Editor Version 5.00

				1

[HKEY_CURRENT_USER\Software\Microsoft\Office\12.0\Outlook\Preferences]

				1

						[HKEY_CURRENT_USER\Software\Microsoft\Office\12.0\Outlook\Preferences]

<span class="str">"MinToTray"</span>=dword:00000001

				1

						<span class="str">"MinToTray"</span>=dword:00000001

使用方法 :

1.關閉outlook

2.新增一個 .txt 檔 , 貼入內容再另存為 xxx.reg ,再執行此REG檔即可

或者直接去編登錄檔在 HKEY_CURRENT_USER\Software\Microsoft\Office\12.0\Outlook\Preferences 下新增

一個 dword 項目 , 名稱為 MinToTray , 值為 1

另外再配合郵件通知就天衣無縫了

Asp.Net 頁面執行順序

2011-12-102011-12-10 老王

一般情況下：

Page.PreInit
Page.Init
Page.InitComplete
Page.PreLoad
Page.Load
Page.LoadComplete
Page.PreRender
Page.PreRenderComplete

使用了 MasterPage 情況， MasterPage 與 ContentPage 事件順序：

ContentPage.PreInit
Master.Init
ContentPage.Init
ContentPage.InitComplete
ContentPage.PreLoad
ContentPage.Load
Master.Load
ContentPage.LoadComplete
ContentPage.PreRender
Master.PreRender
ContentPage.PreRenderComplete

參考http://www.dotnetcurry.com/ShowArticle.aspx?ID=61

Outlook 2007的資料檔轉移至D ,設定檔匯入/匯出批次程式

2011-12-052011-12-05 老王 1 Comment

來源 : http://blog.xuite.net/y0933717246/IT/37778226

為了將Outlook 2007的資料檔轉移至D:而寫的設定匯入/匯出批次程式

批次檔下載連結 http://webhd.xuite.net/_oops/y0933717246/wsj

PS: 因為內含批次檔選單技巧因此將Code貼上如下

@echo off
setlocal
:menu
cls
echo *****  Outlook 2007 帳號設定檔 匯入/匯出   *****
echo.
echo  1.  設定檔 匯出  ...
echo.
echo  2.  設定檔 匯入  ...
echo.
echo  3.  複製 Outlook 目錄到 D:\sys\Mail\  ...
echo.
echo  0.  跳離程式選單 ...
echo. & echo.
set /p x="請依照需求選擇所需數字，請選擇 ? "
echo. & echo.
IF %x% == 1  goto MEU%x%
IF %x% == 2  goto MEU%x%
IF %x% == 3  goto MEU%x%
IF %x% == 0  goto MEU%x%
goto menu
:MEU1
echo 程式執行後會產生outlookset的檔案 。
echo.
echo 回選單
pause
reg export "HKCU\Software\Microsoft\Windows NT\CurrentVersion\Windows Messaging Subsystem\Profiles\Outlook\9375CFF0413111d3B88A00104B2A6676" outlookset.reg
goto menu
:MEU2
echo 將產生的outlookset檔匯入 。
echo.
echo 回選單
pause
reg import outlookset.reg
del outlookset.reg
goto menu
:MEU3
echo 將Outlook的資料目錄複製到 D:\sys\Mail\Outlook 。
echo.
echo 回選單
pause
xcopy "%userprofile%\Local Settings\Application Data\Microsoft\Outlook" d:\sys\mail\Outlook\*.* /s/e/v/y
goto menu
:MEU0
echo 感謝您的使用。
:end
echo.
endlocal

@echo off

setlocal

:menu

cls

echo ***** Outlook 2007 帳號設定檔匯入/匯出 *****

echo.

echo 1. 設定檔匯出 ...

echo.

echo 2. 設定檔匯入 ...

echo.

echo 3. 複製 Outlook 目錄到 D:\sys\Mail\ ...

echo.

echo 0. 跳離程式選單 ...

echo. & echo.

set /p x="請依照需求選擇所需數字，請選擇 ? "

echo. & echo.

IF %x% == 1 goto MEU%x%

IF %x% == 2 goto MEU%x%

IF %x% == 3 goto MEU%x%

IF %x% == 0 goto MEU%x%

goto menu

:MEU1

echo 程式執行後會產生outlookset的檔案。

echo.

echo 回選單

pause

reg export "HKCU\Software\Microsoft\Windows NT\CurrentVersion\Windows Messaging Subsystem\Profiles\Outlook\9375CFF0413111d3B88A00104B2A6676" outlookset.reg

goto menu

:MEU2

echo 將產生的outlookset檔匯入。

echo.

echo 回選單

pause

reg import outlookset.reg

del outlookset.reg

goto menu

:MEU3

echo 將Outlook的資料目錄複製到 D:\sys\Mail\Outlook 。

echo.

echo 回選單

pause

xcopy "%userprofile%\Local Settings\Application Data\Microsoft\Outlook" d:\sys\mail\Outlook\*.* /s/e/v/y

goto menu

:MEU0

echo 感謝您的使用。

:end

echo.

endlocal

Follow us