SqLite save to DataBase

Booney 166

I am trying to save 5 textboxs 1 combo and datetimepicker to a database but the only thing saved is the datetimepicker. I am very confused with this and dont see why this code isn't working any suggestions much appreciated.

private void btn_Save_Click(object sender, EventArgs e)
        {     

                if (lbl_LibId.Text == "*")
            {
                string sql = "insert into Request (Date, Part_Number, Request_By, Assigned_CC, IC_Analyst, Priority, Comments)" +

                             " values(@Date, @Part_Number, @Request_By, @Assigned_CC, @IC_Analyst, @Priority, @Comments)";

                Request.ExecuteSQL(sql, new[] {

                        new SQLiteParameter("@Date", dateTimePicker1.Text),
                        new SQLiteParameter("@Part_Number", txt_Part_Number.Text),
                        new SQLiteParameter("@Request_By", txt_Count_Request_By.Text),
                        new SQLiteParameter("@Assigned_CC", txt_Assigned_Code.Text),
                        new SQLiteParameter("@IC_Analyst", txt_Analyst.Text),
                        new SQLiteParameter("@Priority", cb_Priority.Text),                       
                        new SQLiteParameter("@Comments", txt_Comments.Text),                         

                    });


                DataBind();

            }
        }

P a u l 10,751 Reputation points

2021-10-08T15:08:36.847+00:00

Are all columns in your Request table string-based?
Booney 166 Reputation points

2021-10-08T16:11:45.027+00:00

They are all Text.
P a u l 10,751 Reputation points

2021-10-08T17:07:44.64+00:00

Do the other columns end up as NULL in the DB, or an empty string? Have you debugged that call to make sure the .Text properties are populated with what you expect?
Booney 166 Reputation points

2021-10-08T17:52:53.863+00:00

the text is blank.
Booney 166 Reputation points

2021-10-08T17:53:41.357+00:00

this same code works in other parts of the app, not sure why on this
Karen Payne MVP 35,466 Reputation points

2021-10-08T19:58:30.157+00:00

What value is being returned from ExecuteNonQuery ?
Booney 166 Reputation points

2021-10-08T22:47:10.817+00:00

this is whats is returned
Karen Payne MVP 35,466 Reputation points

2021-10-09T09:07:43.153+00:00

In the screenshot, which is the ExecuteNonQuery?

Booney 166

I have it in a Class just to test I removed the ,Text (Part_Number System.Windows.Forms.TextBox, Text: ) returned.

  public static int ExecuteSQL(string sql, IEnumerable<SQLiteParameter> parameters)
        {
            SQLiteCommand cmd = new SQLiteCommand(sql, Connection);
            cmd.Parameters.AddRange(parameters.ToArray());
            return cmd.ExecuteNonQuery();
        }

Jack J Jun 24,626 Reputation points Microsoft Vendor

2021-10-11T03:05:28.283+00:00

@Booney , based on my test, I could not reproduce your problem. The code works for me as well. Please check if you input the value in the textboxes and comboxes control or not. If you don't mind, you could upload your project to OneDrive or GitHub then share the link here. It will be better for me to analyze the problem.
Karen Payne MVP 35,466 Reputation points

2021-10-11T13:57:02.817+00:00
You could using my NuGet package DataProviderCommandHelpers which will reveal your command with it's parameters revealed to see if the query is as expected.

Example which is called prior to ExecuteNonQuery.

Console.WriteLine(cmd.RevealCommandQuery(CommandProvider.SqlServer,"$"));

Note that the second parameter should work with SqlLite (have not tried this with SqlLite) and the last parameter is the prefix for a parameter.

If this doesn't work then simply uninstall the package. If it works then I will add CommandProvider.Sqlite for future used.

At this time I've only tested with Oracle, Access and SQL-Server.

Share via

SqLite save to DataBase

Your answer