mysql - Search in SQL Database (C# UWP) -


i'm new in developing windows 10. have database customers.

i make connecting this

using (mysqlconnection connection = new mysqlconnection("database= milanoold_db;data source=144.76.133.122;user id=milanoold_u;password=sk5pvcdp; sslmode=none; charset=utf8")) 

i want make search of customer via telephone if found him, need write info client console.

table has fields - id,name, mob, adress, birthday, email.

i need make search mob.i try use query

 searchbutton1.click += delegate  {       connection.open();       mysqlcommand createcommand = new mysqlcommand("select * reg_user mob '%+380675090373%'", connection);       createcommand.executenonquery();  }; 

how can display fields of customer console?

thank's help.

updated

also have error when tap on search button

system.argumentexception unhandled user code   hresult=-2147024809   message='windows-1252' not supported encoding name. information on defining custom encoding, see documentation encoding.registerprovider method. parameter name: name   paramname=name   source=mscorlib   stacktrace:        @ system.globalization.encodingtable.internalgetcodepagefromname(string name)        @ system.globalization.encodingtable.getcodepagefromname(string name)        @ system.text.encoding.getencoding(string name)        @ mysql.data.mysqlclient.charsetmap.getencoding(dbversion version, string charsetname)        @ mysql.data.mysqlclient.mysqlfield.setfieldencoding()        @ mysql.data.mysqlclient.mysqlfield.settypeandflags(mysqldbtype type, columnflags flags)        @ mysql.data.mysqlclient.nativedriver.getcolumndata(mysqlfield field)        @ mysql.data.mysqlclient.nativedriver.getcolumnsdata(mysqlfield[] columns)        @ mysql.data.mysqlclient.driver.getcolumns(int32 count)        @ mysql.data.mysqlclient.resultset.loadcolumns(int32 numcols)        @ mysql.data.mysqlclient.resultset..ctor(driver d, int32 statementid, int32 numcols)        @ mysql.data.mysqlclient.driver.nextresult(int32 statementid, boolean force)        @ mysql.data.mysqlclient.mysqldatareader.nextresult()        @ mysql.data.mysqlclient.mysqlcommand.executereader(commandbehavior behavior)        @ mysql.data.mysqlclient.mysqlcommand.executereader()        @ milano.neworder.<>c__displayclass0_0.<.ctor>b__0(object <sender>, routedeventargs <e>)   innerexception:  

you don't want use executenonquery select, want use datareader. see below instructions:
https://msdn.microsoft.com/en-us/library/haa3afyz(v=vs.110).aspx

executenonquery return number of rows impacted command. it's intended sql commands not return values (such insert, update, , delete).


Comments