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
Post a Comment