Chidiebere Mgbemena

Chidiebere Mgbemena

  • NA
  • 179
  • 14.1k

The multi part identifer HeaderDataJobNo could not be found.

Jun 9 2020 4:52 PM
I got an error while trying to print bill with crystal report. The error is below
 
The multi part identifer HeaderDataJobNo could not be found.
 
Please help me find the solution to the error
 
thanks
 
my codes and sql below
  1. using System;  
  2. using System.Collections.Generic;  
  3. using System.ComponentModel;  
  4. using System.Data;  
  5. using System.Drawing;  
  6. using System.Linq;  
  7. using System.Text;  
  8. using System.Threading.Tasks;  
  9. using System.Windows.Forms;  
  10. using System.Data.SqlClient;  
  11. using CrystalDecisions.CrystalReports.Engine;  
  12. namespace NSPM_Sales_Invoice  
  13. {  
  14. public partial class PrintBills : Form  
  15. {  
  16. SqlConnection con = new SqlConnection(Properties.Settings.Default.NSPM_Sales_InvoiceCon);  
  17. ReportDocument Cryrpt = new ReportDocument();  
  18. SqlDataAdapter dr;  
  19. public PrintBills()  
  20. {  
  21. InitializeComponent();  
  22. }  
  23. private void PrintBills_Load(object sender, EventArgs e)  
  24. {  
  25. txtJobNo.Text = Class1.strinv;  
  26. try  
  27. {  
  28. con.Open();  
  29. SqlDataAdapter da = new SqlDataAdapter("select Tbl_HeaderData.JobNo,Tbl_HeaderData.Date,Tbl_HeaderData.GoodValue,Tbl_HeaderData.Vat,Tbl_HeaderData.StampDuty,Tbl_HeaderData.DeliveryCharges,Tbl_HeaderData.OtherCharges,Tbl_HeaderData.Total,Tbl_RowData.SINo,Tbl_RowData.Customer, Tbl_RowData.Description,Tbl_RowData.Price,Tbl_Rowdata.Quantity,Tbl_RowData.Value,Tbl_RowData.JobNo from Tbl_HeaderData Inner Join Tbl_RowData on Tbl_HeaderData.JobNo = Tbl_RowData.JobNo Where HeaderData.JobNo = '" + txtJobNo.Text + "'", con);  
  30. DataSet dst = new DataSet();  
  31. da.Fill(dst, "Tbl_HeaderData");  
  32. Cryrpt.Load("PrintBill.rpt");  
  33. Cryrpt.SetDataSource(dst);  
  34. crystalReportViewer1.ReportSource = Cryrpt;  
  35. con.Close();  
  36. }  
  37. catch (Exception ex)  
  38. {  
  39. MessageBox.Show(ex.Message);  
  40. }  
  41. }  
  42. }  

 

Answers (2)