using System;
using System.Collections.Generic;
using System.Text;
using MySql.Data.MySqlClient;
namespace CSharpConnectMySqlDemo1
{
class Program
{
static void Main(string[] args)
{
string connectStr = "server=127.0.0.1;port=3306;database=mygamedb;user=root;password=root";
MySqlConnection conn = new MySqlConnection(connectStr); //并沒有去跟資料庫建立連接
try
{
conn.Open(); //與MySQL資料庫建立連接
string sql = "select * from users"; //sql查詢陳述句
MySqlCommand cmd = new MySqlCommand(sql,conn);
//cmd.ExecuteReader();//執行一些查詢
//cmd.ExecuteNonQuery();//插入 洗掉
//cmd.ExecuteScalar();//執行一些查詢，回傳一些單個的值
MySqlDataReader reader = cmd.ExecuteReader();
//reader.Read(); //讀取下一行資料，如果讀取成功，回傳true，如果沒有下一行的話，讀取失敗的話，回傳false
//Console.WriteLine(reader[0].ToString() + " " + reader[1].ToString() + " " + reader[2].ToString());
//reader.Read();
//Console.WriteLine(reader[0].ToString() + " " + reader[1].ToString() + " " + reader[2].ToString());
while (reader.Read())
{
Console.WriteLine(reader[0].ToString()+" "+reader[1].ToString()+" "+reader[2].ToString());
}
Console.WriteLine("已經建立連接");
}
catch (Exception e)
{
Console.WriteLine(e.ToString());
}
finally
{
conn.Close();
}
Console.ReadKey();
}
}
}
轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/258074.html
標籤：其他