实例讲解：.NET如何访问MySQL数据库

欢迎您访问我爱IT技术网，今天小编为你分享的编程技术是：【实例讲解：.NET如何访问MySQL数据库】，下面是详细的分享！

实例讲解：.NET如何访问MySQL数据库

#region LICENSE

#endregion
using System;
using System.Data;
using System.Runtime.InteropServices;
namespace MySQLDriverCS
{
     //[StructLayout(LayoutKind.Sequential)]
     public class MYSQL_FIELD_FACTORY
     {
         static string version;
         public static IMYSQL_FIELD GetInstance()
         {
 
              if (version==null)
              {
                   version=CPrototypes.GetClientInfo();
              }
              if (version.CompareTo("4.1.2-alpha")>=0)
              {
                   return new MYSQL_FIELD_VERSION_5();
              }
              else
                   return new MYSQL_FIELD_VERSION_3();
         }
     }
     public interface IMYSQL_FIELD
     {
         string Name{get;}
         uint Type{get;}
         long Max_Length     {get;}
     }
     ///<summary>
     /// Field descriptor
     ///</summary>
     [StructLayout(LayoutKind.Sequential)]//"3.23.32", 4.0.1-alpha
     internal class MYSQL_FIELD_VERSION_3: IMYSQL_FIELD
     {
         ///<summary>
         /// Name of column
         ///</summary>
         public string name;         
         ///<summary>
         /// Table of column if column was a field
         ///</summary>
         public string table;         
          //public string org_table;             
          //public string db;            
         ///<summary>
         /// def
         ///</summary>
         public string def;           
         ///<summary>
         /// length
         ///</summary>
         public long length;     
         ///<summary>
         /// max_length
         ///</summary>
         public long max_length;    
         ///<summary>
         /// Div flags
         ///</summary>
         public uint flags;        
         ///<summary>
         /// Number of decimals in field
         ///</summary>
         public uint decimals;     
         ///<summary>
         /// Type of field. Se mysql_com.h for types
         ///</summary>
         public uint type;
 
         ///<summary>
         /// Name
         ///</summary>
         public string Name
         {
              get{return name;}
         }
         ///<summary>
         /// Type
         ///</summary>
         public uint Type
         {
              get{return type;}
         }
         ///<summary>
         /// Max_Length
         ///</summary>
         public long Max_Length
         {
              get     {return max_length;}
         }
     }
 
     ///<summary>
     /// Field descriptor
     ///</summary>
     [StructLayout(LayoutKind.Sequential)]
     internal class MYSQL_FIELD_VERSION_5: IMYSQL_FIELD
     {
         ///<summary>
         /// Name of column
         ///</summary>
         public string name;     
         ///<summary>
         /// Original column name, if an alias
         ///</summary>
         public string org_name;    
         ///<summary>
         /// Table of column if column was a field
         ///</summary>
         public string table;     
         ///<summary>
         /// Org table name if table was an alias
         ///</summary>
         public string org_table;    
         ///<summary>
         /// Database for table
         ///</summary>
         public string db;            
         ///<summary>
         /// Catalog for table
         ///</summary>
          //public string catalog;          
         ///<summary>
         /// def
         ///</summary>
         public string def;           
         ///<summary>
         /// length
         ///</summary>
         public long length;     
         ///<summary>
          /// max_length
         ///</summary>
         public long max_length;    
         ///<summary>
         /// name_length
         ///</summary>
          //public uint name_length;
         ///<summary>
         /// org_name_length
         ///</summary>
         public uint org_name_length;
         ///<summary>
         /// table_length
         ///</summary>
         public uint table_length;
         ///<summary>
         /// org_table_length
         ///</summary>
         public uint org_table_length;
         ///<summary>
         /// db_length
         ///</summary>
         public uint db_length;
         ///<summary>
         /// catalog_length
         ///</summary>
         public uint catalog_length;
         ///<summary>
         /// def_length
         ///</summary>
         public uint def_length;
         ///<summary>
         /// Div flags
         ///</summary>
         public uint flags;        
         ///<summary>
         /// Number of decimals in field
         ///</summary>
         public uint decimals;     
         ///<summary>
         /// Character set
         ///</summary>
         public uint charsetnr;    
         ///<summary>
         /// Type of field. Se mysql_com.h for types
         ///</summary>
         public uint type;
 
         ///<summary>
         /// Name
         ///</summary>
         public string Name
         {
              get     {return name;}
         }
         ///<summary>
         /// Type
         ///</summary>
         public uint Type
         {
              get     {return type;}
         }
         ///<summary>
         /// Max_Length
         ///</summary>
         public long Max_Length
         {
              get     {return max_length;}
         }
     }
 
     //[StructLayout(LayoutKind.Explicit)]
     public enum enum_field_types
     {
          FIELD_TYPE_DECIMAL, FIELD_TYPE_TINY,
                              FIELD_TYPE_SHORT, FIELD_TYPE_LONG,
                              FIELD_TYPE_FLOAT, FIELD_TYPE_DOUBLE,
                              FIELD_TYPE_NULL,   FIELD_TYPE_TIMESTAMP,
                              FIELD_TYPE_LONGLONG,FIELD_TYPE_INT24,
                              FIELD_TYPE_DATE,   FIELD_TYPE_TIME,
                              FIELD_TYPE_DATETIME, FIELD_TYPE_YEAR,
                              FIELD_TYPE_NEWDATE,
                              FIELD_TYPE_ENUM=247,
                              FIELD_TYPE_SET=248,
                              FIELD_TYPE_TINY_BLOB=249,
                              FIELD_TYPE_MEDIUM_BLOB=250,
                              FIELD_TYPE_LONG_BLOB=251,
                              FIELD_TYPE_BLOB=252,
                              FIELD_TYPE_VAR_STRING=253,
                              FIELD_TYPE_STRING=254,
                              FIELD_TYPE_GEOMETRY=255
 
     };
 
     ///<summary>
     /// C prototypes warpper for mysqllib.
     ///</summary>
     internal class CPrototypes
     {
          [ DllImport( "libmySQL.dll", EntryPoint="mysql_init" )]
         unsafe public static extern void* mysql_init(void* must_be_null);
          [ DllImport( "libmySQL.dll", EntryPoint="mysql_close" )]
         unsafe public static extern void mysql_close(void* handle);
        
         // BEGIN ADDITION 2004-07-01 BY Alex Seewald
         // Enables us to call mysql_option to activate compression and timeout
          [ DllImport( "libmySQL.dll", EntryPoint="mysql_options" )]     
         unsafe public static extern void mysql_options(void* mysql, uint option, uint *value);
         // END ADDITION 2004-07-01 By Alex Seewald
 
 
          [ DllImport( "libmySQL.dll", EntryPoint="mysql_real_connect" )]
         unsafe public static extern void* mysql_real_connect(void* mysql, string host, string user, string passwd, string db, uint port, string unix_socket, int client_flag);
          [ DllImport( "libmySQL.dll", EntryPoint="mysql_query" )]
         unsafe public static extern int mysql_query(void*mysql, string query);
          [ DllImport( "libmySQL.dll", EntryPoint="mysql_store_result" )]
         unsafe public static extern void *mysql_store_result(void *mysql);
          [ DllImport( "libmySQL.dll", EntryPoint="mysql_free_result" )]
         unsafe public static extern void mysql_free_result(void*result);
          [ DllImport( "libmySQL.dll", EntryPoint="mysql_errno" )]
         unsafe public static extern uint mysql_errno(void*mysql);
          [ DllImport( "libmySQL.dll", EntryPoint="mysql_error" )]
         unsafe public static extern string mysql_error(void*mysql);
          [ DllImport( "libmySQL.dll", EntryPoint="mysql_field_count" )]
         unsafe public static extern uint mysql_field_count(void*mysql);
          [ DllImport( "libmySQL.dll", EntryPoint="mysql_affected_rows" )]
         unsafe public static extern ulong mysql_affected_rows(void*mysql);
          [ DllImport( "libmySQL.dll", EntryPoint="mysql_num_fields" )]
         unsafe public static extern uint mysql_num_fields(void*result);
          [ DllImport( "libmySQL.dll", EntryPoint="mysql_num_rows" )]
         unsafe public static extern ulong mysql_num_rows(void *result);
          [ DllImport( "libmySQL.dll", EntryPoint="mysql_fetch_field_direct" )]
         unsafe public static extern IntPtr mysql_fetch_field_direct(void*result, uint fieldnr);
 
          ///<returns>Returns a string that represents the client library version</returns>
          [DllImport("libmySQL.dll",CharSet=System.Runtime.InteropServices.CharSet.Ansi,
          EntryPoint="mysql_get_client_info", ExactSpelling=true)]
         public static extern string GetClientInfo();
 
          [ DllImport( "libmySQL.dll", EntryPoint="mysql_fetch_row" )]
         unsafe public static extern IntPtr mysql_fetch_row(void*result);
          [ DllImport( "libmySQL.dll", EntryPoint="mysql_select_db" )]
         unsafe public static extern int mysql_select_db(void*mysql,string dbname);
          [ DllImport( "libmySQL.dll", EntryPoint="mysql_fetch_lengths" )]
         unsafe public static extern UInt32 *mysql_fetch_lengths(void*result);
 
     }
}

以上所分享的是关于实例讲解：.NET如何访问MySQL数据库，下面是编辑为你推荐的有价值的用户互动：

　　相关问题：如何在.NET中访问MySQL数据库

　　答：直接通过数据库的用户名、密码等连接到数据库进行数据库连接。 如：private void sqlconn() { SqlConncetion conn = new SqlConnection("SERVER=.;DATABASE=pubs;PWD=;UID=sa;"); SqlConncetion cmd = new SqlCommand("SELECT*FROM [table]",cmd... >>详细

　　相关问题：SQL数据库怎么操作？

　　答：命令行： 1、显示当前数据库服务器中的数据库列表：mysql> SHOW DATABASES; 2、建立数据库：mysql> CREATE DATABASE 库名; 3、建立数据表：mysql> USE 库名;mysql> CREATE TABLE 表名 (字段名 VARCHAR(20), 字段名 CHAR(1)); 4、删除数据库：mys... >>详细

　　相关问题：在mysql数据库中怎么样查看数据库中的所有内容？

　　答：你要是想用命令行的话，下面给你一些命令（MyＳＱＬ） 启动,关闭MySQL 在CMD中输入: net start mysql 在服务管理器中启动,关闭. MySQL登录 在CMD中输入 mysql –h localhost –u root -p 查看数据库: show databases; 使用数据库: use db_name; 查... >>详细