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 dataGridView1_MouseClick(object sender, MouseEventArgs e)
{
try
{
int id = (int)dataGridView1.SelectedRows[0].Cells[0].Value;
ExpenditureTypedb exdb = new ExpenditureTypedb();
DataTable dt = exdb.get(id);
textBox5.Text = dt.Rows[0]["expenditure_type_id"].ToString().Trim();
comboBox2.Text = dt.Rows[0]["expenditure_name"].ToString().Trim();
textBox2.Text = dt.Rows[0]["Description"].ToString().Trim();
}
catch (Exception e1)
{
//MessageBox.Show(e1.Message);
}
}
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 = "";
}