报表

 private void Form1_Load(object sender, EventArgs e)
        {
            // TODO: 这行代码将数据加载到表“lianxiSQLDataSet.student”中。您可以根据需要移动或删除它。
            //this.studentTableAdapter.Fill(this.lianxiSQLDataSet.student);
            SqlConnection conn = new SqlConnection("server=.;database=lianxiSQL;uid=sa;pwd=123");
            SqlCommand cmd = conn.CreateCommand();
            cmd.CommandText = "select * from student,score where student.Sno=score.Sno";
            conn.Open();
            SqlDataReader dr = cmd.ExecuteReader();
            while (dr.Read())
            {
                DataRow row = DataSet1.stu.NewRow();
                row["sno"]=dr["sno"];
                row["sname"] = dr["sname"];
                row["ssex"] = dr["ssex"];
                row["cno"] = dr["cno"];
                row["degree"] = dr["degree"];
                DataSet1.stu.Rows.Add(row);
            }
            this.reportViewer1.RefreshReport();
        }