1、请设计一个项目连接到自己的MySQL数据库,数据库包含至少三张表;
2、使用dataGridView控件显示表中的数据;
3、实现基本crud操作;
public Form1()
{
InitializeComponent();
}
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, "a");
dataGridView1.DataSource = ds.Tables["a"];
conn.Close();
}
结果截图
仓库