mysql - Searching a database for a string and taking relevant information VB -

-

i want able search database product name or product id number , load relevant information regarding product text boxes.

my current code has no build errors doesn't seem return information. small , i'm being idiot cant fathom problem. 

 private sub btnsearchproducts_click(byval sender system.object, byval e system.eventargs) handles btnsearchproducts.click     ds.clear()      if txtproductname.text = "" , txtproductid.text = ""         messagebox.show("please enter either product id or product name..", "authentication error", messageboxbuttons.ok, messageboxicon.error)      else         if txtproductid.text <> ""             each ch char in txtproductid.text                 if not char.isdigit(ch)                     txtproductid.clear()                     msgbox("please enter valid product id. integers valid input", messageboxbuttons.ok, messageboxicon.error)                     exit sub                 end if             next         end if          ' connect db          dim conn new system.data.oledb.oledbconnection()         conn.connectionstring = "provider=microsoft.ace.oledb.12.0;data source=d:\computing project\database1.accdb"         dim command new oledb.oledbcommand          try              dim sql string = "select * tbl_stock s_id = '" & txtproductid.text & "'or s_productname = '" & txtproductname.text & "'"             dim sqlcom new system.data.oledb.oledbcommand(sql)              'open database connection             sqlcom.connection = conn             conn.open()              da = new oledb.oledbdataadapter(sql, conn)             da.fill(ds, "stock")              dim sqlread system.data.oledb.oledbdatareader = sqlcom.executereader()              if sqlread.read()                 txtproductid.text = cint(ds.tables("stock").rows(0).item(0))                 txtproductname.text = ds.tables("stock").rows(0).item(3)                 txtproductprice.text = "£" & cdec(ds.tables("stock").rows(0).item(2))             else                 if txtproductid.text <> ""                     msgbox("sorry, " & txtproductid.text & " not valid product id", messageboxbuttons.ok, messageboxicon.error)                     txtproductid.text = ""                 end if                 if txtproductname.text <> ""                     msgbox("sorry, " & txtproductname.text & " not valid product name", messageboxbuttons.ok, messageboxicon.error)                     txtproductname.text = ""                 end if             end if         catch ex exception         end try     end if end sub

any appreciated

a few thoughts this, might point right direction.

  1. it looks combining 2 different logical processes. filling dataset, trying read same query again. rather calling out "read" if statement. count of rows on ds.tables[0] might resolve immediate issue.
  2. please have @ parameterized sql queries, building raw user entry allows malicious actions , efforts should taken avoid if can.
  3. looking @ query, looking exact match on id, or name. might switch operation on name rather exact match.

Comments

Post a Comment

Popular posts from this blog

google chrome - Developer tools - How to inspect the elements which are added momentarily (by JQuery)? -

-
i looking @ how website designed using inspector in chrome. can use firefox developer tools or firefox web developer add-on or chrome web developer extension. so website has slide-show , using jquery it. looking @ markup , css in inspector, i see 2 things constantly changing slides change: one opacity css property understandable, i'd see changing values, changes fast see read anything. second- a div added in div slides change momentarily , moment when appears short notice except div . so question is there way stop slideshow can temporarily rid of blinking sort of effect (by speedy adding , removal , changing of elements , values)? where can inspect div element gets added such short moment , , gets removed? , can see changes in value of opacity takes place? is there way stop slideshow can temporarily rid of blinking sort of effect (by speedy adding , removal , changing of elements , values)? if opacity animated css transition or animation,
Read more

angularjs - Showing an empty as first option in select tag -

-
my app showing empty select field first entry. have read other solution given , tried still not working. my controller code is: .controller('usercreatecontroller', function(user,profile,auth) { alert("hello"); var vm = this; vm.type = 'create'; profile.all() //this service fetch profiles shown in select field .success(function(data){ vm.profile = data; }); vm.userdata.profile = vm.profile[0]; //here have set default value select field and html page is: <label class="col-sm-2 control-label">profile</label> <div class="col-sm-8"> <select ng-model="user.userdata.profile" ng-options="person._id person.profilename person in user.profile"> </select> </div> hierarchy of vm.profile { "_id": 46, "profile": objectid("5516498e95b84548156db754"), "isactive": true, "password": "$2
Read more

php - Cloud9 cloud IDE and CakePHP -

-
i attempting cakephp running on cloud9, cloud based ide. unaware, cloud collaboration ide intermixes services such bitbucket. site gives sudo rights, , installed cakephp using these instructions: https://www.digitalocean.com/community/tutorials/how-to-install-cakephp-on-an-ubuntu-12-04-vps when attempt run database exported machine cakephp installed, error message "url rewriting not configured on server." attempted solve issue using official guide cakephp: http://book.cakephp.org/2.0/en/installation/url-rewriting.html but no cigar, same error message. has gotten cakephp working, or aware of cloud ide free/low cost cloud9 support cakephp? here's how got working now: sudo apt-get update sudo apt-get install php5-intl curl -ss https://getcomposer.org/installer | php -- --filename=composer ./composer create-project --prefer-dist cakephp/app this creates project in /app default. move workspace docroot: mv app/* ./ mv app/.* ./ rm -rf app then de
Read more