ASP.NET C# 非同步程序(多執行緒)寄送郵件 (適合大量郵件)

http://www.dotblogs.com.tw/phoenix7765/archive/2008/11/14/5987.aspx

SQL Statement to combine 2 records into 1 row.

StaffID    Date / Time                     Status
1234       16/07/2008  8:00am         In
1234       16/07/2008  5:00pm        Out
2345       16/07/2008  8:05am        In
2345       16/07/2008  5:00pm        Out

1234       16/07/2008  8:00am         In        16/07/2008  5:00pm Out
2345       16/07/2008  8:05am         In        16/07/2008  5:00pm Out

 

SELECT staffid,
MAX(CASE WHEN status = ‘In’ THEN date_time END) AS
date_time_in,
MAX(CASE WHEN status = ‘Out’ THEN date_time END) AS
date_time_out
FROM Foo
GROUP BY staffid, DATEDIFF(DAY, 0, date_time);

Shink file in SQL Server

Extending jQuery’s selector capabilities

$.extend($.expr[':'],{
    inline: function(a) {
        return $(a).css('display') === 'inline';
    }
});

$(':inline'); // Selects ALL inline elements
$('a:inline'); // Selects ALL inline anchors

Specifying javascript file path on Master pages

<% if (false) {%>
    <!– Don’t wrap this is a Url.Content call, it’s like this so we get intellisense! –>
    <script src=”js/jquery-1.3.2-vsdoc2.js” type=”text/javascript”></script>
    <% } %>
    <script src=”<%= this.ResolveClientUrl(“~/js/jquery-1.3.2.js”) %>” type=”text/javascript”></script>

tgysrtg

gdfgsdffgsdfg

Use Ajax to validate Username from database

Included File:

ShowAjaxValidator.aspx
AjaxValidator.cs
AjaxValidator.js
UsersDB.mdf

Download

Highlight Control thats has validator error

void Page_PreRender()
{
foreach (BaseValidator valControl in Page.Validators)
{
WebControl assControl = (WebControl)Page.FindControl(valControl.ControlToValidate);

if (!valControl.IsValid)
assControl.BackColor = System.Drawing.Color.Yellow;
else
assControl.BackColor = System.Drawing.Color.White;
}
}

Pass array values in query string

use cache…

1.aspx

ArrayList arr = new ArrayList();
arr.Insert(0, “file1″);
arr.Insert(1, “file2″);
arr.Insert(2, “file3″);
Cache["test"] = arr;
arr = null;
Response.Redirect(“2.aspx”);

2.aspx

ArrayList ary = new ArrayList();
ary.Add(Cache["test"]);
Cache.Remove(“test”);

Another way

1.aspx

ArrayList arr = new ArrayList();
arr.Add(“file1″);
arr.Add(“file2″);
arr.Add(“file3″);
string arry = String.Join(“,”, ((string[])arr.ToArray(typeof(String))));
Response.Redirect(“1.aspx?file=” + arry);

2.aspx

string[] files = Request["file"].ToString().Split(‘,’);
ArrayList arry = new ArrayList();
foreach (string file in files)
{
arry.Add(file);
}

[C#]隨機產生驗證圖片

Download Source Code

private void Page_Load(object sender, System.EventArgs e)
{
if(!IsPostBack)
{
createImage(generateCheckCode(5));
}
}