private void Delete_Click(object sender, EventArgs e)
{
DialogResult result = MessageBox.Show("¿Desea eliminar este registro?", "Confirme", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (result == DialogResult.Yes)
{
try
{
con.Open();
cmd = new SqlCommand("DELETE FROM Cliente WHERE (FolioCliente= '" + FolioD.Text + "')", con);
cmd.ExecuteNonQuery();
MessageBox.Show("Registro eliminado", "Borrar", MessageBoxButtons.OK, MessageBoxIcon.Information);
da = new SqlDataAdapter("SELECT * FROM Cliente WHERE (FolioCliente='" + FolioD.Text + "')", con);
dt = new DataTable();
da.Fill(dt);
Dcontainer.DataSource = dt;
con.Close();
FolioD.Clear();
}
catch
{
MessageBox.Show("No se pudo borrar el registro.", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
else if (result == DialogResult.No)
{
}
}
private void Buscar_Click(object sender, EventArgs e)
{
con.Open();
string query = "SELECT FolioCliente FROM Cliente WHERE (FolioCliente='" + FolioD.Text + "')";
SqlCommand cmd = new SqlCommand(query, con);
string date = Convert.ToString(cmd.ExecuteScalar());
if (date == "")
{
MessageBox.Show("No existe registro con el folio: " + FolioD.Text, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
con.Close();
FolioD.Clear();
}
else if (FolioD.Text == "")
{
MessageBox.Show("Ingrese el Folio", "Error!", MessageBoxButtons.OK, MessageBoxIcon.Error);
con.Close();
}
else
{
da = new SqlDataAdapter("SELECT * FROM Cliente WHERE (FolioCliente='" + FolioD.Text + "')", con);
dt = new DataTable();
da.Fill(dt);
Dcontainer.DataSource = dt;
con.Close();
}
}