尝试将数据插入sqlite3时出错-绑定参数0时出错-可能是不支持的类型

我试图将Kivy的textinput字段中的数据插入sqlite3数据库,但出现了以下问题。代码段

def save(self):

    conn = Database.db_connect()
    cursor = conn.cursor()

    # kivy textinput widgets are assigned variable no, name
    no = self.empid_text_input
    name = self.empname_text_input.text

    try:
        save_index_sql="INSERT INTO EmpInfo (EmpID , EmpName) VALUES (?,?)"
        conn.execute(save_index_sql, (no, name)) # Causes Error
        conn.commit()
        conn.close()
    except sqlite3.IntegrityError as e:
        print("Error: ",e)

#抛出错误----->sqlite3.InterfaceError:绑定参数0时出错-可能是不支持的类型。

1. 创建表EmpInfo(EmpID integer主键,EmpName text NOT NULL)

2. EmpImage公司 创建表EmpImage(EmpID integer主键,EmpPhoto BLOB NOT NULL)

        # conn.execute(save_index_sql,(int(no), str(name))) # RETURNS----> TypeError: int() argument must be a string, a bytes-like object or a number, not 'TextInput'
        # conn.execute(save_index_sql, (str(no), str(name))) # RETURNS----> Error:  datatype mismatch