C# + MySqlDataReader 連接 MySQL

 

   C# + MySqlDataReader 連接 MySQL
 
   using System;
   using System.Collections.Generic;
   using System.ComponentModel;
   using System.Data;
   using System.Drawing;
   using System.Linq;
   using System.Text;
   using System.Windows.Forms;
   using MySql.Data.MySqlClient;
 
   namespace WindowsFormsApplication1
   {
      public partial class Form1 : Form
      {
 
         public Form1()
         {
            InitializeComponent();
         }
 
         private void Form1_Load(object sender, EventArgs e)
         {
 
         }
 
         private void button1_Click(object sender, EventArgs e)
         {
            get_result();
         }
 
         private void get_result()
         {
 
            this.dataGridView1.Columns.Add("ID", "ID");
            this.dataGridView1.Columns.Add("News_Names", "News_Names");
 
            String connectionString;
            MySqlConnection conn;
            String SQL_Statement;
            MySqlCommand cmd;
            MySqlDataReader dr;
 
            connectionString = "server=<Host Name>;UId=<Login>;Pwd=<Password>;database=<Database Name>";
 
            conn = new MySqlConnection(connectionString);
 
            SQL_Statement = "SELECT * FROM `news_table` LIMIT 0 , 30";
 
            cmd = new MySqlCommand(SQL_Statement, conn);
 
            conn.Open();
 
            dr = cmd.ExecuteReader();
 
            if(dr.HasRows)
            {
               while (dr.Read())
               {
                  this.dataGridView1.Rows.Add(dr.GetString(0), dr.GetString(1));
               }
            }
 
            dr.Close();
            conn.Close();
            conn.Dispose();
 
         }
      }
   }