private void btnok_Click(object sender, EventArgs e)
{
Brandform ChangeBrandfrm = (Brandform)this.Owner;
string id = Convert.ToString(ChangeBrandfrm.dgvbrand.Rows[ChangeBrandfrm.dgvbrand.CurrentRow.Index].Cells["id"].Value);
string txtQueryChangeClass = "UPDATE Brand SET name='" + txtnamebrand.Text + "' WHERE id='" + id + "'";
_SQl.SQL_Query(txtQueryChangeClass);
this.Close();
ChangeBrandfrm.load_brand();
}
private void btnok_Click(object sender, EventArgs e)
{
Brandform NewBrandfrm = (Brandform)this.Owner;
DataTable DTnbrand = _SQl.ExecuteSQL("SELECT max(id) FROM Brand");
if (DTnbrand.Rows[0][0].ToString() == "")
{
int id_brandn = 1;
string txtQueryNewBrandAdd = "INSERT INTO Brand VALUES('" + id_brandn + "','" + txtnamebrand.Text + "')";
_SQl.SQL_Query(txtQueryNewBrandAdd);
}
else
{
int id_brandn = Convert.ToInt32(DTnbrand.Rows[0][0].ToString()) + 1;
string txtQueryNewBrandAdd = "INSERT INTO Brand VALUES('" + id_brandn + "','" + txtnamebrand.Text + "')";
_SQl.SQL_Query(txtQueryNewBrandAdd);
}
this.Close();
NewBrandfrm.load_brand();
}