Skip to content

Instantly share code, notes, and snippets.

View tedliou's full-sized avatar

Ted Liou tedliou

10 followers · 7 following
View GitHub Profile
@tedliou
tedliou / 【Visual C#】九九乘法程式設計示範
Created October 24, 2015 01:41
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;
@tedliou
tedliou / 【Visual C#】使用 Random 方法產生不重複亂數
Last active March 30, 2022 07:00
使用Random方法，產生多組亂數值並不重複，存到陣列中，並在控制項中顯示出來。
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;
@tedliou
tedliou / 【Visual C#】樂透五星彩模擬器
Last active November 1, 2015 13:15
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;
@tedliou
tedliou / 【Discuz！x3.2 小技巧】移除網站Title後綴「Powered by Discuz!」
Created November 2, 2015 11:44
<title><!--{if !empty($navtitle)}-->$navtitle - <!--{/if}--><!--{if empty($nobbname)}--> $_G['setting']['bbname'] - <!--{/if}--> Powered by Discuz!</title>
@tedliou
tedliou / 【Discuz！x3.2 小技巧】移除網站Title後綴「Powered by Discuz!」
Created November 2, 2015 11:47
<title><!--{if !empty($navtitle)}-->$navtitle<!--{/if}--><!--{if empty($nobbname)}--> $_G['setting']['bbname']<!--{/if}--></title>
@tedliou
tedliou / gist:8dc0885c67763235323d
Created November 15, 2015 07:10
string cmdsql = "INSERT INTO [dbo].[ttt] ([yn], [gn], [an], [sc], [am]) VALUES (11, 12, 13, 14, 15)";
SqlConnection sql = new SqlConnection(@"Data Source=(LocalDB)\v11.0;AttachDbFilename=|DataDirectory|\bin\Debug\liusql.mdf;Integrated Security=True;Connect Timeout=30");
SqlCommand cmd = new SqlCommand(cmdsql, sql);
sql.Open();
cmd.ExecuteNonQuery();
sql.Close();
@tedliou
tedliou / 【Visual C#】連線本機SQL Server
Created December 12, 2015 08:23
//資料庫
string cmdsql = "SQL指令";
SqlConnection sql = new SqlConnection(@"Data Source=(LocalDB)\v11.0;AttachDbFilename=|DataDirectory|\資料庫名稱.mdf;Integrated Security=True;Connect Timeout=30");
SqlCommand cmd = new SqlCommand(cmdsql, sql);
sql.Open();
cmd.ExecuteNonQuery();
sql.Close();
@tedliou
tedliou / gist:0722b119214d882743be
Created December 12, 2015 09:46
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;
using System.Data.SqlClient;
@tedliou
tedliou / ADD SQL.cs
Last active April 6, 2016 15:28
string cmdsql = "INSERT INTO [Table] (test) VALUES ('"+textBox1.Text+"')";
SqlConnection sql = new SqlConnection(@"Data Source=(LocalDB)\v11.0;AttachDbFilename=|DataDirectory|\Database1.mdf;Integrated Security=True;Connect Timeout=30");
SqlCommand cmd = new SqlCommand(cmdsql, sql);
sql.Open();
cmd.ExecuteNonQuery();
sql.Close();
@tedliou
tedliou / DELETE SQL.cs
Last active April 6, 2016 15:27
SqlConnection sql = new SqlConnection(@"Data Source=(LocalDB)\v11.0;AttachDbFilename=|DataDirectory|\Database1.mdf;Integrated Security=True;Connect Timeout=30");
SqlCommand cmd = new SqlCommand("delete from [Table]", sql);
sql.Open();
cmd.ExecuteNonQuery();
sql.Close();
listView1.Items.Clear();