U++ framework
Do not panic. Ask here before giving up.

Home » Community » Newbie corner » sqlarray and sqlite (Trying to use sqlite example but...)
Re: sqlarray and sqlite [message #54855 is a reply to message #54854] Tue, 22 September 2020 17:54 Go to previous messageGo to previous message
mirek is currently offline  mirek
Messages: 14291
Registered: November 2005
Ultimate Member
        public bool Delete(customersTable dc)
        { ...
                //SQL Query to Delete Data from database
                string sql = "DELETE FROM CUSTOMERS WHERE CUST_ID=@id";

                //SQL command to pass the value
                SQLiteCommand cmd = new SQLiteCommand(sql, conn);
                //Passing the value
                cmd.Parameters.AddWithValue("@id", dc.CUST_ID);
                //Open DB Connection
                conn.Open();
                //integer variable
                int rows = cmd.ExecuteNonQuery();
                if(rows>0) //Success
                {


Yeah, thats crazy, compared to

SQL * Delete(CUSTOMERS).Where(CUST_ID == id);


Mirek
 
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Previous Topic: Friends? Cousins? Half-siblings?
Next Topic: how to make an editfield accept only number or date? have any examples in the documentation?
Goto Forum:
  


Current Time: Sun Sep 13 07:51:29 GMT+2 2026

Total time taken to generate the page: 0.01781 seconds