private void button4_Click(object sender, EventArgs e)
{
int rowAffected = 0;
try
{
int id = int.Parse(textBox1.Text);
string name = textBox2.Text;
int billNo = int.Parse(textBox3.Text);
string email = textBox4.Text;
rowAffected = CollectionToSQL.Update(id, name, billNo, email);
}
catch (Exception ex)
{ }
finally
{
if (rowAffected == 1)
{
MessageBox.Show("Row Updated");
}
else
{
MessageBox.Show("Oops! An error occured");
}
dataGridView.DataSource = CollectionToSQL.Select();
dtSource = CollectionToSQL.Select();
}
}
private void button5_Click(object sender, EventArgs e)
{
int rowAffected = 0;
try
{
int id = int.Parse(textBox1.Text);
rowAffected = CollectionToSQL.Delete(id);
}
catch (Exception ex)
{
}
finally
{
if (rowAffected == 1)
{
MessageBox.Show("Row Deleted");
}
else
{
MessageBox.Show("Oops! An error occured");
}
dataGridView.DataSource = CollectionToSQL.Select();
dtSource = CollectionToSQL.Select();
}
}
private void button2_Click(object sender, EventArgs e)
{
dataGridView.DataSource = CollectionToSQL.Select();
dtSource = CollectionToSQL.Select();
}
private void Form1_Load(object sender, System.EventArgs e)
{
dtSource = CollectionToSQL.Select();
}
