vb.net - Add Global Shortcut from DB -
i trying create global hotkeys application have done have gotten stuck when assinging char keys method database. code below
dim id integer dim link_id keys dim cs string = "server=" & server & "; user id=" & username & "; password= " & password & "; database=" & databasename & ";" dim conn new mysqlconnection(cs) try conn.open() dim stm string = "select * quick_link shortcut <> '' order link_id asc" dim cmd mysqlcommand = new mysqlcommand(stm, conn) dim reader mysqldatareader = cmd.executereader() while reader.read() console.writeline(reader.getstring("link_name") & " - link = " & reader.getstring("link_address") & " - shortcut = " & reader.getstring("shortcut")) id = reader.getstring("link_id") link_id = reader.getstring("shortcut") registerhotkey(me.handle, id, mod_alt, link_id) ** trouble here end while reader.close() catch ex mysqlexception console.writeline("error: " & ex.tostring()) conn.close() end try
i having trouble when comes putting in letter db keys method link_id gives error of cannot have string in integer, or when put letter after keys.link_id, says not member of keys.
any ideas ???
Comments
Post a Comment