C# (CSharp) TMS db.updatequery Examples

Example #1

        public void update(string searchkey)
        {
            log = new TMS.db();
            log.open();
            int       key;
            DataTable read;


            string query = "select id from partysearch where name = '" + searchkey + "'";

            read = log.searchquery(query);

            key   = Convert.ToInt32(read.Rows[0][0].ToString());
            query = "update party set pname='" + pname + "',address='" + paddress + "',city='" + pcity + "',contact='" + pcontact + "',balance=" + pbalance + " where id = " + key + "";
            log.updatequery(query);
            log.close();
        }