private void BtnNew_Click(object sender, EventArgs e)
{
Txtsupplierid.Text = "";
Txtsuppliername.Text = "";
Txtsuppliercom.Text = "";
TxtSupplierEmail.Text = "";
Txtsuppliermob.Text = "";
Txtsupplierphone.Text = "";
Txtsuppliecity.Text = "SELECT";
Txtsupplieraddress.Text = "";
//groupBox1.Enabled = true;
try
{
con.Open();
SqlDataAdapter ad = new SqlDataAdapter("SELECT * from Supplier_Master", con);
DataSet ds = new DataSet();
ad.Fill(ds);
DataTable dt = ds.Tables[0];
dataGridView1.DataSource = dt;
int b = (dt.Rows.Count);
b++;
Txtsupplierid.Text = b.ToString();
Txtsupplierid.Focus();
con.Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void BtnDelete_Click(object sender, EventArgs e)
{
try
{
con.Open();
SqlCommand cmd = new SqlCommand();
cmd = con.CreateCommand();
cmd.CommandType = CommandType.Text;
cmd.CommandText = "select * from [Supplier_Master]";
DialogResult re = MessageBox.Show("Do you want to delete this Record!", "Confirm", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (re == DialogResult.No)
{
Txtsupplierid.Focus();
}
else
{
cmd.CommandText = "DELETE FROM Supplier_Master WHERE [Supplier_ID]='" + Txtsupplierid.Text + "'";
cmd.ExecuteNonQuery();
MessageBox.Show("Selected record is DELETED", "Delete", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
cmd.CommandText = "SELECT * FROM [Supplier_Master]";
cmd.Connection.Close();
SqlDataAdapter ad = new SqlDataAdapter("SELECT * FROM [Supplier_Master]", con);
DataSet ds = new DataSet();
ad.Fill(ds);
DataTable dt = ds.Tables[0];
dataGridView1.DataSource = dt;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
Txtsupplierid.Text = "";
Txtsuppliername.Text = "";
Txtsuppliercom.Text = "";
TxtSupplierEmail.Text = "";
Txtsuppliermob.Text = "";
Txtsupplierphone.Text = "";
Txtsuppliecity.Text = "SELECT";
Txtsupplieraddress.Text = "";
pictureBox4.Image = null;
pictureBox5.Image = null;
pictureBox6.Image = null;
groupBox1.Enabled = true;
con.Close();
}
}