Programacion Java Netbeans y MySql: 2024

miércoles, 4 de septiembre de 2024

Conectar a MySql con Java Netbeans mediante un Formulario

Tener agregado en libraries el conector mysql.

clase coneBD.java
package pktForm12;
import java.sql.*;
import javax.swing.JOptionPane;
public class coneBD {
public static PreparedStatement prest=null;
public static CallableStatement cllst=null;
public static Connection conec=null;
public static Statement st=null;
public static ResultSet rt=null;
public static String usu;
public static String contra;
public static String host;
public static String db;
public void Conectar(){
try{
   usu="root"; contra=""; host="localhost"; db="ventas";
   String url="jdbc:mysql://"+host+"/"+db;
   Class.forName("com.mysql.jdbc.Driver").newInstance();
   conec=DriverManager.getConnection(url,usu,contra);
}catch(Exception e){
   JOptionPane.showMessageDialog(null, e.toString());
}
}
}

package pktForm12;
import javax.swing.JOptionPane;
import javax.swing.table.DefaultTableModel;
public class frmListar extends javax.swing.JFrame {
   coneBD cn=new coneBD();
   DefaultTableModel modelo=new DefaultTableModel();
public frmListar() {
   initComponents();
   String titu[]={"IDCliente","Nombres","Apellidos","Direccion","Telefono","E-mail"};
   modelo.setColumnIdentifiers(titu);
   tblClientes.setModel(modelo);
}
private void llenarT() {
   String SQL="select * from clientes;";
   String datos[]=new String[6];
   try{
   cn.Conectar();
   cn.st=cn.conec.createStatement();
   cn.rt=cn.st.executeQuery(SQL);
   while (cn.rt.next()){
   datos[0]=cn.rt.getString(1);
   datos[1]=cn.rt.getString(2);
   datos[2]=cn.rt.getString(3);
   datos[3]=cn.rt.getString(4);
   datos[4]=cn.rt.getString(5);
   datos[5]=cn.rt.getString(6);
   modelo.addRow(datos);
   }
   }catch(Exception e){
       JOptionPane.showMessageDialog(null, e.toString());
   }
}
private void btnListarActionPerformed(java.awt.event.ActionEvent evt) {
   llenarT();
}

Se programa en Java, PHP, MySql, Visual Basic .Net desde 100 USD - Tec. Miguel Nunez minuvasoft10@gmail.com

miércoles, 10 de julio de 2024

Listar Productos con Imagen con PHP y MySql + Codigo Fuente

Las imagenes estan en la carpeta productos dentro de htdocs, en la tabla productos hay una columna que guarda el nombre de la imagen.

<?php

$servername = "localhost";

$username = "minuvahard10";

$password = "unodostres";

$dbname = "ventas";

echo '<head><link rel="stylesheet" type="text/css" href="style.css" /></head>';

$conn = new mysqli($servername, $username, $password, $dbname);

if ($conn->connect_error) {

die("Connection failed: " . $conn->connect_error);

}

$sql = "SELECT * FROM productos";

$result = $conn->query($sql);

if ($result->num_rows > 0) {

echo "<table>";

echo "<tr><th>Barcode</th><th>Nombre</th><th>Precio</th></tr>";

while($row = $result->fetch_assoc()) {

$var = $row["barcode"];

$cad = "<tr><td>". $row["barcode"]."</td><td>". $row["nombre"]."</td><td>". $row["precio"]."</td><td><img src='productos/". $row["imagen"]."'></td>";

echo $cad; ?>

<td><a href='detalle.php?codi=<?php echo $var; ?>'><p onmouseover=''>Detalle</p></a></td></tr>

<?php

}

echo "</table>";

} else {

echo "0 results";

}

$conn->close();

Download Source Code

Download Data Base

Se Desarrolla Proyectos Software con PHP y MySql - Miguel Nunez - minuvasoft10@gmail.com

domingo, 7 de julio de 2024

Mini Software de Recibo con Java Netbeans Mysql + Codigo de Barras + Impresion + Codigo Fuente

Clase de Formulario frmBuscarBC.java

package pktForm12;

import java.awt.Font;

import java.awt.Graphics;

import java.awt.Graphics2D;

import java.awt.print.PageFormat;

import java.awt.print.Printable;

import static java.awt.print.Printable.NO_SUCH_PAGE;

import static java.awt.print.Printable.PAGE_EXISTS;

import java.awt.print.PrinterException;

import java.awt.print.PrinterJob;

import java.util.HashSet;

import java.util.Set;

import javax.swing.JOptionPane;

import javax.swing.SwingConstants;

import javax.swing.table.DefaultTableCellRenderer;

import javax.swing.table.DefaultTableModel;

public class frmBuscarBC extends javax.swing.JFrame {

coneBD cn=new coneBD();

DefaultTableModel modelo=new DefaultTableModel();

public frmBuscarBC() {

initComponents();

String titu[]={"IDProducto","Nombre","Precio"};

modelo.setColumnIdentifiers(titu);

tblPro.setModel(modelo);

tblPro.getColumnModel().getColumn(1).setPreferredWidth(200);

DefaultTableCellRenderer cellRenderer = new DefaultTableCellRenderer();

cellRenderer.setHorizontalAlignment(SwingConstants.RIGHT);

tblPro.getColumnModel().getColumn(2).setCellRenderer(cellRenderer);

}

private void txtBuscarActionPerformed(java.awt.event.ActionEvent evt) {

String SQL="select * from productos where barcode like '"+txtBuscar.getText()+"%';";

String datos[]=new String[3];

int op=0;

try{

cn.Conectar();

cn.st=cn.conec.createStatement();

cn.rt=cn.st.executeQuery(SQL);

while (cn.rt.next()){

datos[0]=cn.rt.getString(1);

datos[1]=cn.rt.getString(2);

datos[2]=cn.rt.getString(3);

modelo.addRow(datos);

op=1;

}

}catch(Exception e){

JOptionPane.showMessageDialog(null, e.toString());

}

if (op==0) {

JOptionPane.showMessageDialog(null, "No tenemos el producto "+txtBuscar.getText());

} else {

calTot();

}

txtBuscar.setText(null);

}

private void btnPrintActionPerformed(java.awt.event.ActionEvent evt) {

PrinterJob job = PrinterJob.getPrinterJob();

job.setPrintable(new Printable() {

public int print(Graphics pg, PageFormat pf, int pageNum){

if (pageNum > 0){

return Printable.NO_SUCH_PAGE;

}

Font fuente = new Font("courier",Font.PLAIN,10);

Graphics2D g2 = (Graphics2D) pg;

g2.setFont(fuente);

g2.drawString("minuvaMarket", 100, 100);

int n = modelo.getRowCount(); int i=0;

for(i=0;i<n;i++) {

g2.drawString(""+modelo.getValueAt(i, 0).toString(), 100, i*20+125);

g2.drawString(""+modelo.getValueAt(i, 1).toString(), 200, i*20+125);

g2.drawString(""+modelo.getValueAt(i, 2).toString(),350, i*20+125);

}

jPanel1.paint(g2);

return Printable.PAGE_EXISTS;

}

});

try {

job.print();

} catch(PrinterException e) {

e.printStackTrace();

}

private void calTot() {

int n = modelo.getRowCount();

int i; double S=0; double tax=0; double tot=0;

for(i=0;i<n;i++) {

S = S + Double.parseDouble(modelo.getValueAt(i, 2).toString());

}

S = redo(S);

lblSub.setText(S+"");

tax = 0.1*S;

tax = redo(tax);

lblTax.setText(tax+"");

tot = S+tax;

tot = redo(tot);

lblTot.setText(tot+"");

}

private double redo(double num){

return Math.rint(num*100)/100;

}

Clase de Conexion coneBD.java

package pktForm12;

import java.sql.*;

import javax.swing.JOptionPane;

public class coneBD {

public static PreparedStatement prest=null;

public static CallableStatement cllst=null;

public static Connection conec=null;

public static Statement st=null;

public static ResultSet rt=null;

public static String usu;

public static String contra;

public static String host;

public static String db;

public void Conectar(){

try{

usu="root"; contra=""; host="localhost"; db="ventas";

String url="jdbc:mysql://"+host+"/"+db;

Class.forName("com.mysql.jdbc.Driver").newInstance();

conec=DriverManager.getConnection(url,usu,contra);

}catch(Exception e){

JOptionPane.showMessageDialog(null, e.toString());

}

Tener Agregado en Libraries el conector mysql

Download Source Code

Para Un Software Optimo comunicarse a minuvasoft10@gmail.com - Miguel Nunez

Download Database

lunes, 1 de julio de 2024

Buscador con Imagen y PHP Mysql Select Like % + variable

tabla productos

buscar2.php

<html>

<body>

</form>

<?php

if (isset($_POST['nom'])) {

   $keyw = $_POST['nom'];

   $dbhost = 'localhost';

   $dbuser = 'minuvahard10';

   $dbpass = 'unodostres';

   $dbname = 'ventas';

   $mysqli = new mysqli($dbhost, $dbuser, $dbpass, $dbname);

   if($mysqli->connect_errno ) {

      printf("Connect failed: %s<br />", $mysqli->connect_error);

      exit();

}

   $result = $mysqli->query("SELECT * FROM productos where nombre like '$keyw%'");

   if ($result->num_rows > 0) {

      echo "<table>";

      while($row = $result->fetch_assoc()) {

         $r2 = $row['imagen'];

         echo "<tr>";

         echo "<td><img src='productos/$r2' style='width: 300px;'></td><td>".$row['barcode']." ".$row['nombre']." ".$row['precio']."</td>";    

         echo "</tr>";          

}

      echo "</table>";

   } else {

      printf('No record found.<br />');

}

   mysqli_free_result($result);

   $mysqli->close();

}

?>

</body>

</html>

Se Desarrolla Proyectos Software - Miguel Nunez - minuvasoft10@gmail.com

viernes, 7 de junio de 2024

Inversa de una Matrix nxn con Java Netbeans + Codigo Fuente

Metodos Numericos, Analisis Numerico.

import javax.swing.table.DefaultTableModel;

public class frmInversa extends javax.swing.JFrame {

DefaultTableModel modelA = new DefaultTableModel();

DefaultTableModel modelI = new DefaultTableModel();

public frmInversa() {

initComponents();

tblA.setModel(modelA);

tblI.setModel(modelI);

cargarA3();

}

private void cargarA5() {

modelA.setColumnCount(5);

modelI.setColumnCount(5);

String dat[] = new String[5];

dat[0] = "6.5"; dat[1]="2.5"; dat[2]="3.5"; dat[3]="4.5"; dat[4]="5.5";

modelA.addRow(dat);

dat[0] = "6"; dat[1]="7"; dat[2]="8"; dat[3]="9"; dat[4]="10";

modelA.addRow(dat);

dat[0] = "9"; dat[1]="8"; dat[2]="1.5"; dat[3]="6"; dat[4]="5";

modelA.addRow(dat);

dat[0] = "4"; dat[1]="3"; dat[2]="2"; dat[3]="11.5"; dat[4]="0";

modelA.addRow(dat);

dat[0] = "-1"; dat[1]="-2"; dat[2]="3"; dat[3]="-4"; dat[4]="5";

modelA.addRow(dat);

}

private void cargarA4() {

modelA.setColumnCount(4);

modelI.setColumnCount(4);

String dat[] = new String[4];

dat[0] = "1"; dat[1]="2"; dat[2]="3"; dat[3]="10";

modelA.addRow(dat);

dat[0] = "4"; dat[1]="5"; dat[2]="6"; dat[3]="11";

modelA.addRow(dat);

dat[0] = "7"; dat[1]="2"; dat[2]="9"; dat[3]="1";

modelA.addRow(dat);

dat[0] = "5.5"; dat[1]="2.5"; dat[2]="9.5"; dat[3]="1.5";

modelA.addRow(dat);

}

private void cargarA3() {

modelA.setColumnCount(3);

modelI.setColumnCount(3);

String dat[] = new String[3];

dat[0] = "1"; dat[1]="2"; dat[2]="3";

modelA.addRow(dat);

dat[0] = "4"; dat[1]="5"; dat[2]="6";

modelA.addRow(dat);

dat[0] = "7"; dat[1]="2"; dat[2]="9";

modelA.addRow(dat);

}

private void cargarA2() {

modelA.setColumnCount(2);

modelI.setColumnCount(2);

String dat[] = new String[2];

dat[0] = "1"; dat[1]="2";

modelA.addRow(dat);

dat[0] = "4"; dat[1]="5";

modelA.addRow(dat);

}

private void btnInvActionPerformed(java.awt.event.ActionEvent evt) { int i,j,k;

Deter D = new Deter();

int N = modelA.getRowCount();

modelI.setColumnCount(N);

modelI.setRowCount(0);

double adjA[][] = new double[N][N];

double A[][] = new double[N][N];

double T[][] = new double[N][N];

double X[][] = new double[N][N];

double detA;

String dato[] = new String[N];

for(i=0;i<N;i++) {

for(j=0;j<N;j++) {

A[i][j] = Double.parseDouble(modelA.getValueAt(i, j).toString());

}

detA = D.deterM(A, N);

lblDet.setText("det(A)= "+detA);

for(i=0;i<N;i++) {

for(j=0;j<N;j++) {

k=i+2+j;

D.obtener(A, T, i, j, N);

adjA[i][j] = Math.pow(-1, k)*D.deterM(T, N-1);

X[j][i] = adjA[i][j]/detA;

}

for(i=0;i<N;i++) {

for(j=0;j<N;j++) {

dato[j] = X[i][j]+"";

}

modelI.addRow(dato);

}

private void jComboBox1ActionPerformed(java.awt.event.ActionEvent evt) { int op = jComboBox1.getSelectedIndex();

modelA.setRowCount(0);

modelI.setRowCount(0);

lblDet.setText(null);

switch (op){

case 0: cargarA2(); break;

case 1: cargarA3(); break;

case 2: cargarA4(); break;

case 3: cargarA5(); break;

}

Download Source Code

minuvasoft10@gmail.com Miguel Nunez - Se desarrolla proyectos software.

martes, 4 de junio de 2024

Sistema de Ecuaciones Lineales nxn con Java Netbeans + Codigo Fuente

Se soluciona un Sistema de Ecuaciones lineales por determinantes utilizando el lenguaje de programacion Java, Metodos Numericos, Analisis Numerico.

import javax.swing.table.DefaultTableModel;

public class frmEcua extends javax.swing.JFrame {

DefaultTableModel modelA = new DefaultTableModel();

DefaultTableModel modelB = new DefaultTableModel();

DefaultTableModel modelX = new DefaultTableModel();

Deter D = new Deter();

public frmEcua() {

initComponents();

tblA.setModel(modelA);

tblB.setModel(modelB);

tblX.setModel(modelX);

cargaIni();

}

private void cargaIni() {

modelA.setColumnCount(3);

modelB.setColumnCount(1);

modelX.setColumnCount(1);

String titu[] = {"X"};

modelX.setColumnIdentifiers(titu);

String dat[] = new String[3];

String B[] = new String[1];

dat[0] = "1"; dat[1]="2"; dat[2]="3";

modelA.addRow(dat);

dat[0] = "1"; dat[1]="4"; dat[2]="9";

modelA.addRow(dat);

dat[0] = "1"; dat[1]="8"; dat[2]="27";

modelA.addRow(dat);

B[0] = "7"; modelB.addRow(B);

B[0] = "15"; modelB.addRow(B);

B[0] = "37"; modelB.addRow(B);

}

private void cargarM2() {

modelA.setRowCount(0);

modelB.setRowCount(0);

String titu[] = {"A","B"};

String dato1[] = {"0.55","1.55"};

String dato2[] = {"-0.55","3.55"};

String B[] = {"0.3545"};

modelB.addRow(B);

B[0] = "0.3595";

modelB.addRow(B);

modelA.setColumnIdentifiers(titu);

modelA.addRow(dato1);

modelA.addRow(dato2);

}

private void cargarM3() {

modelA.setRowCount(0);

modelB.setRowCount(0);

String titu[] = {"A","B","C"};

String dato1[] = {"0.55","1.55","2.55"};

String dato2[] = {"-3.55","4.55","-5.55"};

String dato3[] = {"5.55","-6.55","7.55"};

String B[] = {"1.1"};

modelB.addRow(B);

B[0] = "11.1";

modelB.addRow(B);

B[0] = "-15.1";

modelB.addRow(B);

modelA.setColumnIdentifiers(titu);

modelA.addRow(dato1);

modelA.addRow(dato2);

modelA.addRow(dato3);

}

private void cargarM4() {

modelA.setRowCount(0);

modelB.setRowCount(0);

String titu[] = {"A","B","C","D"};

String dato1[] = {"0.55","1.55","2.55","6.55"};

String dato2[] = {"-3.55","4.55","-5.55","7.55"};

String dato3[] = {"5.55","-6.55","7.55","8.55"};

String dato4[] = {"5","-6","7","2"};

modelA.setColumnIdentifiers(titu);

modelA.addRow(dato1);

modelA.addRow(dato2);

modelA.addRow(dato3);

modelA.addRow(dato4);

String B[] = {"3.5"};

modelB.addRow(B);

B[0] = "2.55"; modelB.addRow(B);

B[0] = "4"; modelB.addRow(B);

B[0] = "-2"; modelB.addRow(B);

}

private void cargarM5() {

modelA.setRowCount(0);

String titu[] = {"A","B","C","D","E"};

String dato1[] = {"0.55","1.55","2.55","6.55","2.55"};

String dato2[] = {"-3.55","4.55","-5.55","7.55","-5.55"};

String dato3[] = {"5.55","-6.55","7.55","8.55","1.55"};

String dato4[] = {"6.55","-6.55","7.55","8.55","10.55"};

String dato5[] = {"-8.55","-6.55","1.55","8.55","1.55"};

modelA.setColumnIdentifiers(titu);

modelA.addRow(dato1);

modelA.addRow(dato2);

modelA.addRow(dato3);

modelA.addRow(dato4);

modelA.addRow(dato5);

modelB.setRowCount(0);

String B[] = {"11.55"}; modelB.addRow(B);

B[0] = "12.55"; modelB.addRow(B);

B[0] = "4.55"; modelB.addRow(B);

B[0] = "-2.55"; modelB.addRow(B);

B[0] = "-5.55"; modelB.addRow(B);

}

private void btnCalActionPerformed(java.awt.event.ActionEvent evt) { int i,j;

int N = modelA.getRowCount();

double detA;

double detAx[] = new double[N];

String R[]= new String[1];

double B[] = new double[N];

double A[][] = new double[N][N];

double T[][] = new double[N][N];

modelX.setRowCount(0);

for(i=0;i<N;i++) {

for(j=0;j<N;j++) {

A[i][j] = Double.parseDouble(modelA.getValueAt(i, j).toString());

T[i][j] = A[i][j];

}

B[i] = Double.parseDouble(modelB.getValueAt(i, 0).toString());

}

detA = Math.round(D.deterM(A, N)*1000.0)/1000.0;

for(j=0;j<N;j++) {

for(i=0;i<N;i++) {

T[i][j] = B[i];

}

detAx[j] = Math.round(D.deterM(T, N)*1000.0)/1000.0;

copy(A,T,N);

}

for(i=0;i<N;i++) {

R[0]=detAx[i]/detA+"";

modelX.addRow(R);

}

private void cmbMActionPerformed(java.awt.event.ActionEvent evt) { int op = cmbM.getSelectedIndex();

switch (op){

case 0: cargarM2(); break;

case 1: cargarM3(); break;

case 2: cargarM4(); break;

case 3: cargarM5(); break;

}

private void copy(double A[][],double T[][],int N) {

int i,j;

for(i=0;i<N;i++) {

for(j=0;j<N;j++) {

T[i][j] = A[i][j];

}

Download Source Code

minuvasoft10@gmail.com - Miguel Nunez, se desarrolla proyectos software

miércoles, 22 de mayo de 2024

Metodo de Biseccion - Metodos Numericos con Java Netbeans

import javax.swing.table.DefaultTableModel;

public class frmMetodo2 extends javax.swing.JFrame {

DefaultTableModel model = new DefaultTableModel();

DefaultTableModel model2 = new DefaultTableModel();

DefaultTableModel model3 = new DefaultTableModel();

public frmMetodo2() {

initComponents();

tblI.setModel(model);

tblI2.setModel(model2);

tblX.setModel(model3);

String titu[] = {"X","f(x)"};

String titu2[] = {"X0","X1"};

String titu3[] = {"X"};

model.setColumnIdentifiers(titu);

model2.setColumnIdentifiers(titu2);

model3.setColumnIdentifiers(titu3);

}

private void jButton1ActionPerformed(java.awt.event.ActionEvent evt) {

double i,f,x0,f0;

i=0.0;

f=0.0;

x0=0;

f0=0;

String dat[] = new String[2];

String dat2[] = new String[2];

for(i=-50;i<50;i++){

f = Math.exp(i)-2*i-2;

dat[0] = i + "";

dat[1] = f + "";

model.addRow(dat);

if (f*f0<0) {

dat2[0] = x0+"";

dat2[1] = i + "";

model2.addRow(dat2);

}

x0=i;

f0=f;

}

private void metodoBi(double x0,double x1) {

double xm,f0,fm;

double e;

String X[] = new String[1];

xm = (x0 + x1)/2;

e = Math.abs((xm-x0)/xm);

if (e>0.01) {

f0 = Math.exp(x0)-2*x0-2;

fm = Math.exp(xm)-2*xm-2;

if (f0*fm<0) {

metodoBi(x0,xm);

} else {

metodoBi(xm,x1);

}

} else {

X[0] = xm+"";

model3.addRow(X);

}

private void btnCalcActionPerformed(java.awt.event.ActionEvent evt) {

int n = model2.getRowCount();

if (n>0) {

double x0 = Double.parseDouble(model2.getValueAt(0, 0).toString());

double x1 = Double.parseDouble(model2.getValueAt(0, 1).toString());

metodoBi(x0,x1);

x0 = Double.parseDouble(model2.getValueAt(1, 0).toString());

x1 = Double.parseDouble(model2.getValueAt(1, 1).toString());

metodoBi(x0,x1);

}

Download Source Code

minuvasoft10@gmail.com

miércoles, 15 de mayo de 2024

Mini Software de Recibo con VB .Net 2022 y Excel 365 + Impresion + Codigo Fuente

De la caja de Herramientas agregar PrintDocument1 y PrintPreviewDialog1.

Imports System.Runtime.InteropServices.JavaScript.JSType

Imports Microsoft.Office.Interop

Public Class frmGrid3

Dim Aplicacion As Excel.Application

Dim Libro As Excel.Workbook

Dim hoja As Excel.Worksheet

Private Sub frmGrid3_Load(sender As Object, e As EventArgs) Handles MyBase.Load

cargarLibro()

End Sub

Private Sub cargarLibro()

DataGridView1.ColumnCount = 3

DataGridView1.Columns(0).Name = "Bar Code"

DataGridView1.Columns(1).Name = "Producto"

DataGridView1.Columns(2).Name = "Precio"

DataGridView1.Columns(1).Width = 200

Try

Aplicacion = New Excel.Application

Libro = Aplicacion.Workbooks.Open("C:\Users\miky mouse\OneDrive\ejemplo25.xlsx")

hoja = Libro.Worksheets(2)

Catch ex As Exception

closeL()

MsgBox("Error " + ex.ToString())

End Try

End Sub

Private Sub closeL()

Libro.Close()

Aplicacion.Quit()

End Sub

Private Sub frmGrid3_Closed(sender As Object, e As EventArgs) Handles MyBase.Closed

Libro.Close()

Aplicacion.Quit()

End Sub

Private Sub TextBox1_KeyDown(sender As Object, e As KeyEventArgs) Handles TextBox1.KeyDown

Dim bc As String

Dim dato(3) As String

Dim cad As String

Dim j As Integer

j = 0

cad = " "

Dim op As Integer

op = 0

If e.KeyCode = 13 Then

bc = TextBox1.Text

For j = 2 To 24

If CLng(bc) = CLng(hoja.Cells(j, 1).Value) Then

dato(0) = hoja.Cells(j, 1).value

dato(1) = hoja.Cells(j, 2).value

dato(2) = hoja.Cells(j, 3).value

DataGridView1.Rows.Add(dato)

op = 1

calTot()

End If

If op = 0 Then

cad = "No tenemos el Producto "

End If

MsgBox(cad + bc)

TextBox1.Text = " "

End If

End Sub

Private Sub calTot()

Dim S As Double

Dim pre As Double

Dim tax As Double

Dim tot As Double

Dim n As Integer

S = 0.00

pre = 0.00

n = DataGridView1.RowCount - 1

For fila = 0 To n

pre = CDbl(DataGridView1.Item(2, fila).Value)

S = S + pre

S = Math.Round(S, 2)

lblSub.Text = S.ToString()

tax = 0.09 * S

tax = Math.Round(tax, 2)

lblTax.Text = tax.ToString()

tot = S + tax

tot = Math.Round(tot, 2)

lblTot.Text = tot.ToString()

End Sub

Private Sub PrintDocument1_PrintPage(sender As Object, e As Printing.PrintPageEventArgs) Handles PrintDocument1.PrintPage

Dim n As Integer

Dim fila2 As Single

Dim fila3 As Single

Dim f1, f2, f3 As Single

Dim cad As String

Dim cad2 As String

Dim cad3 As String

Dim cad4 As String

Dim cad5 As String

Dim j As Integer

fila3 = 1

fila2 = 1

Try

n = DataGridView1.RowCount - 1

e.Graphics.DrawString("MinuvaMarket", New Font("Arial", 16), New SolidBrush(Color.Black), 50, 50)

For j = 0 To n

fila3 = 80 + fila2 * 10

cad = DataGridView1.Item(1, j).Value

cad2 = DataGridView1.Item(2, j).Value

e.Graphics.DrawString(cad, New Font("Arial", 13), New SolidBrush(Color.Black), 20, fila3)

e.Graphics.DrawString(cad2, New Font("Arial", 13), New SolidBrush(Color.Black), 300, fila3)

fila2 = fila2 + 2

cad3 = "Sub Total.." + lblSub.Text

cad4 = "Tax........" + lblTax.Text

cad5 = "Total......" + lblTot.Text

f1 = fila3 + 20

f2 = fila3 + 40

f3 = fila3 + 60

e.Graphics.DrawString(cad3, New Font("Arial", 13), New SolidBrush(Color.Black), 250, f1)

e.Graphics.DrawString(cad4, New Font("Arial", 13), New SolidBrush(Color.Black), 250, f2)

e.Graphics.DrawString(cad5, New Font("Arial", 13), New SolidBrush(Color.Black), 250, f3)

Catch ex As Exception

closeL()

MsgBox("Error " + ex.ToString())

End Try

End Sub

Private Sub btnPrint_Click(sender As Object, e As EventArgs) Handles btnPrint.Click

PrintPreviewDialog1.Document = PrintDocument1

PrintPreviewDialog1.Width = 500

PrintPreviewDialog1.Height = 600

PrintPreviewDialog1.Left = 600

PrintPreviewDialog1.Top = 150

PrintPreviewDialog1.ShowDialog()

End Sub

End Class

download Source Code

Para optimizacion del programa comunicarse a minuvasoft10@gmail.com -- Miguel Nunez