private void dataGridView1_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
DatabaseConnect db = new DatabaseConnect();
string id = dataGridView1.Rows[e.RowIndex].Cells[1].Value.ToString();
string Command = dataGridView1.Rows[e.RowIndex].Cells[e.ColumnIndex].Value.ToString();
if (Command.ToLower() == "delete")
{
DialogResult DialogDecision = MessageBox.Show("Are you sure you want to delete the entire row?", "", MessageBoxButtons.YesNo);
if (DialogDecision == DialogResult.Yes)
{
string query = "Delete from expense_tbl where id=" + id;
db.Executequery(query);
string query1 = "Delete from chart_tbl where id=" + id;
db.Executequery(query1);
MessageBox.Show("Expense deleted successfully");
}
else if (DialogDecision == DialogResult.No)
{
MessageBox.Show("Be sure and come next time");
}
}
try
{
string query = "Select * from expense_tbl";
DataTable values = db.data(query);
dataGridView1.DataSource = values;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void LoadStart()
{
try
{
string query = "Select * from expense_tbl";
DatabaseConnect db = new DatabaseConnect();
DataTable values = db.data(query);
dataGridView1.DataSource = values;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
public static bool CheckDuplicateUsername(string Username)
{
try
{
string query = "select * from register_tbl where Username='******'";
DatabaseConnect dc = new DatabaseConnect();
DataTable deuser = dc.data(query);
if (deuser.Rows.Count > 0)
{
return(true);
}
else
{
return(false);
}
}
catch (Exception ex)
{
throw ex;
}
}
private void btnsearch_Click(object sender, EventArgs e)
{
try
{
if (txtsearch.Text == null)
{
MessageBox.Show("Enter a word to search Thank You!!!");
}
else
{
string query = "Select * from expense_tbl where title like'" + txtsearch.Text + "%'or description like'" + txtsearch.Text + "%' ";
DatabaseConnect db = new DatabaseConnect();
DataTable dt = db.data(query);
dataGridView1.DataSource = dt;
txtsearch.Text = "";
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
