mysql·½ÃæûʲôÎÊÌ⣬ĬÈϱàÂëÊÇ gb2312
c# ´°ÌåÀïÃæÌí¼Ó¸öDataGridView¿Ø¼þ£¬´°Ìåloadʱ£¬Ö´ÐÐÒÔÏ´úÂ룺
C# code:
server = "localhost";
database = "csharp";
name = "root";
password = "root";
string connectionString = "SERVER=" + server + ";" + "DATABASE=" + database + ";" + "UID=" + name + ";" + "PASSWORD=" + password + ";";
connection = new MySqlConnection(connectionString);
string mysql = "select * from books";
MySqlDataAdapter mysqlAdapter = new MySqlDataAdapter(mysql, connection);
DataSet ds = new DataSet();
mysqlAdapter.Fill(ds);
dataGridView1.DataSource = ds.Tables[0].DefaultView;
connection.Close();
connection.Dispose();
´ó¼ÒÓ¦¸Ã¿´µÃ¶®°É£¬
½á¹ûÊÇ£º
DataGridViewµÄÁÐÃû ÂÒÂ룬Õý³£ÏÔʾӦ¸ÃÊÇÖÐÎĵģ¬ÆäËûÇé¿öÕý³£
Çë´ó¼Ò°ïÎÒ·ÖÎöÏÂÄÄÀï³öÁËÎÊÌ⣿
SQL code:
select * from books
--°Ñ*ºÅд³É×Ö¶ÎÃûÊÔÒ»ÊÔ
Ó¦¸Ã²»ÊÇGridviewµÄÎÊÌâ
ÊÔ¹ýÁË
Êý¾Ý¿â±íÓÐÈçÏÂ×ֶΣº
ID, ÊéÃû, ¶¨¼Û, Ïú´Î, ÏúÁ¿, ³ö°æÉç