之前想要讓 檢視表(View) 可以代入參數，找到了一個替代方案：資料表值函式
CREATE FUNCTION TestFunction(@year nvarchar(3),sid nvarchar(10))
RETURNS TABLE
AS
RETURN
- Sep 16 Sat 2017 11:02
-
SQL資料表值函式
- Sep 16 Sat 2017 10:27
-
asp.net smtp 使用微軟O365寄Email
public void sendmail(string mailto, string mailfrom, string mailbcc, string mailsub, string mailbody)
{
MailMessage mail = new MailMessage();
string[] to = mailto.Trim().Split(",".ToCharArray());
foreach (string reciver in to)
- Aug 29 Mon 2011 13:48
-
gridview 顯示rss資訊
以下以yahoo新聞的rss做示範
gridview
<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False"
EnableModelValidation="True">
<Columns>
- Aug 29 Mon 2011 13:04
-
將gridview匯出為excel
gridview匯出為excel
是上班後第一遇到的訴求，也是之後常常聽到的要求功能之一
Protected Sub Button1_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim sw As New System.IO.StringWriter
Dim hw As New System.Web.UI.HtmlTextWriter(sw)
1
