private void cargarTabla() { con = new SqlConnection("Data Source=DESKTOP-7UG5AJD\\SQLEXPRESS02;Initial Catalog=RentCar;Integrated Security=True"); con.Open(); string sql = "select * from Cliente"; SqlDataAdapter da = new SqlDataAdapter(sql, con); DataTable dt = new DataTable(); da.Fill(dt); Dgvclientes.DataSource = dt; Dgvclientes.Refresh(); con.Close(); }
private void cargarTabla() { if (con.State != ConnectionState.Open) { con.Open(); } string sql = "select * from Cliente"; SqlDataAdapter da = new SqlDataAdapter(sql, con); DataTable dt = new DataTable(); da.Fill(dt); Dgvclientes.DataSource = dt; Dgvclientes.Refresh(); con.Close(); }
private void BtEliminar_Click(object sender, EventArgs e) { try { con = new SqlConnection("Data Source=DESKTOP-7UG5AJD\\SQLEXPRESS02;Initial Catalog=RentCar;Integrated Security=True"); con.Open(); string sql = "DELETE FROM Cliente WHERE IdCliente = " + "'" + TxtId.Text + "'" + ""; SqlCommand comando = new SqlCommand(sql, con); comando.ExecuteNonQuery(); MessageBox.Show("Registro Borrado"); Dgvclientes.Refresh(); this.Close(); con.Close(); } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private void BtEliminar_Click(object sender, EventArgs e) { try { if (con.State != ConnectionState.Open) { con.Open(); } string sql = "DELETE FROM Cliente WHERE IdCliente = " + "'" + TxtId.Text + "'" + ""; SqlCommand comando = new SqlCommand(sql, con); comando.ExecuteNonQuery(); MessageBox.Show("Registro Borrado"); Dgvclientes.Refresh(); this.Close(); con.Close(); } catch (Exception ex) { MessageBox.Show(ex.Message); } }