vetrivelandyou / stock Goto Github PK

Respected Sir, I had watched your video and it really helped and guided me, so i decided to make my college project basis on it, but that tutorial is half part so sir please I kindly request and want to know when will your remaining video part will be uploaded.

hello sir,
i wrote the code just you say in video i.e; crystal report creation

in productreport.cs file
using CrystalDecisions.CrystalReports.Engine; // add this line
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Data.SqlClient;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;
using System.Data.SqlClient;

namespace Stock_Management.ReportForm
{
public partial class ProductsReport : Form
{
ReportDocument cryrpt = new ReportDocument();
public ProductsReport()
{
InitializeComponent();
}

    private void ProductsReport_Load(object sender, EventArgs e)
    {
        cryrpt.Load(@"E:\venkat sai\Dot_Net\Csharp\Stock_Management\Stock_Management\Reports\Product.rpt");
        SqlConnection con = Connection.getConnection();
        con.Open();

        DataSet dst = new DataSet();
        SqlCommand cmd = new SqlCommand("select * from Products", con);
        cmd.ExecuteNonQuery();
        SqlDataAdapter sda = new SqlDataAdapter(cmd);
        DataTable dt = new DataTable();
        sda.Fill(dt);

        cryrpt.SetDataSource(dt)
        crystalReportViewer1.ReportSource = cryrpt;

        con.Close();
    }
}

}

the code doesn't show any errors but while running the application it is throwing an pop up that is

the report has no tables

please help me to solve this error in application sir

The Youtube Video is : https://youtu.be/ESrLYkktj5U