private void PagarBtn_Click(object sender, EventArgs e) { ConnectionSQLServer connection = new ConnectionSQLServer(); connection.OpenConnection(); Pagar pagar = new Pagar(); pagar.Show(); DateTime date = Convert.ToDateTime(DatetimeReporte.Value = DateTime.Now); pagar.VentaTotal(TotalVenta); TotalVenta = 0; int ventaT = pagar.Venta; int feria = pagar.Feria; int paga = pagar.Paga; int idVenta = connection.SeleccionarIdVenta("SELECT MAX(IdVenta) FROM Venta GROUP BY IdVenta"); if (idVenta == 0) { idVenta = 1; } foreach (DataGridViewRow row in GridVentasReporte.Rows) { int ids = Convert.ToInt32(row.Cells["IdVenta"].Value); if (idVenta == ids) { idVenta++; } } connection.IngresarDatosReporte("insert into Venta (IdVenta,VentaTotal,Pago,Feria,Fecha) values (@IdVenta,@VentaTotal,@Pago,@Feria,@Fecha)", idVenta, ventaT, paga, feria, date); GridVentasReporte.DataSource = connection.TablaVenta("select * from Venta"); connection.EliminarDatosVenta("delete from VentaProducto"); GridVentas.DataSource = connection.TablaVentaProducto("select * from VentaProducto"); idVenta += 1; connection.CloseConnection(); }