using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using System.Data.OleDb;//**
using System.IO;//**
namespace WindowsFormsApplication3
{
    public partial class Form1 : Form
    {
        private OleDbConnection connection = new OleDbConnection();
        OleDbDataAdapter dAdapter;
        OleDbCommandBuilder cBuilder;
        DataTable dTable = new DataTable();
        BindingSource bSource;
        private string ID;
        public Form1()
        {
            InitializeComponent();
            connection = new OleDbConnection(@"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\Users\student\Desktop\WindowsFormsApplication7\WindowsFormsApplication7\bin\Debug\test1.mdb");
        }
        private void button1_Click(object sender, EventArgs e)
        {
            connection.Open();
            OleDbCommand command2 = new OleDbCommand();
            command2.Connection = connection;
            command2.CommandText = "insert into person (stu_no,name,sex,tel) values('" + textBox1.Text + "','" + textBox2.Text + "','" + textBox3.Text + "','" + textBox4.Text + "')";
            command2.ExecuteNonQuery();
            dAdapter.Fill(dTable);
            connection.Close();
        }
        private void button2_Click(object sender, EventArgs e)
        {
        }
        private void Form1_Load(object sender, EventArgs e)
        {
            dAdapter = new OleDbDataAdapter("select * from person where 識別碼  ", connection);
            cBuilder = new OleDbCommandBuilder(dAdapter);
            dAdapter.Fill(dTable);
            bSource = new BindingSource();
            bSource.DataSource = dTable;
            dataGridView1.DataSource = bSource;
        }
        private void tabPage1_Click(object sender, EventArgs e)
        {
        }
        private void label1_Click(object sender, EventArgs e)
        {
        }
        private void dataGridView1_CellContentClick(object sender, DataGridViewCellEventArgs e)
        {
            if (e.ColumnIndex == 0)
            {
                try
                {
                    var Value = dataGridView1.Rows[e.RowIndex].Cells[e.ColumnIndex].Value;
                    Value = dataGridView1.Rows[e.RowIndex].Cells["name"].Value;
                    connection.Open();
                    OleDbCommand command = new OleDbCommand();
                    command.Connection = connection;
                    string query = "select* from person where name='" + Value.ToString() + "'";
                    command.CommandText = query;
                    OleDbDataReader reader = command.ExecuteReader();
                    while (reader.Read())
                    {
                        ID = reader["識別碼"].ToString();
                        textBox1.Text = reader["stu_no"].ToString();
                        textBox2.Text = reader["name"].ToString();
                        textBox3.Text = reader["sex"].ToString();
                        textBox4.Text = reader["tel"].ToString();
                    }
                    connection.Close();
                }
                catch (Exception ex)
                {
                    MessageBox.Show("ERROR" + ex);
                }
            }
            else if (e.ColumnIndex == 1)
            {
                if (MessageBox.Show("確定刪除此筆資料?", "刪除資料", MessageBoxButtons.YesNo) == DialogResult.Yes)
                {
                    try
                    {
                        var Value = dataGridView1.Rows[e.RowIndex].Cells[e.ColumnIndex].Value;
                        Value = dataGridView1.Rows[e.RowIndex].Cells["name"].Value;
                        connection.Open();
                        OleDbCommand command = new OleDbCommand();
                        command.Connection = connection;
                        command.CommandText = "delete from person WHERE name = '" + Value.ToString() + "'";
                        command.ExecuteNonQuery();
                        dTable.Clear();
                        dAdapter.Fill(dTable);
                        connection.Close();
                        MessageBox.Show("刪除成功");
                    }
                    catch (Exception ex)
                    {
                        MessageBox.Show("ERROR" + ex);
                    }
                }
            }
        }
        private void tabPage2_Click(object sender, EventArgs e)
        {
        }
        private void button2_Click_1(object sender, EventArgs e)
        {
            dTable.Clear();
            connection.Open();
            OleDbCommand command = new OleDbCommand();
            command.Connection = connection;
            command.CommandText = "UPDATE person SET name = '" + textBox1.Text + "'WHERE 識別碼 = " + ID;
            command.ExecuteNonQuery();
            dAdapter.Fill(dTable);
        }
        private void button1_Click_1(object sender, EventArgs e)
        {
            connection.Open();
            OleDbCommand command2 = new OleDbCommand();
            command2.Connection = connection;
            command2.CommandText = "insert into person (stu_no,name,sex,tel) values('" + textBox1.Text + "','" + textBox2.Text + "','" + textBox3.Text + "','" + textBox4.Text + "')";
            command2.ExecuteNonQuery();
            dAdapter.Fill(dTable);
            connection.Close();
              
        }
        private void button2_Click_2(object sender, EventArgs e)
        {
                 dTable.Clear();
                        connection.Open();
                        OleDbCommand command = new OleDbCommand();
                        command.Connection = connection;
                        command.CommandText = "UPDATE person SET name = '" + textBox2.Text + "'WHERE 識別碼 = " + ID ;
                      command.ExecuteNonQuery();
                      dAdapter.Fill(dTable);
        }
        private void label3_Click(object sender, EventArgs e)
        {
        }
        private void label4_Click(object sender, EventArgs e)
        {
        }
    }
}
       
   
2015年12月25日 星期五
2015年12月17日 星期四
猜拳(資料庫失敗)
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
{
public Form1()
{
InitializeComponent();
}
int com = 0;
Random rnd = new Random();
private void Form1_Load(object sender, EventArgs e)
{
textBox1.ReadOnly = true;
}
private void textBox1_TextChanged(object sender, EventArgs e)
{
}
private void button1_Click(object sender, EventArgs e)
{
com = rnd.Next(1, 4);
if (com == 1)
textBox1.Text = "電腦出剪刀,平手";
else if (com == 2)
textBox1.Text = " 電腦出石頭,lose";
else if (com == 3)
textBox1.Text = "電腦出布,win";
}
private void button2_Click(object sender, EventArgs e)
{
com = rnd.Next(1, 4);
if (com == 1)
textBox1.Text = "電腦出剪刀,win";
else if (com == 2)
textBox1.Text = " 電腦出石頭,平手";
else if (com == 3)
textBox1.Text = "電腦出布,lose";
}
private void button3_Click(object sender, EventArgs e)
{
com = rnd.Next(1, 4);
if (com == 1)
textBox1.Text = "電腦出剪刀,lose";
else if (com == 2)
textBox1.Text = " 電腦出石頭,win";
else if (com == 3)
textBox1.Text = "電腦出布,平手";
}
private void bindingSource1_CurrentChanged(object sender, EventArgs e)
{
}
private void dataGridView1_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
}
}
}
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
{
public Form1()
{
InitializeComponent();
}
int com = 0;
Random rnd = new Random();
private void Form1_Load(object sender, EventArgs e)
{
textBox1.ReadOnly = true;
}
private void textBox1_TextChanged(object sender, EventArgs e)
{
}
private void button1_Click(object sender, EventArgs e)
{
com = rnd.Next(1, 4);
if (com == 1)
textBox1.Text = "電腦出剪刀,平手";
else if (com == 2)
textBox1.Text = " 電腦出石頭,lose";
else if (com == 3)
textBox1.Text = "電腦出布,win";
}
private void button2_Click(object sender, EventArgs e)
{
com = rnd.Next(1, 4);
if (com == 1)
textBox1.Text = "電腦出剪刀,win";
else if (com == 2)
textBox1.Text = " 電腦出石頭,平手";
else if (com == 3)
textBox1.Text = "電腦出布,lose";
}
private void button3_Click(object sender, EventArgs e)
{
com = rnd.Next(1, 4);
if (com == 1)
textBox1.Text = "電腦出剪刀,lose";
else if (com == 2)
textBox1.Text = " 電腦出石頭,win";
else if (com == 3)
textBox1.Text = "電腦出布,平手";
}
private void bindingSource1_CurrentChanged(object sender, EventArgs e)
{
}
private void dataGridView1_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
}
}
}
2015年12月11日 星期五
資料庫
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[] array = new int[4];
public Form1()
{
InitializeComponent();
textBox1.DataBindings.Add("Text", bindingSource3, "name");
textBox2.DataBindings.Add("Text", bindingSource3, "math");
}
private void Form1_Load(object sender, EventArgs e)
{
// TODO: 這行程式碼會將資料載入 'db1DataSet.DataTable1' 資料表。您可以視需要進行移動或移除。
this.dataTable1TableAdapter.Fill(this.db1DataSet.DataTable1);
// TODO: 這行程式碼會將資料載入 'db1DataSet.tb1' 資料表。您可以視需要進行移動或移除。
this.tb1TableAdapter.Fill(this.db1DataSet.tb1);
// TODO: 這行程式碼會將資料載入 'db1DataSet.record' 資料表。您可以視需要進行移動或移除。
this.recordTableAdapter.Fill(this.db1DataSet.record);
// TODO: 這行程式碼會將資料載入 'db1DataSet.person' 資料表。您可以視需要進行移動或移除。
this.personTableAdapter.Fill(this.db1DataSet.person);
}
private void bindingNavigator2_RefreshItems(object sender, EventArgs e)
{
}
private void tabPage4_Click(object sender, EventArgs e)
{
}
}
}
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[] array = new int[4];
public Form1()
{
InitializeComponent();
textBox1.DataBindings.Add("Text", bindingSource3, "name");
textBox2.DataBindings.Add("Text", bindingSource3, "math");
}
private void Form1_Load(object sender, EventArgs e)
{
// TODO: 這行程式碼會將資料載入 'db1DataSet.DataTable1' 資料表。您可以視需要進行移動或移除。
this.dataTable1TableAdapter.Fill(this.db1DataSet.DataTable1);
// TODO: 這行程式碼會將資料載入 'db1DataSet.tb1' 資料表。您可以視需要進行移動或移除。
this.tb1TableAdapter.Fill(this.db1DataSet.tb1);
// TODO: 這行程式碼會將資料載入 'db1DataSet.record' 資料表。您可以視需要進行移動或移除。
this.recordTableAdapter.Fill(this.db1DataSet.record);
// TODO: 這行程式碼會將資料載入 'db1DataSet.person' 資料表。您可以視需要進行移動或移除。
this.personTableAdapter.Fill(this.db1DataSet.person);
}
private void bindingNavigator2_RefreshItems(object sender, EventArgs e)
{
}
private void tabPage4_Click(object sender, EventArgs e)
{
}
}
}
2015年11月5日 星期四
文字型計算機
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
{
public Form1()
{
InitializeComponent();
}
private void label2_Click(object sender, EventArgs e)
{
}
private void Form1_Load(object sender, EventArgs e)
{
}
private void label3_Click(object sender, EventArgs e)
{
}
private void textBox1_TextChanged(object sender, EventArgs e)
{
   
}
private void button3_Click(object sender, EventArgs e)
{
Double a = Double.Parse(textBox1.Text);
Double b = Double.Parse(textBox2.Text);
double c = a * b;
label2.Text = c.ToString();
}
private void button1_Click(object sender, EventArgs e)
{
Double a = Double.Parse(textBox1.Text);
Double b = Double.Parse(textBox2.Text);
double c = a + b;
label2.Text = c.ToString();
           
        
}
private void button2_Click(object sender, EventArgs e)
{
Double a = Double.Parse(textBox1.Text);
Double b = Double.Parse(textBox2.Text);
double c = a - b;
label2.Text = c.ToString();
}
private void button4_Click(object sender, EventArgs e)
{
Double a = Double.Parse(textBox1.Text);
Double b = Double.Parse(textBox2.Text);
double c = a / b;
label2.Text = c.ToString();
}
}
}
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
{
public Form1()
{
InitializeComponent();
}
private void label2_Click(object sender, EventArgs e)
{
}
private void Form1_Load(object sender, EventArgs e)
{
}
private void label3_Click(object sender, EventArgs e)
{
}
private void textBox1_TextChanged(object sender, EventArgs e)
{
}
private void button3_Click(object sender, EventArgs e)
{
Double a = Double.Parse(textBox1.Text);
Double b = Double.Parse(textBox2.Text);
double c = a * b;
label2.Text = c.ToString();
}
private void button1_Click(object sender, EventArgs e)
{
Double a = Double.Parse(textBox1.Text);
Double b = Double.Parse(textBox2.Text);
double c = a + b;
label2.Text = c.ToString();
}
private void button2_Click(object sender, EventArgs e)
{
Double a = Double.Parse(textBox1.Text);
Double b = Double.Parse(textBox2.Text);
double c = a - b;
label2.Text = c.ToString();
}
private void button4_Click(object sender, EventArgs e)
{
Double a = Double.Parse(textBox1.Text);
Double b = Double.Parse(textBox2.Text);
double c = a / b;
label2.Text = c.ToString();
}
}
}
2015年10月30日 星期五
數字圖
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
{
Button[,] Buttons = new System.Windows.Forms.Button[5, 5];
int r = 0;
public Form1()
{
InitializeComponent();
}
private void Form1_Load(object sender, EventArgs e)
{
for (int j = 1; j < 5; j++)
{
for (int i = 1; i < 5; i++)
{
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 timer1_Tick(object sender, EventArgs e)
{
}
private void button1_Click(object sender, EventArgs e)
{
Random r2 = new Random();
           
for (int i = 1; i < 5; i++)
{
for (int j = 1; j < 5; j++)
{
r = r2.Next(0, 15);
Buttons[i, j].Text = r.ToString();
}
}
}
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
{
Button[,] Buttons = new System.Windows.Forms.Button[5, 5];
int r = 0;
public Form1()
{
InitializeComponent();
}
private void Form1_Load(object sender, EventArgs e)
{
for (int j = 1; j < 5; j++)
{
for (int i = 1; i < 5; i++)
{
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 timer1_Tick(object sender, EventArgs e)
{
}
private void button1_Click(object sender, EventArgs e)
{
Random r2 = new Random();
for (int i = 1; i < 5; i++)
{
for (int j = 1; j < 5; j++)
{
r = r2.Next(0, 15);
Buttons[i, j].Text = r.ToString();
}
}
}
2015年10月2日 星期五
3顏色
程式設計工藝大師
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, d;
public Form1()
{
InitializeComponent();
}
private void Form1_Load(object sender, EventArgs e)
{
}
private void button1_Click(object sender, EventArgs e)
{
}
private void timer1_Tick(object sender, EventArgs e)
{
c = c + 1;
d = c % 3;
if (d == 0)
{
button1.BackColor=System.Drawing.Color.FromName("Green");
}
else
{
button1.BackColor = System.Drawing.Color.FromName("White");
}
if (d == 1)
{
button2.BackColor = System.Drawing.Color.FromName("Yellow");
}
else
{
button2.BackColor = System.Drawing.Color.FromName("White");
if (d == 2)
{
button3.BackColor = System.Drawing.Color.FromName("Red");
}
else
{
button3.BackColor = System.Drawing.Color.FromName("White");
}
}
}
private void button3_Click(object sender, EventArgs e)
{
}
private void button3_Click_1(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 x, y, c = 0, d;
public Form1()
{
InitializeComponent();
}
private void Form1_Load(object sender, EventArgs e)
{
}
private void button1_Click(object sender, EventArgs e)
{
}
private void timer1_Tick(object sender, EventArgs e)
{
c = c + 1;
d = c % 3;
if (d == 0)
{
button1.BackColor=System.Drawing.Color.FromName("Green");
}
else
{
button1.BackColor = System.Drawing.Color.FromName("White");
}
if (d == 1)
{
button2.BackColor = System.Drawing.Color.FromName("Yellow");
}
else
{
button2.BackColor = System.Drawing.Color.FromName("White");
if (d == 2)
{
button3.BackColor = System.Drawing.Color.FromName("Red");
}
else
{
button3.BackColor = System.Drawing.Color.FromName("White");
}
}
}
private void button3_Click(object sender, EventArgs e)
{
}
private void button3_Click_1(object sender, EventArgs e)
{
}
}
}
訂閱:
意見 (Atom)
 


