.NET (Core and Framework)

SELECT fieldList, ... FROM customer WHERE lastname=@setName";

using (SQLiteCommand cmd = conn.CreateCommand())
{
    try
    {
        cmd.CommandText = @"SELECT * FROM customer WHERE lastname = @setName";

        cmd.Parameters.AddWithValue("@setName", txt_name.Text);
    
        da_Customer = new SQLiteDataAdapter(cmd);
        dt_Customer = new DataTable();
        da_Customer.Fill(dt_Customer);
        dgv_customer.DataSource = dt_Customer;
    }
    catch (Exception ex)
    {
        MessageBox.Show(ex.Message);
    }
}

public DataTable GetCustomerTableFromLastName(string lastName)
{
    using (SQLiteConnection conn = new SQLiteConnection(CONNECTIONSTRING))
    {
        SQLiteCommand comm = conn.CreateCommand();

        cmd.CommandText = @"SELECT firstname, lastname, something, somethingElse FROM customer WHERE lastname = @setName";

        cmd.Parameters.AddWithValue("@setName", txt_name.Text);
    
        SQLiteDataAdapter adpat = new SQLiteDataAdapter(cmd);
        DataTable tableResult = new DataTable();
        adapt.Fill(tableResult);

        return tableResult;
    }
}

Adrian Rowlands wrote:

C#

da_Customer = new SQLiteDataAdapter(cmd.CommandText, conn);

da_Customer = new SQLiteDataAdapter(cmd);

In my opinion, this could probably have a lot to do with the software you are currently using.

Member 14566520 wrote:

I Would like to create a Bill and then add some rows to it.

Bastard Programmer from Hell
"If you just follow the bacon Eddy, wherever it leads you, then you won't have to think about politics." -- Some Bell.

Will users need to install anything locally?