Tạo Report bằng ReportViewer trong C# Winforms

CREATE DATABASE StudentDB
GO
USE [StudentDB]
GO
/****** Object:  Table [dbo].[Diem]    Script Date: 8/25/2021 1:32:20 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Diem](
	[MaHS] [int] NOT NULL,
	[MaMH] [int] NOT NULL,
	[Diem] [float] NULL,
 CONSTRAINT [PK_Diem] PRIMARY KEY CLUSTERED 
(
	[MaHS] ASC,
	[MaMH] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO

ALTER proc [dbo].[SP_LayDiem]
as
begin
	select ROW_NUMBER() OVER (ORDER BY MaHS) AS STT, MaHS,Name,TenMH,Diem 
	from Student, Diem, MonHoc 
	where Student.Id = Diem.MaHS and MonHoc.MaMH = Diem.MaMH
end

<add name="conStr" connectionString="server=DESKTOP-PQMLT59\VANQUYEN;database=StudentDB;integrated security=true" />

SqlConnection con = new SqlConnection();
SqlDataAdapter da = new SqlDataAdapter();
DataTable dt = new DataTable();
con.ConnectionString = ConfigurationManager.ConnectionStrings["conStr"].ConnectionString;

private void btnHienThi_Click(object sender, EventArgs e)
{
    SqlConnection con = new SqlConnection();
    SqlDataAdapter da = new SqlDataAdapter();
    DataTable dt = new DataTable();
    con.ConnectionString = ConfigurationManager.ConnectionStrings["conStr"].ConnectionString;

    try
    {
        con.Open();
        da.SelectCommand = new SqlCommand();
        da.SelectCommand.CommandText = "SP_LayDiem";
        da.SelectCommand.CommandType = CommandType.StoredProcedure;
        da.SelectCommand.Connection = con;
        da.Fill(dt);
        dtgDSDiem.DataSource = dt;
        con.Close();

        dtgDSDiem.Columns[0].Width = 60;
        dtgDSDiem.Columns[0].HeaderText = "STT";
        dtgDSDiem.Columns[1].Width = 80;
        dtgDSDiem.Columns[1].HeaderText = "Mã HS";
        dtgDSDiem.Columns[2].Width = 150;
        dtgDSDiem.Columns[2].HeaderText = "Họ Tên";
        dtgDSDiem.Columns[3].Width = 100;
        dtgDSDiem.Columns[3].HeaderText = "Môn học";
        dtgDSDiem.Columns[4].Width = 100;
        dtgDSDiem.Columns[4].HeaderText = "Điểm";
    }
    catch (Exception ex)
    {
        MessageBox.Show(ex.Message);
    }
}

private void btnThoat_Click(object sender, EventArgs e)
{
    DialogResult dg = MessageBox.Show("Bạn có chắc muốn thoát?", "Thông báo", MessageBoxButtons.OKCancel, MessageBoxIcon.Question);
    if (dg == DialogResult.OK)
    {
        Application.Exit();
    }
}

private void btnReport_Click(object sender, EventArgs e)
{
    this.SP_LayDiemTableAdapter.Fill(this.StudentDBDataSet.SP_LayDiem);
    this.reportViewer1.RefreshReport();
}

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Configuration;
using System.Data;
using System.Data.SqlClient;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;

namespace ReportStudent
{
    public partial class Form1 : Form
    {
        public Form1()
        {
            InitializeComponent();
        }
        private void Form1_Load(object sender, EventArgs e)
        {
        }
        private void btnThoat_Click(object sender, EventArgs e)
        {
            DialogResult dg = MessageBox.Show("Bạn có chắc muốn thoát?", "Thông báo", MessageBoxButtons.OKCancel, MessageBoxIcon.Question);
            if (dg == DialogResult.OK)
            {
                Application.Exit();
            }
        }
        private void btnHienThi_Click(object sender, EventArgs e)
        {
            SqlConnection con = new SqlConnection();
            SqlDataAdapter da = new SqlDataAdapter();
            DataTable dt = new DataTable();
            con.ConnectionString = ConfigurationManager.ConnectionStrings["conStr"].ConnectionString;
            try {
                con.Open();
                da.SelectCommand = new SqlCommand();
                da.SelectCommand.CommandText = "SP_LayDiem";
                da.SelectCommand.CommandType = CommandType.StoredProcedure;
                da.SelectCommand.Connection = con;
                da.Fill(dt);
                dtgDSDiem.DataSource = dt;
                con.Close();

                dtgDSDiem.Columns[0].Width = 60;
                dtgDSDiem.Columns[0].HeaderText = "STT";
                dtgDSDiem.Columns[1].Width = 80;
                dtgDSDiem.Columns[1].HeaderText = "Mã HS";
                dtgDSDiem.Columns[2].Width = 150;
                dtgDSDiem.Columns[2].HeaderText = "Họ Tên";
                dtgDSDiem.Columns[3].Width = 100;
                dtgDSDiem.Columns[3].HeaderText = "Môn học";
                dtgDSDiem.Columns[4].Width = 100;
                dtgDSDiem.Columns[4].HeaderText = "Điểm";            
            }
            catch(Exception ex) {
                MessageBox.Show(ex.Message);
            }
        }
        private void btnReport_Click(object sender, EventArgs e)
        {
            this.SP_LayDiemTableAdapter.Fill(this.StudentDBDataSet.SP_LayDiem);
            this.reportViewer1.RefreshReport();
        }
    }
}