private void Expenditure_Type_Load(object sender, EventArgs e) { FormBorderStyle = FormBorderStyle.None; WindowState = FormWindowState.Maximized; TopMost = false; dataGridView1.ColumnHeadersDefaultCellStyle.Font = new Font("Arial", 10); dataGridView1.SelectionMode = DataGridViewSelectionMode.FullRowSelect; ExpenditureTypedb extdb = new ExpenditureTypedb(); dataGridView1.DataSource = extdb.selectall(); }
private void button5_Click(object sender, EventArgs e) { //int id = (int)dataGridView1.SelectedRows[0].Cells[0].Value; String ids = textBox5.Text; int id = int.Parse(ids); exdb.delete(id); exdb.selectall(); this.Close(); Form f = new Expenditure_Type(); f.Show(); }
private void button1_Click(object sender, EventArgs e) { SqlConnection conn = new SqlConnection("Data Source=DELL-PC\\SQLEXPRESS;Initial Catalog=NGOIdatabase;Integrated Security=True"); conn.Open(); SqlCommand comd = conn.CreateCommand(); comd.CommandType = CommandType.Text; comd.CommandText = "INSERT INTO expenditure_type ( Description, expenditure_name) values ('" + textBox2.Text + "','" + comboBox2.Text + "')"; comd.ExecuteNonQuery(); ExpenditureTypedb extdb = new ExpenditureTypedb(); dataGridView1.DataSource = extdb.selectall(); conn.Close(); // textBox5.Text = ""; textBox2.Text = ""; comboBox2.Text = ""; }