<?xml version='1.0' encoding='UTF-8'?><?xml-stylesheet href="http://www.blogger.com/styles/atom.css" type="text/css"?><feed xmlns='http://www.w3.org/2005/Atom' xmlns:openSearch='http://a9.com/-/spec/opensearchrss/1.0/' xmlns:georss='http://www.georss.org/georss' xmlns:gd='http://schemas.google.com/g/2005' xmlns:thr='http://purl.org/syndication/thread/1.0'><id>tag:blogger.com,1999:blog-4262485094358421481</id><updated>2011-07-07T23:58:13.251-07:00</updated><title type='text'>Julio Carlos Menchú Barreda (JC)</title><subtitle type='html'></subtitle><link rel='http://schemas.google.com/g/2005#feed' type='application/atom+xml' href='http://juliocarlosmster.blogspot.com/feeds/posts/default'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/4262485094358421481/posts/default?max-results=100'/><link rel='alternate' type='text/html' href='http://juliocarlosmster.blogspot.com/'/><link rel='hub' href='http://pubsubhubbub.appspot.com/'/><author><name>JC</name><uri>http://www.blogger.com/profile/01709135097126638030</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='21' height='32' src='http://2.bp.blogspot.com/_LlxmdjcK4eU/SOFbc1TvPXI/AAAAAAAAAB4/_FjmlZO7rxs/S220/Copia+de+img028.jpg'/></author><generator version='7.00' uri='http://www.blogger.com'>Blogger</generator><openSearch:totalResults>9</openSearch:totalResults><openSearch:startIndex>1</openSearch:startIndex><openSearch:itemsPerPage>100</openSearch:itemsPerPage><entry><id>tag:blogger.com,1999:blog-4262485094358421481.post-3996284550256170599</id><published>2010-07-06T16:24:00.001-07:00</published><updated>2010-07-06T16:24:40.831-07:00</updated><title type='text'></title><content type='html'>&lt;span style="font-size:130%;"&gt;&lt;span style="font-weight: bold;"&gt;CONEXION EN PHP&lt;/span&gt;&lt;/span&gt;&lt;br /&gt;&lt;br /&gt;&lt;br /&gt;&lt;html&gt;&lt;br /&gt;&lt;title&gt;Ingresar en tabla Clientes&lt;/title&gt;&lt;br /&gt;&lt;body&gt;&lt;br /&gt;&lt;?&lt;br /&gt;/* abrir conecion el server host el usuario y clave*/&lt;br /&gt;$conexion=mysql_connect("&lt;a href="http://s156.eatj.com:3307/" target="_blank"&gt;s156.&lt;wbr&gt;eatj.com:3307&lt;/a&gt;","juliocarlosmb"&lt;table border="0" cellpadding="0" cellspacing="0"&gt;&lt;tbody&gt;&lt;tr&gt;&lt;td style="font-family: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; font-size: inherit; line-height: inherit; font-size-adjust: inherit; font-stretch: inherit;" valign="top"&gt;&lt;wbr&gt;,"1234");&lt;br /&gt;/* la consulta la db y el qry*/&lt;br /&gt;$consulta=mysql_db_query('&lt;wbr&gt;juliocarlosmb', 'SELECT nombre, telefono FROM Table_CLIENTE');&lt;br /&gt;&lt;br /&gt;echo "&lt;table width="386" height="264" border="1"&gt; &lt;h2&gt;Registros existentes&lt;/h2&gt;";&lt;br /&gt;    /* Mostrar la Consulta */&lt;br /&gt;    while ($valores = mysql_fetch_array($consulta)) {&lt;br /&gt;echo"&lt;tr&gt;";&lt;br /&gt;echo "&lt;th scope="row"&gt;";&lt;br /&gt;    print " nombre: " . $valores["nombre"] . "&lt;br /&gt;\n";&lt;br /&gt;echo" &lt;/th&gt;";&lt;br /&gt;echo "&lt;td&gt;";&lt;br /&gt;    print " Telefono: " . $valores["telefono"] .  "&lt;br /&gt;\n";&lt;br /&gt;echo" &lt;/td&gt;";&lt;br /&gt;    } // while&lt;br /&gt;&lt;br /&gt;echo"&lt;/tr&gt;&lt;/table&gt;";&lt;br /&gt;mysql_free_result($consulta);&lt;br /&gt;mysql_close();&lt;br /&gt;?&gt;&lt;br /&gt;&lt;br /&gt;&lt;a href="../menu.html"&gt;IR a menu&lt;/a&gt;&lt;br /&gt;&lt;/body&gt;&lt;br /&gt;&lt;/html&gt;&lt;/td&gt;&lt;/tr&gt;&lt;/tbody&gt;&lt;/table&gt;&lt;div class="blogger-post-footer"&gt;&lt;img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/4262485094358421481-3996284550256170599?l=juliocarlosmster.blogspot.com' alt='' /&gt;&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://juliocarlosmster.blogspot.com/feeds/3996284550256170599/comments/default' title='Enviar comentarios'/><link rel='replies' type='text/html' href='http://www.blogger.com/comment.g?blogID=4262485094358421481&amp;postID=3996284550256170599' title='0 comentarios'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/4262485094358421481/posts/default/3996284550256170599'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/4262485094358421481/posts/default/3996284550256170599'/><link rel='alternate' type='text/html' href='http://juliocarlosmster.blogspot.com/2010/07/conexion-en-php-ingresar-en-tabla.html' title=''/><author><name>JC</name><uri>http://www.blogger.com/profile/01709135097126638030</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='21' height='32' src='http://2.bp.blogspot.com/_LlxmdjcK4eU/SOFbc1TvPXI/AAAAAAAAAB4/_FjmlZO7rxs/S220/Copia+de+img028.jpg'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-4262485094358421481.post-7375766750802796659</id><published>2009-05-08T09:43:00.000-07:00</published><updated>2009-05-08T09:46:06.651-07:00</updated><title type='text'></title><content type='html'>&lt;strong&gt;&lt;span style="color:#ff0000;"&gt;PROGRAMA EN VISUAL BASIC2005 a conexion a una tabla en ACCESS&lt;/span&gt;&lt;/strong&gt;&lt;br /&gt;Module Module1&lt;br /&gt;Public con As OleDb.OleDbConnection&lt;br /&gt;Public reader As Odbc.OdbcDataReader&lt;br /&gt;Public Sub conexion()&lt;br /&gt;con = New OleDb.OleDbConnection()&lt;br /&gt;con.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" &amp;amp; "C:\Documents and Settings\Administrador.ILLUSION_V2\Escritorio\tecno 3g\clinica.mdb"&lt;br /&gt;Try&lt;br /&gt;con.Open()&lt;br /&gt;con.Close()&lt;br /&gt;' MessageBox.Show("si hay conexion" &amp;amp; con.ToString)&lt;br /&gt;Catch ex As Exception&lt;br /&gt;MessageBox.Show("error" &amp;amp; ex.Message)&lt;br /&gt;Finally&lt;br /&gt;con.Dispose()&lt;br /&gt;&lt;br /&gt;End Try&lt;br /&gt;End Sub&lt;br /&gt;End Module&lt;br /&gt;-------------------------------------------------------------&lt;br /&gt;‘todo el form1&lt;br /&gt;&lt;br /&gt;Public Class Form1&lt;br /&gt;Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load&lt;br /&gt;conexion()&lt;br /&gt;mostrar()&lt;br /&gt;maximo()&lt;br /&gt;End Sub&lt;br /&gt;Public Sub maximo()&lt;br /&gt;Dim da As New OleDb.OleDbDataAdapter("SELECT max(Id_paciente) as maxi FROM paciente", con)&lt;br /&gt;Dim ds As New DataSet&lt;br /&gt;Try&lt;br /&gt;da.Fill(ds, "paciente")&lt;br /&gt;TextBox1.DataBindings.Add("text", ds, "paciente.maxi")&lt;br /&gt;TextBox1.Text = Val(TextBox1.Text) + 1&lt;br /&gt;Catch mi As Exception&lt;br /&gt;TextBox1.Text = Val(TextBox1.Text) + 1&lt;br /&gt;MsgBox(TextBox1.Text)&lt;br /&gt;End Try&lt;br /&gt;End Sub&lt;br /&gt;Public Sub mostrar()&lt;br /&gt;Dim sql As String&lt;br /&gt;Dim cm As OleDb.OleDbCommand&lt;br /&gt;Dim da As OleDb.OleDbDataAdapter&lt;br /&gt;Dim ds As DataSet&lt;br /&gt;Dim ver As DataView&lt;br /&gt;sql = "select * from paciente"&lt;br /&gt;cm = New OleDb.OleDbCommand()&lt;br /&gt;cm.CommandText = sql&lt;br /&gt;cm.CommandType = CommandType.Text&lt;br /&gt;cm.Connection = con&lt;br /&gt;da = New OleDb.OleDbDataAdapter(cm)&lt;br /&gt;ds = New DataSet()&lt;br /&gt;con.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" &amp;amp; "C:\Documents and Settings\Administrador.ILLUSION_V2\Escritorio\tecno 3g\clinica.mdb"&lt;br /&gt;con.Open()&lt;br /&gt;da.Fill(ds)&lt;br /&gt;ver = ds.Tables(0).DefaultView&lt;br /&gt;DataGridView1.DataSource = ver&lt;br /&gt;con.Close()&lt;br /&gt;End Sub&lt;br /&gt;Public Sub limpiar()&lt;br /&gt;TextBox1.Text = ""&lt;br /&gt;TextBox2.Text = ""&lt;br /&gt;TextBox6.Text = ""&lt;br /&gt;TextBox8.Text = ""&lt;br /&gt;DateTimePicker1.Text = ""&lt;br /&gt;TextBox10.Text = ""&lt;br /&gt;TextBox3.Text = ""&lt;br /&gt;TextBox4.Text = ""&lt;br /&gt;TextBox5.Text = ""&lt;br /&gt;TextBox11.Text = ""&lt;br /&gt;End Sub&lt;br /&gt;&lt;br /&gt;Private Sub Button4_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button4.Click&lt;br /&gt;Me.Close()&lt;br /&gt;&lt;br /&gt;End Sub&lt;br /&gt;&lt;br /&gt;Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click&lt;br /&gt;con = New OleDb.OleDbConnection&lt;br /&gt;con.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" &amp;amp; "C:\Documents and Settings\Administrador.ILLUSION_V2\Escritorio\tecno 3g\clinica.mdb"&lt;br /&gt;Dim sexo As String = ""&lt;br /&gt;If CheckBox1.Checked = True Then&lt;br /&gt;sexo = "masculino"&lt;br /&gt;End If&lt;br /&gt;If CheckBox2.Checked = True Then&lt;br /&gt;sexo = "femenido"&lt;br /&gt;End If&lt;br /&gt;&lt;br /&gt;Dim sql As String = "INSERT INTO paciente (Id_paciente,nombre,edad,sexo,estado_civil,fecha_nacimiento,conyuge,direccion,telefono1,telefono2,otros_datos)VALUES ('" &amp;amp; Val(TextBox1.Text) &amp;amp; "','" &amp;amp; TextBox2.Text &amp;amp; "','" &amp;amp; Val(TextBox6.Text) &amp;amp; "','" &amp;amp; sexo &amp;amp; "','" &amp;amp; TextBox8.Text &amp;amp; "','" &amp;amp; DateTimePicker1.Text &amp;amp; "','" &amp;amp; TextBox10.Text &amp;amp; "','" &amp;amp; TextBox3.Text &amp;amp; "','" &amp;amp; Val(TextBox4.Text) &amp;amp; "','" &amp;amp; Val(TextBox5.Text) &amp;amp; "','" &amp;amp; TextBox11.Text &amp;amp; "')"&lt;br /&gt;Dim cmd As New OleDb.OleDbCommand(sql, con)&lt;br /&gt;con.Open()&lt;br /&gt;Try&lt;br /&gt;Dim n As Int32 = cmd.ExecuteNonQuery&lt;br /&gt;con.Close()&lt;br /&gt;mostrar()&lt;br /&gt;MessageBox.Show("Ingreso exitoso")&lt;br /&gt;DataGridView1.Visible = True&lt;br /&gt;Button2.Enabled = True&lt;br /&gt;Button3.Enabled = True&lt;br /&gt;Button5.Enabled = True&lt;br /&gt;Button6.Enabled = True&lt;br /&gt;Catch ex As Exception&lt;br /&gt;MessageBox.Show("error al ingresar dato vea si el codigo del paciente no esta repetido" &amp;amp; ex.Message)&lt;br /&gt;End Try&lt;br /&gt;Button5.Enabled = True&lt;br /&gt;&lt;br /&gt;End Sub&lt;br /&gt;&lt;br /&gt;Private Sub DataGridView1_CellContentClick(ByVal sender As System.Object, ByVal e As System.Windows.Forms.DataGridViewCellEventArgs) Handles DataGridView1.CellContentClick&lt;br /&gt;limpiar()&lt;br /&gt;TextBox1.Text = DataGridView1("id_paciente", DataGridView1.CurrentRow.Index).Value.ToString()&lt;br /&gt;TextBox2.Text = DataGridView1("nombre", DataGridView1.CurrentRow.Index).Value.ToString()&lt;br /&gt;TextBox6.Text = DataGridView1("edad", DataGridView1.CurrentRow.Index).Value.ToString()&lt;br /&gt;' TextBox7.Text = DataGridView1("sexo", DataGridView1.CurrentRow.Index).Value.ToString()&lt;br /&gt;TextBox8.Text = DataGridView1("estado_civil", DataGridView1.CurrentRow.Index).Value.ToString()&lt;br /&gt;'DateTimePicker1.Text = DataGridView1("fecha_nacimiento", DataGridView1.CurrentRow.Index).Value.ToString()&lt;br /&gt;TextBox10.Text = DataGridView1("conyuge", DataGridView1.CurrentRow.Index).Value.ToString()&lt;br /&gt;TextBox3.Text = DataGridView1("direccion", DataGridView1.CurrentRow.Index).Value.ToString()&lt;br /&gt;TextBox4.Text = DataGridView1("telefono1", DataGridView1.CurrentRow.Index).Value.ToString()&lt;br /&gt;TextBox5.Text = DataGridView1("telefono2", DataGridView1.CurrentRow.Index).Value.ToString()&lt;br /&gt;TextBox11.Text = DataGridView1("otros_datos", DataGridView1.CurrentRow.Index).Value.ToString()&lt;br /&gt;Button5.Enabled = True&lt;br /&gt;End Sub&lt;br /&gt;&lt;br /&gt;Private Sub Button6_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button6.Click&lt;br /&gt;limpiar()&lt;br /&gt;maximo()&lt;br /&gt;Button5.Enabled = False&lt;br /&gt;End Sub&lt;br /&gt;&lt;br /&gt;Private Sub Button2_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button2.Click&lt;br /&gt;Dim sexo As String = ""&lt;br /&gt;If CheckBox1.Checked = True Then&lt;br /&gt;sexo = "masculino"&lt;br /&gt;End If&lt;br /&gt;If CheckBox2.Checked = True Then&lt;br /&gt;sexo = "femenido"&lt;br /&gt;End If&lt;br /&gt;con = New OleDb.OleDbConnection&lt;br /&gt;con.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" &amp;amp; "C:\Documents and Settings\Administrador.ILLUSION_V2\Escritorio\tecno 3g\clinica.mdb"&lt;br /&gt;Dim sql As String = "UPDATE paciente SET paciente.nombre= ('" &amp;amp; TextBox2.Text &amp;amp; "'), paciente.edad = ('" &amp;amp; Val(TextBox6.Text) &amp;amp; "'), paciente.sexo = ('" &amp;amp; sexo &amp;amp; "'), paciente.estado_civil = ('" &amp;amp; TextBox8.Text &amp;amp; "'), paciente.fecha_nacimiento = ('" &amp;amp; DateTimePicker1.Text &amp;amp; "'), paciente.conyuge = ('" &amp;amp; TextBox10.Text &amp;amp; "'), paciente.direccion = ('" &amp;amp; TextBox3.Text &amp;amp; "'), paciente.telefono1 = ('" &amp;amp; Val(TextBox4.Text) &amp;amp; "'),paciente.telefono2= ('" &amp;amp; Val(TextBox5.Text) &amp;amp; "'),paciente.otros_datos= ('" &amp;amp; TextBox11.Text &amp;amp; "') WHERE (((paciente.Id_paciente)=(" &amp;amp; CInt(TextBox1.Text) &amp;amp; ")))"&lt;br /&gt;Dim cmd As New OleDb.OleDbCommand(sql, con)&lt;br /&gt;con.Open()&lt;br /&gt;&lt;br /&gt;Dim answer As DialogResult&lt;br /&gt;answer = MessageBox.Show("¿Esta seguro que desea Modificar el registro?", _&lt;br /&gt;"Confirmacion", _&lt;br /&gt;MessageBoxButtons.YesNo, _&lt;br /&gt;MessageBoxIcon.Question, _&lt;br /&gt;MessageBoxDefaultButton.Button2)&lt;br /&gt;&lt;br /&gt;If answer = Windows.Forms.DialogResult.Yes Then&lt;br /&gt;Try&lt;br /&gt;Dim n As Int32 = cmd.ExecuteNonQuery&lt;br /&gt;con.Close()&lt;br /&gt;mostrar()&lt;br /&gt;MessageBox.Show("Modificacion exitoso")&lt;br /&gt;DataGridView1.Visible = True&lt;br /&gt;Catch ex As Exception&lt;br /&gt;MessageBox.Show("error al modificar dato " &amp;amp; ex.Message)&lt;br /&gt;End Try&lt;br /&gt;End If&lt;br /&gt;Button5.Enabled = True&lt;br /&gt;End Sub&lt;br /&gt;&lt;br /&gt;Private Sub Button3_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button3.Click&lt;br /&gt;con = New OleDb.OleDbConnection&lt;br /&gt;con.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" &amp;amp; "C:\Documents and Settings\Administrador.ILLUSION_V2\Escritorio\tecno 3g\clinica.mdb"&lt;br /&gt;Dim sql As String = "delete from paciente WHERE (((paciente.Id_paciente)=(" &amp;amp; CInt(TextBox1.Text) &amp;amp; ")))"&lt;br /&gt;Dim cmd As New OleDb.OleDbCommand(sql, con)&lt;br /&gt;con.Open()&lt;br /&gt;Dim answer As DialogResult&lt;br /&gt;answer = MessageBox.Show("¿Esta seguro que desea eliminar el registro?", _&lt;br /&gt;"Confirmacion", _&lt;br /&gt;MessageBoxButtons.YesNo, _&lt;br /&gt;MessageBoxIcon.Information, _&lt;br /&gt;MessageBoxDefaultButton.Button2)&lt;br /&gt;&lt;br /&gt;If answer = Windows.Forms.DialogResult.Yes Then&lt;br /&gt;Try&lt;br /&gt;Dim n As Int32 = cmd.ExecuteNonQuery&lt;br /&gt;con.Close()&lt;br /&gt;mostrar()&lt;br /&gt;MessageBox.Show("Eliminacion exitoso")&lt;br /&gt;DataGridView1.Visible = True&lt;br /&gt;Catch ex As Exception&lt;br /&gt;MessageBox.Show("error al eliminar dato " &amp;amp; ex.Message)&lt;br /&gt;End Try&lt;br /&gt;End If&lt;br /&gt;Button5.Enabled = True&lt;br /&gt;End Sub&lt;br /&gt;&lt;br /&gt;Private Sub CheckBox1_CheckedChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles CheckBox1.CheckedChanged&lt;br /&gt;CheckBox2.Checked = False&lt;br /&gt;End Sub&lt;br /&gt;&lt;br /&gt;Private Sub CheckBox2_CheckedChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles CheckBox2.CheckedChanged&lt;br /&gt;CheckBox1.Checked = False&lt;br /&gt;End Sub&lt;br /&gt;&lt;br /&gt;Private Sub Button5_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button5.Click&lt;br /&gt;Form2.id = Val(TextBox1.Text)&lt;br /&gt;Me.Close()&lt;br /&gt;Form2.Show()&lt;br /&gt;End Sub&lt;br /&gt;End Class&lt;div class="blogger-post-footer"&gt;&lt;img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/4262485094358421481-7375766750802796659?l=juliocarlosmster.blogspot.com' alt='' /&gt;&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://juliocarlosmster.blogspot.com/feeds/7375766750802796659/comments/default' title='Enviar comentarios'/><link rel='replies' type='text/html' href='http://www.blogger.com/comment.g?blogID=4262485094358421481&amp;postID=7375766750802796659' title='0 comentarios'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/4262485094358421481/posts/default/7375766750802796659'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/4262485094358421481/posts/default/7375766750802796659'/><link rel='alternate' type='text/html' href='http://juliocarlosmster.blogspot.com/2009/05/programa-en-visual-basic2005-conexion.html' title=''/><author><name>JC</name><uri>http://www.blogger.com/profile/01709135097126638030</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='21' height='32' src='http://2.bp.blogspot.com/_LlxmdjcK4eU/SOFbc1TvPXI/AAAAAAAAAB4/_FjmlZO7rxs/S220/Copia+de+img028.jpg'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-4262485094358421481.post-8750204614267546687</id><published>2009-04-01T13:45:00.000-07:00</published><updated>2009-04-01T13:57:55.013-07:00</updated><title type='text'></title><content type='html'>&lt;strong&gt;Como conectar el programa de Visual Basic 6.0 con MySql &lt;/strong&gt;&lt;br /&gt;1. Se entra a panel de control y en herramientas de administrador en Administrador de orígenes de datos ODBC y se agrega…&lt;br /&gt;2. El password es el de mysql&lt;br /&gt;3. Ahora en Visual Basic 6.0 se crea un Form y se crea lo que se desea según la tabla el dataenviroment se jala de nuevos en la herramientas&lt;br /&gt;4. Se crea un método y se pega el código de ADODB solo se cambia el surce o el nuevo nombre que se le puso ala dirección en herramientas del ODBC el código es el siguiente ….&lt;br /&gt;&lt;span style="color:#ff0000;"&gt;Public cn As ADODB.Connection&lt;br /&gt;Public qy As ADODB.Command&lt;br /&gt;Public con As String&lt;br /&gt;&lt;br /&gt;Public Sub conectar()&lt;br /&gt;con = ""&lt;br /&gt;Set cn = Nothing&lt;br /&gt;On Error Resume Next&lt;br /&gt;&lt;br /&gt;con = "Provider=MSDASQL.1;Persist Security Info=False;User ID=root;Data Source=julio"&lt;br /&gt;&lt;br /&gt;Set cn = New ADODB.Connection&lt;br /&gt;cn.Open con&lt;br /&gt;&lt;br /&gt;If Err Then&lt;br /&gt;MsgBox ("Error Con la Coneccion de Base de Datos")&lt;br /&gt;Exit Sub&lt;br /&gt;End If&lt;br /&gt;End Sub&lt;br /&gt;Public Sub desconectar() 'este procedimiento cierra la conexion activa&lt;br /&gt;cn.Close&lt;br /&gt;End Sub&lt;br /&gt;Public Sub mantenimiento(ByVal sql As String) ' este es el procedimiento para ingresar querys (insert, update, delete) para hacer un select se puede usar un rcordset o este prodedimiento&lt;br /&gt;Call conectar&lt;br /&gt;Dim qy As New ADODB.Command&lt;br /&gt;qy.ActiveConnection = cn&lt;br /&gt;qy.CommandText = sql&lt;br /&gt;qy.CommandType = adCmdText&lt;br /&gt;qy.Execute&lt;br /&gt;Call desconectar&lt;br /&gt;End Sub&lt;/span&gt;&lt;br /&gt;&lt;br /&gt;&lt;strong&gt;y solo se cambie el nombre de el ADODB…&lt;/strong&gt;&lt;br /&gt;&lt;strong&gt;&lt;br /&gt;5. Se copia la informacion de el com y se pone en las propiedades de el data emviroment en el connection 1 en connectionSourse…&lt;br /&gt;6. Se pega el sigiente codigo en el form1 en el general para que corra..&lt;br /&gt;Se pone el código…&lt;/strong&gt;&lt;br /&gt;&lt;br /&gt;&lt;span style="color:#ff0000;"&gt;Private Sub actualiza()&lt;br /&gt;Dim rc As ADODB.Recordset&lt;br /&gt;Set rc = Nothing&lt;br /&gt;Set rc = New ADODB.Recordset&lt;br /&gt;With rc&lt;br /&gt;.LockType = adLockReadOnly&lt;br /&gt;.CursorLocation = adUseClient&lt;br /&gt;.CursorType = adOpenStatic&lt;br /&gt;End With&lt;br /&gt;rc.Open "select * from empleados", con, adOpenStatic, adLockOptimistic&lt;br /&gt;Set DataGrid1.DataSource = rc&lt;br /&gt;DataGrid1.Refresh&lt;br /&gt;End Sub&lt;br /&gt;&lt;br /&gt;Private Sub nuevo()&lt;br /&gt;Text1 = Clear&lt;br /&gt;Text2 = Clear&lt;br /&gt;Text3 = Clear&lt;br /&gt;Text4 = Clear&lt;br /&gt;Text5 = Clear&lt;br /&gt;End Sub&lt;/span&gt;&lt;br /&gt;&lt;br /&gt;&lt;strong&gt;7. En el botón de guardar se pone el codigoo..&lt;br /&gt;Que es&lt;/strong&gt;&lt;br /&gt;&lt;span style="color:#ff0000;"&gt;Call mantenimiento("insert into empleados(empleado_codigo,empleado_nombre,empleado_tel,empleado_sueldo,empleado_area) Values ('" &amp;amp; Text1.Text &amp;amp; "' ,'" &amp;amp; Text2.Text &amp;amp; "','" &amp;amp; Text3.Text &amp;amp; "','" &amp;amp; Text4.Text &amp;amp; "','" &amp;amp; Text5.Text &amp;amp; "')")&lt;br /&gt;Call actualiza&lt;br /&gt;Call nuevo&lt;br /&gt;MsgBox "Registro Guardado", 32, "Exito"&lt;/fornt&gt;&lt;br /&gt;&lt;br /&gt;&lt;span style="color:#000000;"&gt;&lt;strong&gt;en el de eliminar es el de&lt;/strong&gt;&lt;br /&gt;&lt;/span&gt;&lt;br /&gt;&lt;span style="color:#ff0000;"&gt;Call mantenimiento("delete from empleados where empleado_codigo=('" &amp;amp; Text1.Text &amp;amp; "')")&lt;br /&gt;Call actualiza&lt;br /&gt;MsgBox "Registro Eliminado", 16, "Exito"&lt;br /&gt;Call nuevo&lt;/span&gt;&lt;br /&gt;&lt;br /&gt;&lt;strong&gt;&lt;span style="color:#000000;"&gt;8. Y en form se pone el código para que genere las tablas automáticamente…&lt;/span&gt;&lt;/strong&gt;&lt;br /&gt;&lt;br /&gt;&lt;span clolor="#FF0000"&gt;Private Sub Form_Load()&lt;br /&gt;Call conectar&lt;br /&gt;Call actualiza&lt;br /&gt;End Sub&lt;/span&gt;&lt;br /&gt;&lt;br /&gt;&lt;br /&gt;&lt;br /&gt;&lt;/span&gt;&lt;/span&gt;&lt;span style="color:#ff0000;"&gt;&lt;span style="color:#ff0000;"&gt;&lt;/span&gt;&lt;/span&gt;&lt;div class="blogger-post-footer"&gt;&lt;img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/4262485094358421481-8750204614267546687?l=juliocarlosmster.blogspot.com' alt='' /&gt;&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://juliocarlosmster.blogspot.com/feeds/8750204614267546687/comments/default' title='Enviar comentarios'/><link rel='replies' type='text/html' href='http://www.blogger.com/comment.g?blogID=4262485094358421481&amp;postID=8750204614267546687' title='0 comentarios'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/4262485094358421481/posts/default/8750204614267546687'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/4262485094358421481/posts/default/8750204614267546687'/><link rel='alternate' type='text/html' href='http://juliocarlosmster.blogspot.com/2009/04/como-conectar-el-programa-de-visual.html' title=''/><author><name>JC</name><uri>http://www.blogger.com/profile/01709135097126638030</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='21' height='32' src='http://2.bp.blogspot.com/_LlxmdjcK4eU/SOFbc1TvPXI/AAAAAAAAAB4/_FjmlZO7rxs/S220/Copia+de+img028.jpg'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-4262485094358421481.post-100832397173386740</id><published>2009-04-01T13:43:00.000-07:00</published><updated>2009-04-01T13:44:08.125-07:00</updated><title type='text'></title><content type='html'>&lt;strong&gt;Como crear el punto ejecutable en visual basic 2005&lt;/strong&gt;&lt;br /&gt;&lt;br /&gt;1. Lo que se hace es que se crea un &lt;br /&gt;   Nuevo proyecto&gt;Otros tipos de poryectos&gt;Proyecto de instalacion&lt;br /&gt;2. Se pone el nombre y se escoge antes el proyecto de install&lt;br /&gt;   Se va a carpeta de instalacion dentro del sistema de archivos, se da segundo    click agregar carpeta.&lt;br /&gt;3. Le damos hay en donde esta esta carpeta y le damos agragar una carpeta luego hacemos lo mismo de segundo clik pero buscamos el .exe de el que queresmos que sea el ejecutable …&lt;br /&gt;Agregar&gt;archivo.. &lt;br /&gt;4. Luego lo buscamos&lt;br /&gt;Luego le damos en generar y generamos el prototipo o el instal y ya.&lt;br /&gt;En la vara de herramientas donde esta archivos editar ver proyecto GENERAR&lt;br /&gt;Y listo ;)&lt;div class="blogger-post-footer"&gt;&lt;img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/4262485094358421481-100832397173386740?l=juliocarlosmster.blogspot.com' alt='' /&gt;&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://juliocarlosmster.blogspot.com/feeds/100832397173386740/comments/default' title='Enviar comentarios'/><link rel='replies' type='text/html' href='http://www.blogger.com/comment.g?blogID=4262485094358421481&amp;postID=100832397173386740' title='0 comentarios'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/4262485094358421481/posts/default/100832397173386740'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/4262485094358421481/posts/default/100832397173386740'/><link rel='alternate' type='text/html' href='http://juliocarlosmster.blogspot.com/2009/04/como-crear-el-punto-ejecutable-en.html' title=''/><author><name>JC</name><uri>http://www.blogger.com/profile/01709135097126638030</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='21' height='32' src='http://2.bp.blogspot.com/_LlxmdjcK4eU/SOFbc1TvPXI/AAAAAAAAAB4/_FjmlZO7rxs/S220/Copia+de+img028.jpg'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-4262485094358421481.post-7581048757084209356</id><published>2009-03-31T16:34:00.000-07:00</published><updated>2009-04-05T16:37:37.213-07:00</updated><title type='text'></title><content type='html'>&lt;strong&gt;Conexión de visual basic2005 a mysql que tienen que llevar cada Boton……….&lt;br /&gt;&lt;/strong&gt;&lt;br /&gt;&lt;strong&gt;....esto va en el form no en el load sino que en el general propio del form&lt;/strong&gt;&lt;br /&gt;&lt;br /&gt;Public Sub maximo()&lt;br /&gt;con.Open()&lt;br /&gt;Dim cons As New MySqlCommand("SELECT max(id_proveedor) as maxi FROM proveedor ", con)&lt;br /&gt;reader = cons.ExecuteReader&lt;br /&gt;If reader.Read = True Then&lt;br /&gt;codigo_proveedortext.Text = reader("maxi")&lt;br /&gt;reader.Close()&lt;br /&gt;End If&lt;br /&gt;codigo_proveedortext.Text = Val(codigo_proveedortext.Text) + 1&lt;br /&gt;con.Close()&lt;br /&gt;End Sub&lt;br /&gt;&lt;br /&gt;--------------------------------&lt;br /&gt;&lt;br /&gt;&lt;span style="font-size:85%;"&gt;Private Sub mostrar()&lt;br /&gt;Dim sql As String&lt;br /&gt;Dim cm As MySqlCommand&lt;br /&gt;Dim da As MySqlDataAdapter&lt;br /&gt;Dim ds As DataSet&lt;br /&gt;Dim ver As DataView&lt;br /&gt;sql = "SELECT * FROM proveedor"&lt;br /&gt;cm = New MySqlCommand()&lt;br /&gt;cm.CommandText = sql&lt;br /&gt;cm.CommandType = CommandType.Text&lt;br /&gt;cm.Connection = con&lt;br /&gt;da = New MySqlDataAdapter(cm)&lt;br /&gt;ds = New DataSet()&lt;br /&gt;da.Fill(ds)&lt;br /&gt;' la variable Dim vista as DataView es global a toda la clase&lt;br /&gt;ver = ds.Tables(0).DefaultView&lt;br /&gt;DataGridViewprov.DataSource = ver&lt;br /&gt;End Sub&lt;/span&gt;&lt;br /&gt;&lt;br /&gt;&lt;br /&gt;&lt;strong&gt;...esto es un metodo diferente:&lt;/strong&gt;&lt;br /&gt;Imports MySql.Data.MySqlClient&lt;br /&gt;Module Globales&lt;br /&gt;Public cont As Integer&lt;br /&gt;Public cm As MySqlCommand&lt;br /&gt;Public dr As MySqlDataReader&lt;br /&gt;Public glob As String&lt;br /&gt;Public ver As DataView&lt;br /&gt;Public sd As DataSet&lt;br /&gt;End Module&lt;br /&gt;&lt;strong&gt;&lt;/strong&gt;&lt;br /&gt;&lt;strong&gt;1. Este es el codigo de el modulo donde esta la conexión y asi se llama………&lt;/strong&gt;&lt;br /&gt;&lt;br /&gt;&lt;br /&gt;Imports MySql.Data.MySqlClient&lt;br /&gt;Module conexion&lt;br /&gt;Public con As MySqlConnection&lt;br /&gt;Public reader As MySqlDataReader&lt;br /&gt;Public Sub conectar()&lt;br /&gt;con = New MySqlConnection()&lt;br /&gt;con.ConnectionString = "server= localhost ;" _&lt;br /&gt;&amp;amp; "user id= root ;" _&lt;br /&gt;&amp;amp; "password= 123 ;" _&lt;br /&gt;&amp;amp; "database=finfin"&lt;br /&gt;Try&lt;br /&gt;con.Open()&lt;br /&gt;con.Close()&lt;br /&gt;Catch mierror As MySqlException&lt;br /&gt;MessageBox.Show("No se puede conectar al servidor de Base de Datos: " &amp;amp; mierror.Message)&lt;br /&gt;Finally&lt;br /&gt;con.Dispose()&lt;br /&gt;End Try&lt;br /&gt;End Sub&lt;br /&gt;Public Sub transaccion(ByVal sSql As String)&lt;br /&gt;Try&lt;br /&gt;Dim cmd As New MySqlCommand&lt;br /&gt;cmd.Connection = con&lt;br /&gt;cmd.CommandText = sSql&lt;br /&gt;cmd.CommandType = CommandType.Text&lt;br /&gt;con.Open()&lt;br /&gt;cmd.ExecuteNonQuery()&lt;br /&gt;con.Close()&lt;br /&gt;Catch MyEx As MySqlException&lt;br /&gt;MessageBox.Show("Error en la conexion")&lt;br /&gt;End Try&lt;br /&gt;End Sub&lt;br /&gt;End Module&lt;br /&gt;&lt;br /&gt;&lt;strong&gt;2. Este es un modulo que crea y despliega en los datagridview y se llama procedimiento……&lt;/strong&gt;&lt;br /&gt;&lt;br /&gt;Imports MySql.Data.MySqlClient&lt;br /&gt;Module procedimientos&lt;br /&gt;Public Sub rellenar()&lt;br /&gt;Dim sql As String&lt;br /&gt;Dim cm As MySqlCommand&lt;br /&gt;Dim da As MySqlDataAdapter&lt;br /&gt;sql = "SELECT * FROM proveedor"&lt;br /&gt;cm = New MySqlCommand()&lt;br /&gt;cm.CommandText = sql&lt;br /&gt;cm.CommandType = CommandType.Text&lt;br /&gt;cm.Connection = con&lt;br /&gt;da = New MySqlDataAdapter(cm)&lt;br /&gt;sd = New DataSet()&lt;br /&gt;da.Fill(sd)&lt;br /&gt;'la variable Dim vista as DataView es global a toda la clase&lt;br /&gt;ver = sd.Tables(0).DefaultView&lt;br /&gt;'grid_empleados.DataSource = vista&lt;br /&gt;&lt;br /&gt;End Sub&lt;br /&gt;Private Sub mostrar()&lt;br /&gt;'llenar un combobox o un listbox&lt;br /&gt;'Dim Sql As String&lt;br /&gt;con.Open()&lt;br /&gt;'Sql = "SELECT * FROM empleados"&lt;br /&gt;cm = New MySqlCommand()&lt;br /&gt;cm.CommandText = glob&lt;br /&gt;cm.CommandType = CommandType.Text&lt;br /&gt;cm.Connection = con&lt;br /&gt;dr = cm.ExecuteReader()&lt;br /&gt;While dr.Read()&lt;br /&gt;' nombre del control que se va a llenar&lt;br /&gt;'estatus.Items.Add(dr(0))&lt;br /&gt;End While&lt;br /&gt;dr.Close()&lt;br /&gt;End Sub&lt;br /&gt;End Module&lt;br /&gt;&lt;strong&gt;3. En el load de los Form1 va este codigo que nos ingresa al datagridview los datos… &lt;/strong&gt;&lt;br /&gt;Private Sub proveedores_Load(98ij89778&lt;br /&gt;conectar()&lt;br /&gt;mostrar()&lt;br /&gt;Dim da As New MySqlDataAdapter("SELECT max(id_proveedor) as maxi FROM proveedor", con)&lt;br /&gt;Dim ds As New DataSet&lt;br /&gt;Try&lt;br /&gt;da.Fill(ds, "proveedor")&lt;br /&gt;codigo_proveedortext.DataBindings.Add("text", ds, "proveedor.maxi")&lt;br /&gt;codigo_proveedortext.Text = Val(codigo_proveedortext.Text) + 1&lt;br /&gt;'MsgBox(codigo_proveedortext.Text)&lt;br /&gt;Catch mi As Exception&lt;br /&gt;codigo_proveedortext.Text = Val(codigo_proveedortext.Text) + 1&lt;br /&gt;MsgBox(codigo_proveedortext.Text)&lt;br /&gt;&lt;br /&gt;End Try&lt;br /&gt;End Sub&lt;br /&gt;&lt;strong&gt;4. En el boton de Guardar va este codigo…..&lt;/strong&gt;&lt;br /&gt;conectar()&lt;br /&gt;glob = ("Insert into proveedor(id_proveedor,nombre_prov,nit_prov,tel_prov,direc_prov,fecha_credito,fecha_credito_vencido,num_pagos_credito,mora_pago_atrasado,status_prov) values ('" &amp;amp; codigo_proveedortext.Text &amp;amp; "' ,'" &amp;amp; nombreproveedortext.Text &amp;amp; "','" &amp;amp; nitproveedortext.Text &amp;amp; "','" &amp;amp; numeroteltext.Text &amp;amp; "' ,'" &amp;amp; direproveedortext.Text &amp;amp; "','" &amp;amp; fechacreditotext.Text &amp;amp; "','" &amp;amp; fechacreditoventext.Text &amp;amp; "' ,'" &amp;amp; numeropagocreditotext.Text &amp;amp; "','" &amp;amp; moratext.Text &amp;amp; "','" &amp;amp; statusprovetext.Text &amp;amp; "' )")&lt;br /&gt;'total_abono,total_deuda&lt;br /&gt;transaccion(glob)&lt;br /&gt;'limpiar()&lt;br /&gt;Call procedimientos.rellenar()&lt;br /&gt;glob = "SELECT * FROM proveedor"&lt;br /&gt;ver = sd.Tables(0).DefaultView&lt;br /&gt;DataGridViewprov.DataSource = ver&lt;br /&gt;&lt;strong&gt;5. En el dataGridview va este codigo …….&lt;/strong&gt;&lt;br /&gt;codigo_proveedortext.Text = DataGridViewprov("id_proveedor", DataGridViewprov.CurrentRow.Index).Value.ToString()&lt;br /&gt;nombreproveedortext.Text = DataGridViewprov("nombre_prov", DataGridViewprov.CurrentRow.Index).Value.ToString()&lt;br /&gt;nitproveedortext.Text = DataGridViewprov("nit_prov", DataGridViewprov.CurrentRow.Index).Value.ToString()&lt;br /&gt;numeroteltext.Text = DataGridViewprov("tel_prov", DataGridViewprov.CurrentRow.Index).Value.ToString()&lt;br /&gt;direproveedortext.Text = DataGridViewprov("direc_prov", DataGridViewprov.CurrentRow.Index).Value.ToString()&lt;br /&gt;' fechacreditotext.Text = DataGridViewprov("fecha_credito", DataGridViewprov.CurrentRow.Index).Value.ToString()&lt;br /&gt;'fechacreditoventext.Text = DataGridViewprov("fecha_credito_vencido", DataGridViewprov.CurrentRow.Index).Value.ToString()&lt;br /&gt;numeropagocreditotext.Text = DataGridViewprov("num_pagos_credito", DataGridViewprov.CurrentRow.Index).Value.ToString()&lt;br /&gt;moratext.Text = DataGridViewprov("mora_pago_atrasado", DataGridViewprov.CurrentRow.Index).Value.ToString()&lt;br /&gt;totalabonotext.Text = DataGridViewprov("total_abono", DataGridViewprov.CurrentRow.Index).Value.ToString()&lt;br /&gt;totaldeudatext.Text = DataGridViewprov("total_deuda", DataGridViewprov.CurrentRow.Index).Value.ToString()&lt;br /&gt;statusprovetext.Text = DataGridViewprov("status_prov", DataGridViewprov.CurrentRow.Index).Value.ToString()&lt;br /&gt;&lt;strong&gt;6. En el de actualizar va este codigo…..&lt;/strong&gt;&lt;br /&gt;transaccion("Update proveedor Set nombre_prov=('" &amp;amp; nombreproveedortext.Text &amp;amp; "'), nit_prov=('" &amp;amp; nitproveedortext.Text &amp;amp; "'), tel_prov=('" &amp;amp; numeroteltext.Text &amp;amp; "'), direc_prov=('" &amp;amp; direproveedortext.Text &amp;amp; "'), fecha_credito=('" &amp;amp; fechacreditotext.Text &amp;amp; "'), fecha_credito_vencido= ('" &amp;amp; fechacreditoventext.Text &amp;amp; "'), num_pagos_credito= ('" &amp;amp; numeropagocreditotext.Text &amp;amp; "'), mora_pago_atrasado= ('" &amp;amp; moratext.Text &amp;amp; "'), status_prov= ('" &amp;amp; statusprovetext.Text &amp;amp; "') where id_proveedor= ('" &amp;amp; codigo_proveedortext.Text &amp;amp; "')")&lt;br /&gt;mostrar()&lt;br /&gt;&lt;strong&gt;7. En el de eliminar va este codigo….&lt;/strong&gt;&lt;br /&gt;&lt;br /&gt;glob = ("delete from proveedor where id_proveedor = ('" &amp;amp; codigo_proveedortext.Text &amp;amp; "' )")&lt;br /&gt;transaccion(glob)&lt;br /&gt;'limpiar()&lt;br /&gt;Call procedimientos.rellenar()&lt;br /&gt;glob = "SELECT * FROM proveedor"&lt;br /&gt;ver = sd.Tables(0).DefaultView&lt;br /&gt;DataGridViewprov.DataSource = ver&lt;div class="blogger-post-footer"&gt;&lt;img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/4262485094358421481-7581048757084209356?l=juliocarlosmster.blogspot.com' alt='' /&gt;&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://juliocarlosmster.blogspot.com/feeds/7581048757084209356/comments/default' title='Enviar comentarios'/><link rel='replies' type='text/html' href='http://www.blogger.com/comment.g?blogID=4262485094358421481&amp;postID=7581048757084209356' title='0 comentarios'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/4262485094358421481/posts/default/7581048757084209356'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/4262485094358421481/posts/default/7581048757084209356'/><link rel='alternate' type='text/html' href='http://juliocarlosmster.blogspot.com/2009/03/conexion-de-visual-basic2005-mysql-que.html' title=''/><author><name>JC</name><uri>http://www.blogger.com/profile/01709135097126638030</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='21' height='32' src='http://2.bp.blogspot.com/_LlxmdjcK4eU/SOFbc1TvPXI/AAAAAAAAAB4/_FjmlZO7rxs/S220/Copia+de+img028.jpg'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-4262485094358421481.post-2767499255001430516</id><published>2009-01-06T10:39:00.000-08:00</published><updated>2009-01-06T10:40:30.935-08:00</updated><title type='text'></title><content type='html'>si deceas realizar una conecion  en VIsual Basic 2005 con sql solo el servidor  ....&lt;br /&gt;&lt;br /&gt;&lt;br /&gt;Imports System.Web&lt;br /&gt;Imports System.Web.Services&lt;br /&gt;Imports System.Web.Services.Protocols&lt;br /&gt;Imports System.Data.SqlClient&lt;br /&gt;Imports System.Data&lt;br /&gt;&lt;br /&gt;&lt;webservice(namespace:="http://tempuri.org/")&gt; _&lt;br /&gt;&lt;webservicebinding(conformsto:=wsiprofiles.basicprofile1_1)&gt; _&lt;br /&gt;&lt;global.microsoft.visualbasic.compilerservices.designergenerated()&gt; _&lt;br /&gt;Public Class Service&lt;br /&gt;    Inherits System.Web.Services.WebService&lt;br /&gt;    Public Const Conection As String = "data source = 192.168.1.4; initial catalog=email;" &amp;amp; _&lt;br /&gt;                                        "user = root; password = 123"&lt;br /&gt;    Public Cnn As MySqlConnection&lt;br /&gt;    Public Cmd As MySqlCommand&lt;br /&gt;&lt;br /&gt;    &lt;webmethod(description:="realiza&gt; _&lt;br /&gt;    Public Function Conexion() As Boolean&lt;br /&gt;        Try&lt;br /&gt;            Cnn = New MySqlConnection&lt;br /&gt;            Cnn.ConnectionString = Conection&lt;br /&gt;            Return True&lt;br /&gt;        Catch ex As Exception&lt;br /&gt;            Throw&lt;br /&gt;        End Try&lt;br /&gt;    End Function&lt;br /&gt;&lt;br /&gt;    &lt;webmethod(description:="ejecuta&gt; _&lt;br /&gt;    Public Function Inst1(ByVal ISQL As String) As Boolean&lt;br /&gt;        Try&lt;br /&gt;            Conexion()&lt;br /&gt;            Cnn.Open()&lt;br /&gt;            Cmd = New MySqlCommand(ISQL, Cnn)&lt;br /&gt;            Cmd.CommandType = Data.CommandType.Text&lt;br /&gt;            Cmd.ExecuteNonQuery()&lt;br /&gt;            Cerrar()&lt;br /&gt;            Return True&lt;br /&gt;        Catch ex As Exception&lt;br /&gt;            Throw&lt;br /&gt;        End Try&lt;br /&gt;    End Function&lt;br /&gt;&lt;br /&gt;    &lt;webmethod(description:="cierra&gt; _&lt;br /&gt;    Public Function Cerrar() As Boolean&lt;br /&gt;        Try&lt;br /&gt;            Cnn.Close()&lt;br /&gt;            Return True&lt;br /&gt;        Catch ex As Exception&lt;br /&gt;            Throw&lt;br /&gt;        End Try&lt;br /&gt;    End Function&lt;br /&gt;&lt;br /&gt;    &lt;webmethod(description:="se&gt; _&lt;br /&gt;    Public Function Desconectar() As Boolean&lt;br /&gt;        Try&lt;br /&gt;            Cnn.Close()&lt;br /&gt;            Cnn.ConnectionString = Nothing&lt;br /&gt;            Return True&lt;br /&gt;        Catch ex As Exception&lt;br /&gt;            Throw&lt;br /&gt;        End Try&lt;br /&gt;    End Function&lt;br /&gt;&lt;br /&gt;    &lt;webmethod(description:="realiza&gt; _&lt;br /&gt;    Public Function Consulta(ByVal ISQL As String, ByVal Tabla As String) As DataSet&lt;br /&gt;        Try&lt;br /&gt;            Conexion()&lt;br /&gt;            Cnn.Open()&lt;br /&gt;            Dim DT As New DataSet&lt;br /&gt;            Dim DA As New MySqlDataAdapter(ISQL, Cnn)&lt;br /&gt;            DA.Fill(DT, Tabla)&lt;br /&gt;            Return DT&lt;br /&gt;        Catch ex As Exception&lt;br /&gt;            Throw&lt;br /&gt;        End Try&lt;br /&gt;    End Function&lt;br /&gt;&lt;br /&gt;End Class&lt;br /&gt;&lt;br /&gt;&lt;div class="blogger-post-footer"&gt;&lt;img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/4262485094358421481-2767499255001430516?l=juliocarlosmster.blogspot.com' alt='' /&gt;&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://juliocarlosmster.blogspot.com/feeds/2767499255001430516/comments/default' title='Enviar comentarios'/><link rel='replies' type='text/html' href='http://www.blogger.com/comment.g?blogID=4262485094358421481&amp;postID=2767499255001430516' title='0 comentarios'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/4262485094358421481/posts/default/2767499255001430516'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/4262485094358421481/posts/default/2767499255001430516'/><link rel='alternate' type='text/html' href='http://juliocarlosmster.blogspot.com/2009/01/si-deceas-realizar-una-conecion-en.html' title=''/><author><name>JC</name><uri>http://www.blogger.com/profile/01709135097126638030</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='21' height='32' src='http://2.bp.blogspot.com/_LlxmdjcK4eU/SOFbc1TvPXI/AAAAAAAAAB4/_FjmlZO7rxs/S220/Copia+de+img028.jpg'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-4262485094358421481.post-6570022156530077018</id><published>2008-10-09T14:48:00.000-07:00</published><updated>2010-09-30T21:04:18.130-07:00</updated><title type='text'></title><content type='html'>&lt;a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="http://3.bp.blogspot.com/_LlxmdjcK4eU/TKVdrDULEHI/AAAAAAAAADE/2zUiNdj0Wfc/s1600/prueba.jpg"&gt;&lt;img style="margin: 0px auto 10px; display: block; text-align: center; cursor: pointer; width: 400px; height: 219px;" src="http://3.bp.blogspot.com/_LlxmdjcK4eU/TKVdrDULEHI/AAAAAAAAADE/2zUiNdj0Wfc/s400/prueba.jpg" alt="" id="BLOGGER_PHOTO_ID_5522923512245457010" border="0" /&gt;&lt;/a&gt;&lt;br /&gt;&lt;p&gt;&lt;br /&gt;&lt;/p&gt;&lt;p&gt;&lt;br /&gt;&lt;/p&gt;&lt;p&gt;&lt;a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="http://3.bp.blogspot.com/_LlxmdjcK4eU/SO58aZhh4fI/AAAAAAAAACk/Oo9ajsv7rEo/s1600-h/wolverine+vs+hulk+por+julio.jpg"&gt;&lt;img style="margin: 0px auto 10px; display: block; text-align: center; cursor: pointer;" src="http://3.bp.blogspot.com/_LlxmdjcK4eU/SO58aZhh4fI/AAAAAAAAACk/Oo9ajsv7rEo/s400/wolverine+vs+hulk+por+julio.jpg" alt="" id="BLOGGER_PHOTO_ID_5255274608157909490" border="0" /&gt;&lt;/a&gt;&lt;br /&gt;&lt;/p&gt;&lt;h3 class="post-title"&gt;&lt;a href="http://komics.blogcindario.com/2006/10/00005-wolverine-vs-hulk-el-encuentro-definitivo.html"&gt;Wolverine VS Hulk, el encuentro definitivo.&lt;/a&gt;&lt;/h3&gt;          &lt;!-- google_ad_section_start --&gt;Entre lo mejor de los títulos que ofrece actualmente la compañía Marvel esta Hulk VS Wolverine, miniserie que corresponde al Universo Ultimate y que ha causado gran expectativa desde el anuncio de su realización. Básicamente, esta saga recupera un enfrentamiento que se produjo en el número 181 del Incredible Hulk, y que marco lo que fue la primera aparición de Wolverine dentro de los comics. Sin embargo, a diferencia de aquel primer enfrentamiento, en esta ocasión, aunque se toma como eje central la batalla entre estos 2 antihéroes por excelencia, la historia se centra mucho mas en los personajes, sus sentimientos, sus contextos y sus motivaciones, que desembocan en una pelea de furia incontenible. &lt;p&gt;wolverine vs hulk por julio &lt;/p&gt;&lt;div class="blogger-post-footer"&gt;&lt;img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/4262485094358421481-6570022156530077018?l=juliocarlosmster.blogspot.com' alt='' /&gt;&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://juliocarlosmster.blogspot.com/feeds/6570022156530077018/comments/default' title='Enviar comentarios'/><link rel='replies' type='text/html' href='http://www.blogger.com/comment.g?blogID=4262485094358421481&amp;postID=6570022156530077018' title='0 comentarios'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/4262485094358421481/posts/default/6570022156530077018'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/4262485094358421481/posts/default/6570022156530077018'/><link rel='alternate' type='text/html' href='http://juliocarlosmster.blogspot.com/2008/10/wolverine-vs-hulk-por-julio.html' title=''/><author><name>JC</name><uri>http://www.blogger.com/profile/01709135097126638030</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='21' height='32' src='http://2.bp.blogspot.com/_LlxmdjcK4eU/SOFbc1TvPXI/AAAAAAAAAB4/_FjmlZO7rxs/S220/Copia+de+img028.jpg'/></author><media:thumbnail xmlns:media='http://search.yahoo.com/mrss/' url='http://3.bp.blogspot.com/_LlxmdjcK4eU/TKVdrDULEHI/AAAAAAAAADE/2zUiNdj0Wfc/s72-c/prueba.jpg' height='72' width='72'/><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-4262485094358421481.post-4512051190785875615</id><published>2008-10-01T16:14:00.000-07:00</published><updated>2008-10-01T16:15:08.228-07:00</updated><title type='text'></title><content type='html'>&lt;a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="http://i175.photobucket.com/albums/w126/wolfie_matt/wolves/Van_Helsing_Fan_art_by_wolf_wind-1.jpg"&gt;&lt;img style="float:left; margin:0 10px 10px 0;cursor:pointer; cursor:hand;width: 400px;" src="http://i175.photobucket.com/albums/w126/wolfie_matt/wolves/Van_Helsing_Fan_art_by_wolf_wind-1.jpg" border="0" alt="" /&gt;&lt;/a&gt;&lt;div class="blogger-post-footer"&gt;&lt;img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/4262485094358421481-4512051190785875615?l=juliocarlosmster.blogspot.com' alt='' /&gt;&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://juliocarlosmster.blogspot.com/feeds/4512051190785875615/comments/default' title='Enviar comentarios'/><link rel='replies' type='text/html' href='http://www.blogger.com/comment.g?blogID=4262485094358421481&amp;postID=4512051190785875615' title='0 comentarios'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/4262485094358421481/posts/default/4512051190785875615'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/4262485094358421481/posts/default/4512051190785875615'/><link rel='alternate' type='text/html' href='http://juliocarlosmster.blogspot.com/2008/10/blog-post.html' title=''/><author><name>JC</name><uri>http://www.blogger.com/profile/01709135097126638030</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='21' height='32' src='http://2.bp.blogspot.com/_LlxmdjcK4eU/SOFbc1TvPXI/AAAAAAAAAB4/_FjmlZO7rxs/S220/Copia+de+img028.jpg'/></author><media:thumbnail xmlns:media='http://search.yahoo.com/mrss/' url='http://i175.photobucket.com/albums/w126/wolfie_matt/wolves/th_Van_Helsing_Fan_art_by_wolf_wind-1.jpg' height='72' width='72'/><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-4262485094358421481.post-8752259588256466010</id><published>2008-10-01T15:43:00.000-07:00</published><updated>2008-10-01T16:14:29.469-07:00</updated><title type='text'></title><content type='html'>&lt;div align="left"&gt;&lt;strong&gt;&lt;span style="font-size:130%;"&gt;&lt;span style="font-family:arial;"&gt;Hi, Este es mi citio Web.&lt;/span&gt;&lt;/span&gt;&lt;/strong&gt;&lt;/div&gt;&lt;div align="left"&gt;&lt;/div&gt;&lt;div align="left"&gt;&lt;a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}"&gt;&lt;img style="float:left; margin:0 10px 10px 0;cursor:pointer; cursor:hand;" src="http://srv0110-07.oak1.imeem.com/g/p/021b56767663b8bf4d99a74b2289cd71_web.jpg" border="0" alt="" id="BLOGGER_PHOTO_ID_5252320086021941186" /&gt;&lt;/a&gt;&lt;br /&gt;&lt;br /&gt;HI fotos cool &lt;img style="float:left; margin:0 10px 10px 0;cursor:pointer; cursor:hand;" src="http://www.poster.net/lord-of-the-rings/lord-of-the-rings-photo-xxl-lord-of-the-rings-6228668.jpg" border="0" alt="" id="BLOGGER_PHOTO_ID_5252320086021941186" /&gt;&lt;br /&gt;&lt;br /&gt;HI fotos cool &lt;img style="float:left; margin:0 10px 10px 0;cursor:pointer; cursor:hand;" src="http://i4.photobucket.com/albums/y126/LCG5000/Lord_of_the_Rings.jpg" border="0" alt="" id="BLOGGER_PHOTO_ID_5252320086021941186" /&gt;&lt;br /&gt;HI fotos cool &lt;img style="float:left; margin:0 10px 10px 0;cursor:pointer; cursor:hand;" src="http://www.linkmesh.com/imagenes/temas/duendes/elfa_arquera.jpg" border="0" alt="" id="BLOGGER_PHOTO_ID_5252320086021941186" /&gt;&lt;br /&gt;&lt;br /&gt;&lt;br /&gt;&lt;br /&gt;&lt;/div&gt;&lt;div class="blogger-post-footer"&gt;&lt;img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/4262485094358421481-8752259588256466010?l=juliocarlosmster.blogspot.com' alt='' /&gt;&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://juliocarlosmster.blogspot.com/feeds/8752259588256466010/comments/default' title='Enviar comentarios'/><link rel='replies' type='text/html' href='http://www.blogger.com/comment.g?blogID=4262485094358421481&amp;postID=8752259588256466010' title='0 comentarios'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/4262485094358421481/posts/default/8752259588256466010'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/4262485094358421481/posts/default/8752259588256466010'/><link rel='alternate' type='text/html' href='http://juliocarlosmster.blogspot.com/2008/10/hi-este-es-mi-citio-web.html' title=''/><author><name>JC</name><uri>http://www.blogger.com/profile/01709135097126638030</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='21' height='32' src='http://2.bp.blogspot.com/_LlxmdjcK4eU/SOFbc1TvPXI/AAAAAAAAAB4/_FjmlZO7rxs/S220/Copia+de+img028.jpg'/></author><thr:total>0</thr:total></entry></feed>
