private void AllSearch_Load(object sender, EventArgs e)
{
MySqlConnection conn;
string constr = "server=localhost;database=数据库名;uid=账号;pwd=密码;";
conn = new MySqlConnection(constr);
conn.Open();
MySqlCommand co = new MySqlCommand("select * from 表名;", conn);
MySqlDataAdapter adapt = new MySqlDataAdapter();
adapt.SelectCommand = co;
DataSet ds = new DataSet();
adapt.Fill(ds, "t"); //第二个参数:表名,随便取
dataGridView1.DataSource = ds.Tables["t"];
conn.Close();
}
C# 使用DataGridView控件显示数据库中的数据
最新推荐文章于 2023-03-19 18:48:50 发布