private void button1_Click(object sender, EventArgs e)
{
try
{
if (button1.Text == "edit")
{
PiggyTable.update(int.Parse(button1.Tag.ToString()), textBox1.Text, textBox2.Text);
button1.Text = "Insert";
button1.Tag = "";
MessageBox.Show("Data has been updated");
}
else
{
PiggyTable.insert(textBox1.Text, textBox2.Text);
MessageBox.Show("Data has been inserted");
}
UpdateList();
textBox1.Text = "";
textBox2.Text = "";
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
public void UpdateList()
{
var table = PiggyTable.LoadTable();
listView1.Items.Clear();
foreach (DataRow item in table.Rows)
{
var listitem = listView1.Items.Add(item.ItemArray[0].ToString());
listitem.SubItems.Add(item.ItemArray[1].ToString());
listitem.SubItems.Add(item.ItemArray[2].ToString());
}
}
private void deleteToolStripMenuItem_Click(object sender, EventArgs e)
{
try
{
if (listView1.SelectedItems.Count == 0)
{
throw new Exception("select row first");
}
PiggyTable.delete(int.Parse(listView1.SelectedItems[0].Text));
UpdateList();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
public Frmmain()
{
InitializeComponent();
PiggyTable.Initialise();
}
