ภาระง

Source Code

คำสั่งติดต่อฐานข้อมูล

String num;

OleDbConnection conn = new OleDbConnection(@"Provider=Microsoft.ACE.Oledb.12.0;Data source=D:\\C4160\\C4160.accdb;");

OleDbCommand cmd = new OleDbCommand();

คำสั่ง appointment_Load

cmd.Connection = conn;

conn.Open();

string sql = "select * from appointment";

OleDbDataAdapter da = new OleDbDataAdapter(sql, conn);

DataTable dt = new DataTable();

da.Fill(dt);

dataGridView1.DataSource = dt;

conn.Close();

คำสั่ง INSERT (เพิ่ม)

i

if (textBox1.Text != "" & textBox2.Text != "" & textBox3.Text != "" & textBox4.Text != "")

{

conn.Open();

cmd.CommandText = "insert into Appointment ([appid],[cusid],[objective],[appdate]) values ('" + textBox1.Text + "','" + textBox2.Text + "','" + textBox3.Text + "','" + textBox4.Text + "') ";

cmd.ExecuteNonQuery();

cmd.Clone();

textBox1.Text = "";

textBox2.Text = "";

textBox3.Text = "";

textBox4.Text = "";

conn.Close();

}

คำสั่ง DELETE (ลบ)

conn.Open();

cmd.CommandText = "delete from Appointment where [appid] ='" + textBox1.Text + "'";

cmd.ExecuteNonQuery();

String sql = "select * from Appointment ";

OleDbDataAdapter da = new OleDbDataAdapter(sql, conn);

DataTable dt = new DataTable();

da.Fill(dt);

dataGridView1.DataSource = dt;

cmd.Clone();

textBox1.Text = "";

textBox2.Text = "";

textBox3.Text = "";

textBox4.Text = "";

conn.Close();

คำสั่ง EDIT (แก้ไข)

conn.Open();

cmd.CommandText = "update appointment set [appid] = '" + textBox1.Text + "' , [cusid] = '" + textBox2.Text + "', [objective] ='" + textBox3.Text + "' , [appdate] ='" + textBox4.Text + "' where id = " + num;

cmd.ExecuteNonQuery();

String sql = "select * from appointment ";

OleDbDataAdapter da = new OleDbDataAdapter(sql, conn);

DataTable dt = new DataTable();

da.Fill(dt);

dataGridView1.DataSource = dt;

cmd.Clone();

textBox1.Text = "";

textBox2.Text = "";

textBox3.Text = "";

textBox4.Text = "";

conn.Close();

คำสั่ง UPDATE (บันทึก)

conn.Open();

cmd.CommandText = "update appointment set [appid] = '" + textBox1.Text + "' , [cusid] = '" + textBox2.Text + "', [objective] ='" + textBox3.Text + "' , [appdate] ='" + textBox4.Text + "' where id = " + num;

cmd.ExecuteNonQuery();

String sql = "select * from appointment ";

OleDbDataAdapter da = new OleDbDataAdapter(sql, conn);

DataTable dt = new DataTable();

da.Fill(dt);

dataGridView1.DataSource = dt;

cmd.Clone();

textBox1.Text = "";

textBox2.Text = "";

textBox3.Text = "";

textBox4.Text = "";

conn.Close();

คำสั้่ง VIEW (VIEW)

cmd.Connection = conn;

conn.Open();

string sql = "select * from appointment";

OleDbDataAdapter da = new OleDbDataAdapter(sql, conn);

DataTable dt = new DataTable();

da.Fill(dt);

dataGridView1.DataSource = dt;

conn.Close();

คำสั่ง dataGridView1_CellMouseClick_1

textBox1.Text = dataGridView1.SelectedRows[0].Cells[1].Value.ToString();

textBox2.Text = dataGridView1.SelectedRows[0].Cells[2].Value.ToString();

textBox3.Text = dataGridView1.SelectedRows[0].Cells[3].Value.ToString();

textBox4.Text = dataGridView1.SelectedRows[0].Cells[4].Value.ToString();

num = dataGridView1.SelectedRows[0].Cells[0].Value.ToString();