SqLite save to DataBase

Booney 166 Reputation points
2021-10-08T14:53:48.98+00:00

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();

            }
        }
Windows Forms
Windows Forms
A set of .NET Framework managed libraries for developing graphical user interfaces.
1,870 questions
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,268 questions
C#
C#
An object-oriented and type-safe programming language that has its roots in the C family of languages and includes support for component-oriented programming.
10,603 questions
{count} votes