.net连接MySQL数据库的方案与实例演示
作者:IT科技 来源:数据库 浏览: 【大中小】 发布时间:2025-11-04 00:24:55 评论数:
复制using System; using System.Net; using System.Text; using CoreLab.MySQL; using System.Data.Odbc; using MySQL.Data.MySQLClient; class ConnectMySQL { public void Connect_CoreLab() { string constr = "User Id=root;Host=localhost;Database=qing;password=qing"; MySQLConnection mycn = newMySQLConnection(constr); mycn.Open(); MySQLCommand mycm = newMySQLCommand("select * from shop",数据实例mycn); MySQLDataReader msdr = mycm.ExecuteReader(); while(msdr.Read()) { if (msdr.HasRows) { Console.WriteLine(msdr.GetString(0)); } } msdr.Close(); mycn.Close(); } public void Connect_Odbc() { //string MyConString ="DSN=MySQL;UID=root;PWD=qing"; string MyConString = "DRIVER={MySQL ODBC 3.51 Driver};" + "SERVER=localhost;" + "DATABASE=test;" + "UID=root;" + "PASSWORD=qing;" + "OPTION=3"; OdbcConnection MyConn = new OdbcConnection(MyConString); MyConn.Open(); OdbcCommand mycm = new OdbcCommand("select * from hello",MyConn); OdbcDataReader msdr = mycm.ExecuteReader(); while(msdr.Read()) { if (msdr.HasRows) { Console.WriteLine(msdr.GetString(0)); } } msdr.Close(); MyConn.Close(); } public void Connect_Net() { string myConnectionString = "Database=test;Data Source=localhost;User Id=root;Password=qing"; MySQLConnection mycn = newMySQLConnection(myConnectionString); mycn.Open(); MySQLCommand mycm = newMySQLCommand("select * from hello",mycn); MySQLDataReader msdr = mycm.ExecuteReader(); while(msdr.Read()) { if (msdr.HasRows) { Console.WriteLine(msdr.GetString(0)); } } msdr.Close(); mycn.Close(); } public static void Main() { ConnectMySQLms = new ConnectMySQL(); ms.Connect_CoreLab(); ms.Connect_Odbc(); Connect_Net(); } } 1.2.3.4.5.6.7.8.9.10.11.12.13.14.15.16.17.18.19.20.21.22.23.24.25.26.27.28.29.30.31.32.33.34.35.36.37.38.39.40.41.42.43.44.45.46.47.48.49.50.51.52.53.54.55.56.57.58.59.60.61.62.63.64.65.66.67.68.69.70.71.72.73.