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

Popular posts from this blog

assembly - What is the addressing mode for ld, add, and rjmp instructions? -

vowpalwabbit - Interpreting Vowpal Wabbit results: Why are some lines appended by "h"? -

Is there a way to convert an HTML page styled with Bootstrap CSS into email-compatible html? -