Download - InstalarDriver_NET_paramysql
![Page 1: InstalarDriver_NET_paramysql](https://reader036.vdocumento.com/reader036/viewer/2022070319/557b9456d8b42aa0758b46a0/html5/thumbnails/1.jpg)
Instalar Driver para MySQLMySQL Conector Net 6.5.4
MI Jesús Alejandro Flores Hernández
![Page 2: InstalarDriver_NET_paramysql](https://reader036.vdocumento.com/reader036/viewer/2022070319/557b9456d8b42aa0758b46a0/html5/thumbnails/2.jpg)
Objetivo
Realizar consultas a una base de datos en MySql desde una aplicación .NET con el lenguaje Visual Basic.
![Page 3: InstalarDriver_NET_paramysql](https://reader036.vdocumento.com/reader036/viewer/2022070319/557b9456d8b42aa0758b46a0/html5/thumbnails/3.jpg)
Requerimientos
Para esta práctica necesita:Tener instalado Sharp DevelopTener instalado una versión de
MySql (para este ejemplo se uso WAMP Server ver 2.2) y Heidi SQL como administrador para MySql.
Haber creado la base de datos provPar con almenos la tabla partes.
Tener datos cargados en la tabla partes
![Page 4: InstalarDriver_NET_paramysql](https://reader036.vdocumento.com/reader036/viewer/2022070319/557b9456d8b42aa0758b46a0/html5/thumbnails/4.jpg)
Objetos de MySqlPara usar los objetos de conexión a MySql
Dim conn As MySqlConnectionDim da As MySqlDataAdapterDom comando as MySqlCommand
En su código deberá agregar la referencia:
Imports MySql.Data.MySqlClient
como se muestra en la diapositiva 17.
![Page 5: InstalarDriver_NET_paramysql](https://reader036.vdocumento.com/reader036/viewer/2022070319/557b9456d8b42aa0758b46a0/html5/thumbnails/5.jpg)
Sin embargo si deseamos agregar referencia “MySql.Data” para MySql En Sharp Develop o Visual Studio
![Page 6: InstalarDriver_NET_paramysql](https://reader036.vdocumento.com/reader036/viewer/2022070319/557b9456d8b42aa0758b46a0/html5/thumbnails/6.jpg)
No existe
Debemos Instalarla
![Page 7: InstalarDriver_NET_paramysql](https://reader036.vdocumento.com/reader036/viewer/2022070319/557b9456d8b42aa0758b46a0/html5/thumbnails/7.jpg)
Para instalarla, del sitio de MySQL baje:
![Page 9: InstalarDriver_NET_paramysql](https://reader036.vdocumento.com/reader036/viewer/2022070319/557b9456d8b42aa0758b46a0/html5/thumbnails/9.jpg)
Clic aquí
![Page 10: InstalarDriver_NET_paramysql](https://reader036.vdocumento.com/reader036/viewer/2022070319/557b9456d8b42aa0758b46a0/html5/thumbnails/10.jpg)
clic
![Page 11: InstalarDriver_NET_paramysql](https://reader036.vdocumento.com/reader036/viewer/2022070319/557b9456d8b42aa0758b46a0/html5/thumbnails/11.jpg)
Inicia descarga
![Page 12: InstalarDriver_NET_paramysql](https://reader036.vdocumento.com/reader036/viewer/2022070319/557b9456d8b42aa0758b46a0/html5/thumbnails/12.jpg)
Una vez descargado, en donde lo bajo
1 clic aqui2 clic aqui
![Page 13: InstalarDriver_NET_paramysql](https://reader036.vdocumento.com/reader036/viewer/2022070319/557b9456d8b42aa0758b46a0/html5/thumbnails/13.jpg)
verá en su carpeta descargas (download)
![Page 14: InstalarDriver_NET_paramysql](https://reader036.vdocumento.com/reader036/viewer/2022070319/557b9456d8b42aa0758b46a0/html5/thumbnails/14.jpg)
Ejecútelo para empezar a instalar
![Page 15: InstalarDriver_NET_paramysql](https://reader036.vdocumento.com/reader036/viewer/2022070319/557b9456d8b42aa0758b46a0/html5/thumbnails/15.jpg)
Al iniciar la instalación clic
![Page 16: InstalarDriver_NET_paramysql](https://reader036.vdocumento.com/reader036/viewer/2022070319/557b9456d8b42aa0758b46a0/html5/thumbnails/16.jpg)
Versión típica
![Page 17: InstalarDriver_NET_paramysql](https://reader036.vdocumento.com/reader036/viewer/2022070319/557b9456d8b42aa0758b46a0/html5/thumbnails/17.jpg)
Listo
Ahora para agregar la referencia desde Sharp Develop
![Page 18: InstalarDriver_NET_paramysql](https://reader036.vdocumento.com/reader036/viewer/2022070319/557b9456d8b42aa0758b46a0/html5/thumbnails/18.jpg)
En el menú clic en proyecto Agregar referencia
![Page 19: InstalarDriver_NET_paramysql](https://reader036.vdocumento.com/reader036/viewer/2022070319/557b9456d8b42aa0758b46a0/html5/thumbnails/19.jpg)
Agregar referencia La buscamos y Ya existeDamos clic enSeleccionamos y clic en ok
![Page 20: InstalarDriver_NET_paramysql](https://reader036.vdocumento.com/reader036/viewer/2022070319/557b9456d8b42aa0758b46a0/html5/thumbnails/20.jpg)
Ejemplo
A continuación un ejemplo, asegúrese de agregar la referencia que se muestra en la diapositiva anterior para que funcione el ejemplo.
![Page 21: InstalarDriver_NET_paramysql](https://reader036.vdocumento.com/reader036/viewer/2022070319/557b9456d8b42aa0758b46a0/html5/thumbnails/21.jpg)
Base de datos <provpar> en MySql (WAMPServer) con la interface Heidi
![Page 22: InstalarDriver_NET_paramysql](https://reader036.vdocumento.com/reader036/viewer/2022070319/557b9456d8b42aa0758b46a0/html5/thumbnails/22.jpg)
![Page 23: InstalarDriver_NET_paramysql](https://reader036.vdocumento.com/reader036/viewer/2022070319/557b9456d8b42aa0758b46a0/html5/thumbnails/23.jpg)
![Page 24: InstalarDriver_NET_paramysql](https://reader036.vdocumento.com/reader036/viewer/2022070319/557b9456d8b42aa0758b46a0/html5/thumbnails/24.jpg)
![Page 25: InstalarDriver_NET_paramysql](https://reader036.vdocumento.com/reader036/viewer/2022070319/557b9456d8b42aa0758b46a0/html5/thumbnails/25.jpg)
![Page 26: InstalarDriver_NET_paramysql](https://reader036.vdocumento.com/reader036/viewer/2022070319/557b9456d8b42aa0758b46a0/html5/thumbnails/26.jpg)
![Page 27: InstalarDriver_NET_paramysql](https://reader036.vdocumento.com/reader036/viewer/2022070319/557b9456d8b42aa0758b46a0/html5/thumbnails/27.jpg)
![Page 28: InstalarDriver_NET_paramysql](https://reader036.vdocumento.com/reader036/viewer/2022070319/557b9456d8b42aa0758b46a0/html5/thumbnails/28.jpg)
ReferenciasHeidi: http://www.heidisql.com/WAMP:
http://www.wampserver.com/en/Sharp Develop:
http://www.icsharpcode.net/OpenSource/SD/