visual studio - query does work on access but not in vb.net no error but executenoquery is 0 -
visual studio - query does work on access but not in vb.net no error but executenoquery is 0 -
i having problem simple query select * customers [recieptnum] = '" & & "'
there no error not showing record, i' ve checked every thing connection string running query in access straight after copied commandtext vs. help appreciated code
dim string = textbox1.text
dim commstring string = "select * customers [recieptnum] = '" & & "' " sqlquary.commandtext = commstring 'sqlquary.parameters.addwithvalue("@some", textbox1.text) dim b integer = sqlquary.executenonquery()
thanks lennart did way sqlquary.executereader.fieldcount() homecoming coloms numbers in case not matter long there hit. cheers
visual-studio
Comments
Post a Comment