12月25日資料庫程式考試

3D列印

https://drive.google.com/file/d/0B6MDH142JdNVRVpzeEN5eEwyYVE/view?usp=sharing

程式設計：PHP
資料庫：MySQL
網頁排版：HTML、CSS
其他技術：jQuery、Ajax、OOP、Lavarel

職務類別：: 軟體設計工程師、Internet程式設計師
工作待遇：: 月薪 3萬5仟元至 8萬元

推盤遊戲

http://tccnchsu.blogspot.tw/2014/09/blog-post.html

The Amazing iPad Magician

#小姑娘火了【11岁女孩唱《天亮了》，在场所有人都听哭了！】

從頭再來用心唱的才能打動人心破產千萬富翁——高逸峰

潇洒走一回
朋友別哭～原唱：呂方
金鷹 you raise me up

天籟之音 you raise me up

經典經典 - RELAX MUSIC, RELAXING, MUSICA RELAX, RELAJANTE, 舒緩，輕鬆的音樂，音樂

Love paradise (陳慧琳) 鋼琴 Jason Piano

凱文柯恩 - 綠鋼琴

梁植《“笨”向未来》1

You Raise Me Up 你鼓舞了我 ...中文字幕英語詩歌福音版

08年奧運舉重冠軍施泰納令人感動的故事

大愛電視大愛劇場一閃一閃亮晶晶片花

路要自己走(《一閃一閃亮晶晶》主題曲)

====================================================================

[網站架設] 用電腦架設網站！XAMPP 安裝教學 (Windows篇)

如何利用phpMyAdmin建立MySQL資料庫與設計？

Excel匯入MySQL

以下介紹兩種Excel資料放到MySQL的方式，但不管那一種方式，最重要的都是要注意Excel資料的編碼，與MySQL資料表的編碼，避免轉到資料庫後，變成亂碼。

=====================================================
期末考

1. 2007access連線套件
2. 下載程式，執行程式 (示範加入資料庫)
3. 下載資料庫，更換資料庫

=====================================================================
資料更新

try
{
bindingSource1.EndEdit();
personTableAdapter.Update(db1DataSet);

MessageBox.Show("資料更新成功");
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}

新增

try

{

bindingSource1.AddNew();

}

catch (Exception ex)

{

MessageBox.Show(ex.Message);

}

=======================================================================

將文字方塊寫入資料表

// If you are not at the end of the list, move to the next item
// in the BindingSource.
if (bindingSource1.Position + 1 < bindingSource1.Count)
bindingSource1.MoveNext();

// Otherwise, move back to the first item.
else
bindingSource1.MoveFirst();

// Force the form to repaint.
this.Invalidate();
textBox1.DataBindings.Add("Text", bindingSource1, "name",true);
textBox1.Text = "1234";
textBox1.DataBindings[0].WriteValue();

textBox1.DataBindings.Clear();

==============================================

db1 投影片

======================================================================

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;

namespace WindowsFormsApplication2

{

public partial class Form1 : Form

{

int[] array = new int[4];

float mysum1=0;

public Form1()

{

InitializeComponent();

textBox1.DataBindings.Add("Text", bindingSource3, "name", true);

textBox2.DataBindings.Add("Text", bindingSource3, "math", true);

bindingSource3.AllowEdit.Equals(false);

array[0] = 0;

array[1] = 0;

array[2] = 0;

array[3] = 0;

}

private void Form1_Load(object sender, EventArgs e)

{

// TODO: 這行程式碼會將資料載入 'db1DataSet.DataTable1' 資料表。您可以視需要進行移動或移除。

this.dataTable1TableAdapter.Fill(this.db1DataSet.DataTable1);

// TODO: 這行程式碼會將資料載入 'db1DataSet.record' 資料表。您可以視需要進行移動或移除。

this.recordTableAdapter.Fill(this.db1DataSet.record);

// TODO: 這行程式碼會將資料載入 'db1DataSet.person' 資料表。您可以視需要進行移動或移除。

this.personTableAdapter.Fill(this.db1DataSet.person);

}

private void button1_Click(object sender, EventArgs e)

{

bindingSource3.MoveFirst();

}

private void button2_Click(object sender, EventArgs e)

{

bindingSource3.MoveNext();

}

private void button3_Click(object sender, EventArgs e)

{

String mstring;

int bn;

for (int i = 0; i < 3; i++)

{

array[i] = Int32.Parse(textBox2.Text);

bindingSource3.MoveNext();

}

for (int i = 0; i < 3; i++)

{

mysum1 = mysum1+array[i];

}

bn=bindingSource3.Count;

mysum1 = mysum1 / bn;

mstring = mysum1.ToString();

textBox3.Text = mstring;

}

=======================================================================

開啟 Dataset1

加關聯

加入tableadapter

開啟sql視窗

TextBox in Windows Forms

Working With a BindingNavigator Control in Windows Form

文字方塊

加BINDINGSOURCE

//https://msdn.microsoft.com/zh-tw/library/2wcswths(v=vs.110).aspx

textBox1.DataBindings.Add("Text", bindingSource1, "name");

textBox1.DataBindings.Clear();

BindingNavigator Control Overview (Windows Forms)

BindingSource.MoveNext Method ()

BindingNavigator.MoveNextItem Property

程式碼

// If you are not at the end of the list, move to the next item

// in the BindingSource.

if (bindingSource1.Position + 1 < bindingSource1.Count)

bindingSource1.MoveNext();

// Otherwise, move back to the first item.

else

bindingSource1.MoveFirst();

// Force the form to repaint.

this.Invalidate();

textBox1.DataBindings.Add("Text", bindingSource1, "name");

textBox1.DataBindings.Clear();

=====================================================================

第一週

1. 嚮往的未來生活?
2. 選修物件導向課程的動機?
3. 希望獲得的成果?
4. 抄"我什麼都會"21次!
5. 抄"不放棄"21次!
6. 抄"盡全力"21次!
7. 抄"靠自己"21次!

=======================================================================

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;

namespace WindowsFormsApplication3

{

public partial class Form1 : Form

{

int x, y,c=0;

public Form1()

{

InitializeComponent();

}

private void Form1_Load(object sender, EventArgs e)

{

}

private void button1_Click(object sender, EventArgs e)

{

c=c+1;

x= 10*c;

// y= 10*c;

pictureBox1.Location = new Point(x, y);

}

=======================================================================

=====================================================================

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;

namespace WindowsFormsApplication1
{
public partial class Form1 : Form
{
int x, y,c=0,fx=0,fy=0;
public Form1()
{
InitializeComponent();
}

private void Form1_Load(object sender, EventArgs e)
{
pictureBox1.Location = new Point(100, 100);
}

private void button1_Click(object sender, EventArgs e)
{

/*
if (condition)
{
pictureBox1.Location = new Point(0, 0);
}
else
{
pictureBox1.Location = new Point(100, 100);
}
*/

}

private void timer1_Tick(object sender, EventArgs e)
{
bool condition = false;

if (x >= 500) fx = 1;
if (x <= -1) fx = 0;
if (y >= 300) fy = 1;
if (y <= -1) fy = 0;

button1.Text = x.ToString();
button2.Text = y.ToString();
if (fx == 1 && fy==1)
{
c = c - 100;
}
else if (fx == 1 && fy==0)
{
c = c + 100;
}
else if (fx == 0 && fy == 1)
{
c = c + 100;
}
else if (fx == 0 && fy == 0)
{
c = c + 100;
}

x = c;
y = c;

pictureBox1.Location = new Point(x, y);
}

private void button2_Click(object sender, EventArgs e)
{

}
}
}

=======================================================================

第三週

=======================================
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;

namespace WindowsFormsApplication1
{
public partial class Form1 : Form
{
int c = 0,d=0;
public Form1()
{
InitializeComponent();
}

private void button1_Click(object sender, EventArgs e)
{

}

private void timer1_Tick(object sender, EventArgs e)
{
c = c + 1;
d = c % 3;
button1.Text = d.ToString();
}
}
}
=========================================
拉霸吃角子老虎玩法

水果盤

=======================================================================

======================================================================

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;

namespace WindowsFormsApplication1
{
public partial class Form1 : Form
{
int c1 = 0,d1=0;
int c2 = 0, d2 = 0;
int c3= 0, d3 = 0;
int rndmoney1=100;
int rndmoney2 = 100;
int rndmoney3 = 100;
public Form1()
{
InitializeComponent();
}

private void button1_Click(object sender, EventArgs e)
{

}

private void timer1_Tick(object sender, EventArgs e)
{

c1 = c1 + 1;
d1 = c1 % 10;

if (c1 >= rndmoney1) timer1.Enabled = false;

if (d1==0)
{
//button1.BackColor = Color.Green;
}
else if (d1 == 1)
{
//button1.BackColor = Color.Black;
}
else if (d1 == 2)
{
//button1.BackColor = Color.Black;
}
button1.Text = d1.ToString();
}

private void button4_Click(object sender, EventArgs e)
{
c1 = 0;
c2 = 0;
c3 = 0;
timer1.Enabled = true;
timer2.Enabled = true;
timer3.Enabled = true;
Random rnd = new Random();
rndmoney1 = rnd.Next(1, 101); // creates a number between 1 and 12
rndmoney2 = rnd.Next(1, 101); // creates a number between 1 and 12
rndmoney3 = rnd.Next(1, 101); // creates a number between 1 and 12
button4.Text = rndmoney1.ToString() + rndmoney2.ToString() + rndmoney3.ToString();

}

private void timer2_Tick(object sender, EventArgs e)
{
c2 = c2 + 1;
d2 = c2 % 10;

if (c2 >= rndmoney2) timer2.Enabled = false;

if (d2 == 0)
{
//button1.BackColor = Color.Green;
}
else if (d2 == 1)
{
//button1.BackColor = Color.Black;
}
else if (d2 == 2)
{
//button1.BackColor = Color.Black;
}
button2.Text = d2.ToString();
}

private void timer3_Tick(object sender, EventArgs e)
{
c3 = c3 + 1;
d3 = c3 % 10;

if (c3 >= rndmoney3) timer3.Enabled = false;

if (d3 == 0)
{
//button1.BackColor = Color.Green;
}
else if (d3== 1)
{
//button1.BackColor = Color.Black;
}
else if (d3 == 2)
{
//button1.BackColor = Color.Black;
}
button3.Text = d3.ToString();
}
}
}

======================================================================

fruit cartoon png

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

=======================================================================
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;

namespace WindowsFormsApplication1
{
public partial class Form1 : Form
{
int rndmoney1 = 0;
int rndmoney2 = 0;
int rndmoney3 = 0;
int rndmoney4 = 0;
int rndmoney5 = 0;
int rndmoney6 = 0;
int rndmoney7 = 0;
int rndmoney8 = 0;
int rndmoney9 = 0;
public Form1()
{
InitializeComponent();
button1.Enabled = false;
button2.Enabled = false;
button3.Enabled = false;
button4.Enabled = false;
button5.Enabled = false;
button6.Enabled = false;
button7.Enabled = false;
button8.Enabled = false;
button9.Enabled = false;
}

private void button10_Click(object sender, EventArgs e)
{
Random rnd = new Random();
rndmoney1 = rnd.Next(0, 9); // creates a number between 1 and 9

rndmoney2 = rnd.Next(0, 9); // creates a number between 1 and 9
//rndmoney3 = rnd.Next(0, 9); // creates a number between 1 and 9
//rndmoney4 = rnd.Next(0, 10); // creates a number between 1 and 9
//rndmoney5 = rnd.Next(0, 10); // creates a number between 1 and 9
//rndmoney6 = rnd.Next(0, 10); // creates a number between 1 and 9
//rndmoney7 = rnd.Next(0, 10); // creates a number between 1 and 9
//rndmoney8 = rnd.Next(0, 10); // creates a number between 1 and 9
//rndmoney9 = rnd.Next(0, 10); // creates a number between 1 and 9
button1.Text = rndmoney1.ToString();
button2.Text = rndmoney2.ToString();
if (rndmoney1 == rndmoney2)
{
MessageBox.Show("Dot Net Perls is awesome.");
rndmoney2 = rnd.Next(0, 9); // creates a number between 1 and 9
button2.Text = rndmoney2.ToString();
}
//button3.Text = rndmoney3.ToString();
//button4.Text = rndmoney4.ToString();
//button5.Text = rndmoney5.ToString();
//button6.Text = rndmoney6.ToString();
//button7.Text = rndmoney7.ToString();
//button8.Text = rndmoney8.ToString();
//button9.Text = rndmoney9.ToString();
//button10.Enabled = false;
}
}
}
=======================================================================
陣列按鈕

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;

namespace WindowsFormsApplication2
{
public partial class Form1 : Form
{
Button[,] Buttons = new System.Windows.Forms.Button[5, 5];

public Form1()
{
InitializeComponent();
}

private void Form1_Load(object sender, EventArgs e)
{
for (int i = 1; i < 5; i++)
{
for (int j = 1; j < 5; j++)
{

Buttons[i, j] = new Button();
Buttons[i, j].Size = new Size(50, 50);
Buttons[i, j].Location = new Point(i * 50, j * 50);
this.Controls.Add(Buttons[i, j]);//出現在畫面中
}
}

}

private void button1_Click(object sender, EventArgs e)
{
int pro=0;
for (int i = 1; i < 5; i++)
{
for (int j = 1; j < 5; j++)
{
pro = i * j;
Buttons[i, j].Text =pro.ToString();
}
}

}
}
}

============================================

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;

namespace WindowsFormsApplication1
{
public partial class Form1 : Form
{
public Form1()
{
InitializeComponent();
}

private void button1_Click(object sender, EventArgs e)
{
String b1,b2;
b1 = textBox1.Text;
b2=textBox2.Text;
float numVal1 = float.Parse(b1);
float numVal2 = float.Parse(b2);
float numsum = numVal1 + numVal2;
label2.Text = numsum.ToString();
}

private void label2_Click(object sender, EventArgs e)
{

}
}
}

=========================================================================