private void mainCategoryMasterButton_Click(object sender, EventArgs e) { MainCategoryMaster mainCategory = new MainCategoryMaster(this); this.Hide(); mainCategory.Show(); }
private void addButton_Click(object sender, EventArgs e) { DialogResult result = MessageBox.Show("登録をしますか?", "確認", MessageBoxButtons.YesNo); if (result == DialogResult.Yes) { NpgsqlCommandBuilder builder; int mainCode = int.Parse(mainCategoryCodeTextBox.Text); //大分類コード string mainName = mainCategoryNameTextBox.Text; //大分類名 string sql_str = "insert into main_category_m values(" + mainCode + ",'" + mainName + "');"; conn.ConnectionString = @"Server = localhost; Port = 5432; User Id = postgres; Password = postgres; Database = master;"; //変更予定 conn.Open(); adapter = new NpgsqlDataAdapter(sql_str, conn); builder = new NpgsqlCommandBuilder(adapter); adapter.Fill(dt); adapter.Update(dt); conn.Close(); MessageBox.Show("登録完了"); MainCategoryMaster mainCategory = new MainCategoryMaster(master); this.Close(); mainCategory.Show(); } else { } }
private void updateButton_Click(object sender, EventArgs e) { DialogResult result = MessageBox.Show("更新をしますか?", "確認", MessageBoxButtons.YesNo); if (result == DialogResult.Yes) { NpgsqlConnection conn = new NpgsqlConnection(); NpgsqlDataAdapter adapter; NpgsqlCommandBuilder builder; DataTable dt = new DataTable(); string mainName = mainCategoryNameTextBox.Text; conn.ConnectionString = @"Server = 192.168.152.43; Port = 5432; User Id = postgres; Password = postgres; Database = master;"; //変更予定 conn.Open(); string sql_str = "update main_category_m set main_category_name = '" + mainName + "' where main_category_code = " + mainCode + ";"; adapter = new NpgsqlDataAdapter(sql_str, conn); builder = new NpgsqlCommandBuilder(adapter); adapter.Fill(dt); adapter.Update(dt); MessageBox.Show("更新完了"); conn.Close(); MainCategoryMaster mainCategory = new MainCategoryMaster(master); this.Close(); mainCategory.Show(); } else { } }
private void returnButton_Click(object sender, EventArgs e) { MainCategoryMaster mainCategory = new MainCategoryMaster(master); this.Close(); mainCategory.Show(); }
private void removeButton_Click(object sender, EventArgs e) { DialogResult result = MessageBox.Show("削除しますか?", "確認", MessageBoxButtons.YesNo); if (result == DialogResult.Yes) { NpgsqlConnection conn = new NpgsqlConnection(); NpgsqlDataAdapter adapter; NpgsqlCommandBuilder builder; conn.ConnectionString = @"Server = 192.168.152.43; Port = 5432; User Id = postgres; Password = postgres; Database = master;"; //変更予定 string sql_str = "delete from main_category_m where main_category_code = " + mainCode + ""; conn.Open(); adapter = new NpgsqlDataAdapter(sql_str, conn); builder = new NpgsqlCommandBuilder(adapter); adapter.Fill(dt); adapter.Update(dt); MessageBox.Show("削除完了"); conn.Close(); MainCategoryMaster mainCategory = new MainCategoryMaster(master); this.Close(); master.Show(); } else { } }