1、直接上代码:
{
static void Main(string[] args)
{
string connStr = "Database=game01;datasource=127.0.0.1;port=3306;user=root;pwd=root;";
MySqlConnection conn = new MySqlConnection(connStr);
conn.Open();
#region 查询
//MySqlCommand cmd = new MySqlCommand("select * from user", conn);
//MySqlDataReader reader = cmd.ExecuteReader();
//while (reader.Read())
//{
// string username = reader.GetString("username");
// string password = reader.GetString("password");
// Console.WriteLine(username + ":" + password);
//}
//reader.Close();
#endregion
#region 插入
string username = "cwer"; string password = "lcker';del