error in bill view/Print summary

Chidiebere Mgbemena

Thanx for all the help guyz i appreciate, as i said earlier i am new to c# that is why i need your help with this project am working on.

I am trying to view bills and print summary but am getting this error, please help detect the problem.

Thanks

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;
using System.Data.SqlClient;
namespace NSPM_Sales_Invoice
{
public partial class ViewBills : Form
{
SqlConnection con = new SqlConnection(Properties.Settings.Default.NSPM_Sales_InvoiceCon);
SqlCommand cmd;
SqlDataAdapter da;
DataTable dt;
public ViewBills()
{
InitializeComponent();
}
private void ViewBills_Load(object sender, EventArgs e)
{
con.Open();
da = new SqlDataAdapter("Select * from Tbl_HeaderData order by JobNo asc", con);
con.Close();
SqlCommandBuilder cb = new SqlCommandBuilder(da);
dt = new DataTable();
da.Fill(dt);
dataGridView1.DataSource = dt;
}
private void btnViewBills_Click(object sender, EventArgs e)
{
con.Open();
da = new SqlDataAdapter("Select * from Tbl_HeaderData where JobNo between '" + dateTimePicker1.Value.ToString("yyyy-MM-dd") + "'and'" + dateTimePicker2.Value.ToString("yyyy-MM-dd") + "'order by JobNo asc ", con);
DataSet ds = new DataSet();
da.Fill(ds, "Tbl_HeaderData");
dataGridView1.DataSource = ds.Tables["Tbl_HeaderData"];
con.Close();
}
}
}

5 Replies

Know the answer? Post it — somebody with the same question will find it here.

Laxmidhar Sahoo6y ago
Accepted answer
hi
I think Jobtype is your integer data type in sql server , But you pass the DateTime value .

pass the integer value without single code
+1
Chidiebere Mgbemena6y ago
Many thanks guys, i replaced Date with JobNo and it worked.

@Jignesh Kumar I appreciate your help and everyon that commented thank you.
0
Salman Beg6y ago
Hey you are not passing the proper column name, please do check and pass properly. Thanks
0
Jignesh Kumar6y ago
Hi,

you need to check here in below line, You are checking date field with jobNo field which is varchar. Please change jobno with date field which you want to filter your records in between date,
Select * from Tbl_HeaderData where YourDatefield between '" + dateTimePicker1.Value.ToString("yyyy-MM-dd") + "'and'" + dateTimePicker2.Value.ToString("yyyy-MM-dd") + "'order by JobNo asc ", con)
0
Chidiebere Mgbemena6y ago
This is the error message:

"conversion failed when converting the varchar value 2020-5-22 to data type int"
0