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(); } } } |