1、请设计一个项目连接到自己的MySQL数据库,数据库包含至少三张表;
2、使用dataGridView控件显示表中的数据;
3、实现基本crud操作;
先制作出winform,然后连接数据库
然后输入数据
CREATE TABLE Student(
studentid VARCHAR(10),
studentname VARCHAR(10) NOT NULL DEFAULT '',
studentbirth VARCHAR(10) NOT NULL DEFAULT '',
studentscore VARCHAR(10) NOT NULL DEFAULT '',
PRIMARY KEY(student)
);
insert into Student values('1' , 'QQ' , '10.30' , '89');
insert into Student values('2' , 'WW' , '9.15' , '90');
insert into Student values('3' , 'SS' , '3.21' , '65');
DataGridView
private void print_in_dataGridView()
{
MySqlCommand mycom = conn.CreateCommand();
mycom.CommandText = "SELECT * FROM student ; ";
MySqlDataAdapter adap = new MySqlDataAdapter(mycom);
DataSet ds = new DataSet();
adap.Fill(ds);
dataGridView1.DataSource = ds.Tables[0].DefaultView;
}
数据库连接
MySqlConnection conn = new MySqlConnection("Server=localhost;Database=test_database;uid=root;pwd=666");
private void button1_Click(object sender, EventArgs e)
{
conn.Open();
if (conn.State == ConnectionState.Open)
{
MessageBox.Show("成功连接");
print_in_dataGridView();
}
}
//插入
private void button_insert_Click(object sender, EventArgs e)
{
String StuID = textBox_sid.Text;
String StuName = textBox_sname.Text;
String StuBirth = textBox_sbirth.Text;
String StuS