F6 Team

這個想法是小弟在讀書時期..教授用來追女朋友的idea....分享給大家呀...

如果是常常在家寫程式的人..沒時間陪女朋友....就做一個送女朋友呀...

在此要感謝提供美美測試照片的朋友..eVonne...

聽說越遠看越清楚喔...

PS.這篇文章好像很久以前就貼在點部落了...好像忘了分享給小舖的朋友了..看來我比較喜歡點部落...呵呵..

eVonneImageProcess.aspx
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="eVonneImageProcess.aspx.cs" Inherits="eVonneImageProcess" %> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml" > <head runat="server"> <title>eVonneImageProcess</title> </head> <body> <form id="form1" runat="server"> <div> <asp:RadioButtonList ID="RadioButtonList1" runat="server" RepeatDirection="Horizontal"> <asp:ListItem Selected="True" Value="灰階">灰階</asp:ListItem> <asp:ListItem Value="彩色">彩色</asp:ListItem> </asp:RadioButtonList><asp:TextBox ID="TextBox1" runat="server">eVonne </asp:TextBox> <asp:Button ID="Button1" runat="server" OnClick="Button1_Click" Text="執行" /> <asp:RequiredFieldValidator ID="RequiredFieldValidator1" runat="server" ControlToValidate="TextBox1" ErrorMessage="字串不可以為空"></asp:RequiredFieldValidator><br /> <asp:Image ID="Image1" runat="server" ImageUrl="~/evonne.jpg" /><br /> <asp:Literal ID="Literal1" runat="server"></asp:Literal></div> </form> </body> </html>

eVonneImageProcess.aspx.cs
using System; using System.Data; using System.Configuration; using System.Collections; using System.Web; using System.Web.Security; using System.Web.UI; using System.Web.UI.WebControls; using System.Web.UI.WebControls.WebParts; using System.Web.UI.HtmlControls; using System.Text; using System.Drawing; public partial class eVonneImageProcess : System.Web.UI.Page { protected void Page_Load(object sender, EventArgs e) { } protected void Button1_Click(object sender, EventArgs e) { StringBuilder sb = new StringBuilder(); //載入你要處理的圖片 Bitmap b = new Bitmap(Server.MapPath("evonne.jpg")); int cnt = 0; sb.Append("<pre>"); //x=x+2,如果產生的圖片太高可以調整這個,可以+1,+2,+3 for (int x = 0; x < b.Height; x = x + 2) { for (int y = 0; y < b.Width; y++) { Color pixel = b.GetPixel(y, x); //顯示的格式可以自行調整 if (this.RadioButtonList1.SelectedIndex == 0) { sb.AppendFormat("<span style='background-color:black;'><font color='{0}'>{1}</font></span>", ColorTranslator.ToHtml(ToGray(pixel)), GetVal(cnt)); } else { sb.AppendFormat("<span style='background-color:black;'><font color='{0}'>{1}</font></span>", ColorTranslator.ToHtml(pixel), GetVal(cnt)); } cnt++; } sb.Append("<br/>"); } sb.Append("</pre>"); this.Literal1.Text = sb.ToString(); } protected string GetVal(int cnt) { char[] str = this.TextBox1.Text.ToCharArray(); return str[cnt % str.Length].ToString(); } protected Color ToGray(Color pixel) { int val = (pixel.R + pixel.G + pixel.B) / 3; return Color.FromArgb(val, val, val); } }

執行結果：

原始碼下載：下載

參考網址：http://www.dotblogs.com.tw/puma/archive/2008/04/05/2596.aspx

posted @ 3:37 PM | Feedback (0)

ASP.NET Button 的 disable & Validator 結合問題 ?

前陣子看到討論區有這方面的問題，如下：

像是「存檔」、「更新資料」這一類的 button 都會搭配 validator control 作資料驗證
不過有時網路不夠快或是頁面執行速度較慢會讓 user 覺得網頁當掉而再「多」按一下 button
這樣有時會導致資料重覆送出，所以我想讓 button 按下後有一種效果，
若通過 validator 驗證，則會一併將 button disable 起來，
若沒有通過 validator 驗證，button 則是仍然有效。

小弟就做一個範例介紹如何完成這樣的功能...c#

ButtonDemo.aspx
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="ButtonDemo.aspx.cs" Inherits="ButtonDemo" %> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head runat="server"> <title>ButtonDemo</title> </head> <body> <form id="form1" runat="server"> <div> <asp:TextBox ID="TextBox1" runat="server"></asp:TextBox> <asp:RequiredFieldValidator ID="RequiredFieldValidator1" runat="server" ControlToValidate="TextBox1" ErrorMessage="不可為空白"></asp:RequiredFieldValidator> <br /> <asp:Button ID="Button2" runat="server" Text="送出" OnClientClick="return ConfirmMe(this)" OnClick="Button2_Click" /> </div> </form> </body> </html> <script type="text/javascript"> function ConfirmMe(btn) { if(Page_ClientValidate()) { btn.disabled="disabled"; document.forms[0].__EVENTTARGET.value = btn.name; document.forms[0].__EVENTARGUMENT.value = ''; document.forms[0].submit(); } else { return false; } } </script>

ButtonDemo.aspx.cs
using System; using System.Data; using System.Configuration; using System.Collections; using System.Web; using System.Web.Security; using System.Web.UI; using System.Web.UI.WebControls; using System.Web.UI.WebControls.WebParts; using System.Web.UI.HtmlControls; public partial class ButtonDemo : System.Web.UI.Page { protected void Page_Load(object sender, EventArgs e) { } protected void Button2_Click(object sender, EventArgs e) { System.Threading.Thread.Sleep(2000); } }

執行結果：

沒輸入時,會有驗證文字出現

有輸入時,會將Button給disable,防止重覆點選

參考網址：

http://www.dotblogs.com.tw/puma/archive/2008/03/26/2313.aspx

http://www.blueshop.com.tw/board/show.asp?subcde=BRD20080410142742P4B&fumcde=

posted @ 5:08 PM | Feedback (0)

使用ASP.NET Cache 的 CacheDependency 來偵測資料庫是否變更

小弟前陣子在討論區看到此篇文章...經過測試後有小小心得..分享給大家呀...

首先準備下列檔案：

CacheDependencyDataAdd.aspx,CacheDependencyDataAdd.aspx.cs→做資料更新網頁

CacheDependencyDemo.aspx,CacheDependencyDemo.aspx.cs→做資料瀏覽網頁

CheckChange.txt→檢查資料是否有更改的文字檔(內容空的)

--------------------------------------------------------------------------------------------------------------------------------

CacheDependencyDemo.aspx

CacheDependencyDemo.aspx.cs

using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Web.Caching;
using System.Data.SqlClient;

public partial class CacheDependencyDemo : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        if (Cache["data"] == null)
        {
            DataTable dt = GetData();
            //增加一個檢查資料是否有更改的文字檔
            CacheDependency file = new CacheDependency(Server.MapPath("CheckChange.txt"));
            Cache.Insert("data", dt, file, DateTime.MaxValue, TimeSpan.FromMinutes(10));
            this.GridView1.DataSource = dt;
            this.GridView1.DataBind();
            Response.Write("no Cache");
        }
        else
        {
            DataTable dt = (DataTable)Cache["data"];
            this.GridView1.DataSource = dt;
            this.GridView1.DataBind();
            Response.Write("use Cache");
        }
    }

//取得資料
    protected DataTable GetData()
    {
        using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString))
        {
            string queryString = "SELECT * FROM [user]";
            SqlCommand cmd = new SqlCommand(queryString, conn);
            SqlDataAdapter adapter = new SqlDataAdapter(cmd);
            DataTable dt = new DataTable();
            adapter.Fill(dt);
            return dt;
        }
    }
}

CacheDependencyDataAdd.aspx

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="CacheDependencyDataAdd.aspx.cs" Inherits="CacheDependencyDataAdd" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
    <title>CacheDependencyDataAdd</title>
</head>
<body>
    <form id="form1" runat="server">
    <div>
        <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" DataKeyNames="id"
            DataSourceID="SqlDataSource1" OnRowUpdated="GridView1_RowUpdated">
            <Columns>
                <asp:CommandField ShowEditButton="True" />
                <asp:BoundField DataField="id" HeaderText="id" InsertVisible="False" ReadOnly="True"
                    SortExpression="id" />
                <asp:BoundField DataField="name" HeaderText="name" SortExpression="name" />
                <asp:BoundField DataField="tel" HeaderText="tel" SortExpression="tel" />
                <asp:BoundField DataField="gender" HeaderText="gender" SortExpression="gender" />
            </Columns>
        </asp:GridView>
        <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:ConnectionString %>"
            SelectCommand="SELECT * FROM [user]" UpdateCommand="UPDATE [user] SET name = @name, tel = @tel, gender = @gender WHERE (id = @id)">
            <UpdateParameters>
                <asp:Parameter Name="name" />
                <asp:Parameter Name="tel" />
                <asp:Parameter Name="gender" />
            </UpdateParameters>
        </asp:SqlDataSource>
   
    </div>
    </form>
</body>
</html>

CacheDependencyDataAdd.aspx.cs

執行如果：

CacheDependencyDemo

CacheDependencyDataAdd

參考網址：

http://www.blueshop.com.tw/board/show.asp?subcde=BRD20080402082116KNJ&fumcde=FUM20041006161839LRJ

http://aspnet.4guysfromrolla.com/articles/121802-1.aspx

posted @ 1:18 PM | Feedback (0)

解決ASP.NET的SqlCommand,利用SqlParameter來下SQL指令"Where In"的問題

前陣子在討論區看到這方面的問題...小弟去測了一下..有以下心得...

資料表內容如下：

一般作法,sql where in字串,全由使用者定義

string queryString = "SELECT id,gender,name FROM [user] Where id in(19,21,24)"; SqlCommand cmd = new SqlCommand(queryString, conn); SqlDataAdapter adapter = new SqlDataAdapter(cmd); DataTable dt = new DataTable(); adapter.Fill(dt); this.GridView1.DataSource = dt; this.GridView1.DataBind();

參數作法,sql where in字串,使用@IdGroup方式,@IdGroup = 19,這樣是正常可以run的

string queryString = "SELECT id,gender,name FROM [user] Where id in(@IdGroup)"; SqlCommand cmd = new SqlCommand(queryString, conn); cmd.Parameters.Add("@IdGroup", "19"); SqlDataAdapter adapter = new SqlDataAdapter(cmd); DataTable dt = new DataTable(); adapter.Fill(dt); this.GridView1.DataSource = dt; this.GridView1.DataBind();

參數作法,sql where in字串,使用@IdGroup方式,@IdGroup = 19,21,24,這樣會產生錯誤

string queryString = "SELECT id,gender,name FROM [user] Where id in(@IdGroup)"; SqlCommand cmd = new SqlCommand(queryString, conn); cmd.Parameters.Add("@IdGroup", "19,21,24"); SqlDataAdapter adapter = new SqlDataAdapter(cmd); DataTable dt = new DataTable(); adapter.Fill(dt); this.GridView1.DataSource = dt; this.GridView1.DataBind();

解決方法,將參數分成多個,例如 where id in(@param1,@param2,@param3),然後設定每一個參數的值

string query = "19,21,24"; string[] param = query.Split(','); string temp = ""; for (int i = 0; i < param.Length; i++) { temp += "@param" + i.ToString() + ","; } string queryString = "SELECT id,gender,name FROM [user] Where id in(" + temp.Substring(0, temp.Length - 1) + ")"; SqlCommand cmd = new SqlCommand(queryString, conn); for (int i = 0; i < param.Length; i++) { cmd.Parameters.Add("@param" + i.ToString(), SqlDbType.Int).Value = param[i]; } SqlDataAdapter adapter = new SqlDataAdapter(cmd); DataTable dt = new DataTable(); adapter.Fill(dt); this.GridView1.DataSource = dt; this.GridView1.DataBind();

執行結果：

posted @ 7:28 PM | Feedback (0)

如何將C#與VB類別共用在同一專案的App_Code裡

最近看到這篇文章..就給它記錄在我的blog裡...

一般一個專案裡的App_Code,如果放.cs 和.vb的類別,在建置網站時會出錯...

如何解決這個問題呢....在Web.config裡面加入下面語法...

完整Web.config如下：

<?xml version="1.0" encoding="utf-8"?>

<configuration>
    <appSettings/>
    <connectionStrings/>
    <system.web>
        
      <compilation debug="false">
        <codeSubDirectories>
          <add directoryName="VB"/>
          <add directoryName="CSharp"/>
        </codeSubDirectories>       
      </compilation>
        
        <authentication mode="Windows" />
        <!--
            <customErrors> 區段可以用來設定
            在執行要求期間發生未處理
            錯誤時所要執行的動作。具體來說，
            它可以讓開發人員設定要顯示的 HTML 錯誤網頁，
            以取代錯誤堆疊追蹤。

然後在App_Code裡再分兩個目錄CSharp和VB,如下圖所示