Database

String sQuery1 = "SELECT * FROM service_schedules WHERE (vehicle_id,service_id) IN (SELECT DISTINCT vehicle_id,service_id FROM services_performed) AND vehicle_id=?";
Cursor cursor1 = db.rawQuery(sQuery1, new String[]{ String.valueOf(id) });

String sQuery2 = "SELECT * FROM service_schedules WHERE (vehicle_id,service_id) IN (SELECT DISTINCT vehicle_id,service_id FROM services_performed) AND vehicle_id="+id;
Cursor cursor2 = db.rawQuery(sQuery2, null);

String sQuery3 = "SELECT * FROM service_schedules WHERE (vehicle_id,service_id) IN (SELECT DISTINCT vehicle_id,service_id FROM services_performed)";
Cursor cursor3 = db.rawQuery(sQuery3, null);

Error Message:
Array ( [0] => Array ( [0] => 42000 [SQLSTATE] => 42000 [1] => 260 [code] => 260 [2] => [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Disallowed implicit conversion from data type smalldatetime to data type float, table 'commission_summary', column 'startup_check_date'. Use the CONVERT function to run this query. [message] => [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Disallowed implicit conversion from data type smalldatetime to data type float, table 'commission_summary', column 'startup_check_date'. Use the CONVERT function to run this query. ) ) 

getSalesBonusByDate 362: SELECT count (a.project_no) FROM project as a, commission_summary as b WHERE a.project_no = b.project_no AND (a.sold_date <= 3-1-2021) AND (a.status = 'construction' or a.status = 'finished') AND ((CAST(FLOOR(b.startup_check_date)AS DATETIME) BETWEEN 1-1-2021 AND 3-1-2021)) AND a.sales_no = '79' 1

SELECT count (a.project_no) FROM project as a, commission_summary as b WHERE a.project_no = b.project_no AND (a.sold_date <= 3-1-2021) AND (a.status = 'construction' or a.status = 'finished') AND ((CAST(FLOOR(b.startup_check_date)AS DATETIME) BETWEEN 1-1-2021 AND 3-1-2021)) AND a.sales_no = '79' 

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.IO;

namespace Stepping
{
    public partial class Form1 : Form
    {
        public Form1()
        {
            InitializeComponent();
        }

        private void dataGridView1_CellContentClick(object sender, DataGridViewCellEventArgs e)
        {

        }

        private void btnSave01_MouseClick(object sender, MouseEventArgs e)
        {
            TextWriter writer = new StreamWriter(@"H:\proj\_Programacao\_Arduino\ArduinoHM\Stepper_Polling_us\WinApp\M01.txt");
            
            for (int i = 0; 1 < dataGridViewMotor1.Rows.Count - 1; i++)
            {
                for (int j = 0; j < dataGridViewMotor1.Columns.Count; j++)
                {
                    if (j == 0)
                    {
                        writer.Write(dataGridViewMotor1.Rows[i].Cells[j].Value.ToString());  
                    }
                    else
                    {
                        writer.Write("," + dataGridViewMotor1.Rows[i].Cells[j].Value.ToString());
                    }
                }
            }
            writer.Close();
            MessageBox.Show("Data Exported");
        }

        private void btnFillTestData_MouseClick(object sender, MouseEventArgs e)
        {
            // Line, Abs, Rel, X, C_t, C_i, C_n, MinSpeed, MaxSpeed, Accel, Decel
            dataGridViewMotor1.Rows.Add(1,0, 120,0,0,0,0, 10, 100, 0.9, 0.9 );
            dataGridViewMotor1.Rows.Add(2,0,120, 0, 0, 0, 0, 10, 100, 0.9, 0.9);
            dataGridViewMotor1.Rows.Add(3,0, 80, 0, 0, 0, 0, 10, 100, 0.9, 0.9);
        }
    }
}