using System;
using System.Data;
using MySql.Data.MySqlClient;
namespace Connection_MySql
{
class Program
{
static void Main(string[] args)
{
//获得MySql的配置信息
string connStr = "server = 127.0.0.1; port = 3306; user = root; password = 360412abc; database = my_student;";
//连接数据库
MySqlConnection MySqlCon = new MySqlConnection(connStr);
//建立DataSet对象(相当于建立前台的虚拟数据库)
DataSet Ds = new DataSet();
//建立DataTable对象(相当于建立前台的虚拟数据库中的数据表)
DataTable DtableStudentInfo;
//建立DataRowCollection对象(相当于表中行的集合)
DataRowCollection TableRow;
//建立DataRow对象(相当于表中列的集合)
DataRow TableColumn;
//打开连接
MySqlCon.Open();
//建立DataAdapter对象
string sltStr = "select id,username,userid from student_info;";
MySqlCommand MysqlCmd = new MySqlCommand(sltStr, MySqlCon);
MySqlDataAdapter Msda = new MySqlDataAdapter(MysqlCmd);
//将查询的结果存到虚拟数据库Ds中的虚拟表StudentInfo中
Msda.Fill(Ds, "StudentInfo");
//将数据表StudentInfo的数据复制到DataTable对象中
DtableStudentInfo = Ds.Tables["StudentInfo"];
//用DataRowCollection对象获取这个数据表的所有数据行
TableRow = DtableStudentInfo.Rows;
string infoString = "";
//逐行遍历,取出各行的数据
for (int i = 0; i < TableRow.Count; i++)
{
TableColumn = TableRow[i];
infoString += "id: " + TableColumn[0];
infoString += " username: " + TableColumn[1];
infoString += " userid: " + TableColumn[2] + "<br />" + "\n";
}
Console.WriteLine(infoString);
MySqlCon.Close();
Console.ReadKey();
}
}
}
运行结果:
---------------------
原文:https://blog.csdn.net/qq_34404196/article/details/84938597