String num;
OleDbConnection conn = new OleDbConnection(@"Provider=Microsoft.ACE.Oledb.12.0;Data source=D:\\C4160\\C4160.accdb;");
OleDbCommand cmd = new OleDbCommand();
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();
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();
}
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();
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();
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();
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();