1 String sqlConnstring = "Data Source=5G1M5IXWTWFB1WV\\SQLEXPRESS;Database=student;Uid=sa;Pwd=12345678"; //连接字符串 2 SqlConnection Conn = new SqlConnection(sqlConnstring); 3 Conn .Open (); 4 String userstring = "Select * from mark where name1='" + textBox1.Text + "'" ; 5 SqlDataAdapter da = new SqlDataAdapter(userstring, Conn);//数据适配器对象,可把数据源的数据读到内存表里,或把内存的数据写回去。 6 DataTable dt = new DataTable(); //datatable对象,用来填充查询到的数据 7 da.Fill(dt); //把查询到的数据da填充给dt 8 9 dataGridView1.DataSource = dt; //将dt对象作为dataview1的数据源10 this.Column1.DataPropertyName="name1"; //column1列对应的是数据库的name1 。。后面同理11 this.Column2.DataPropertyName="SQL数据库"; 12 this.Column3.DataPropertyName="微机原理";13 this.Column4.DataPropertyName="C#程序设计";14 this.Column5.DataPropertyName="网页设计"; 15 this.Column6.DataPropertyName="体育"; 16 this.Column7.DataPropertyName="总分";17 18 19 Conn.Close();