Error iNVALID COLUMN NAME DATE
public PrintBillsAll()
{
InitializeComponent();
}
private void btnLoad_Click(object sender, EventArgs e)
{
using (IDbConnection db = new SqlConnection(ConfigurationManager.ConnectionStrings["cn"].ConnectionString))
{
if (db.State == ConnectionState.Closed)
db.Open();
string query = " Select Bill_No , Name, Address, MobileNo,Sl_No,ItemName,Size,Quantity,Rate,Amount,Total_Amount,Payment,Balance,Date" +
"from SALES" + $" where Date between '{dtFromDate.Value}' and '{ dtToDate.Value}'";
billinginfoBindingSource.DataSource = db.Query<Billinginfo>(query, commandType: CommandType.Text);
}
}