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(); }