private void B_button_Click(object sender, EventArgs e)
{
Data_collection_Form1 DCF = new Data_collection_Form1();
DCF.Show();
this.Close();
}
private void C_button_Click(object sender, EventArgs e)
{
SQLiteConnection DBii = new SQLiteConnection("Data Source=C:/Users/Admin/source/repos/Visual_Blood/PDatabase.db3;");
string query = "INSERT INTO PJ_managar(Project_num, Project_name, location, Name) VALUES('" + IDP_textBox.Text + "','" + NP_textBox.Text + "','" + Loca_textBox.Text + "' ,'" + MP_textBox.Text + "')";
SQLiteCommand cmd = new SQLiteCommand(query, DBii);
DBii.Open();
cmd.ExecuteNonQuery();
DBii.Close();
MessageBox.Show("เพิ่มโครงการเรียบร้อย");
Data_collection_Form1 DCF = new Data_collection_Form1();
DCF.Show();
this.Close();
}
private void C_button_Click(object sender, EventArgs e)
{
SQLiteConnection SA = new SQLiteConnection("Data Source=C:/Users/Admin/source/repos/Visual_Blood/PDatabase.db3;");
string query = "INSERT INTO Sa_Table(ID_Project, ID_Customs) VALUES('" + IDP_textBox.Text + "','" + IDC_textBox.Text + "')";
SQLiteCommand Aom = new SQLiteCommand(query, SA);
SA.Open();
Aom.ExecuteNonQuery();
SA.Close();
MessageBox.Show("บันทึกเรียบร้อย");
Data_collection_Form1 DCF = new Data_collection_Form1();
DCF.Show();
this.Close();
}
