C#------ExecuteReader

標籤：

    class Program    {        static void Main(string[] args)        {            //串連資料庫            using( MySqlConnection conn = new MySqlConnection("Server=localhost; Database=study; uid=root; pwd=root; Charset=utf8;") )            //建立資料庫物件            using (MySqlCommand cmd = conn.CreateCommand())            {                conn.Open();                cmd.CommandText = "SELECT * FROM t_customers";                using (MySqlDataReader read = cmd.ExecuteReader())                {                    while (read.Read())//讀取每行資料                    {                        //擷取欄位資訊                        int id = read.GetInt32("Id");                        string name = read.GetString("Name");                        string age = read.GetString("Age");                        Console.WriteLine(id + name + age);                    }                }            }            Console.ReadKey();        }    }

 

C#------ExecuteReader