vb.net access query for updating

is d query rite ? q = "update FIRSTBBA 开发者_C百科WHERE FBBANAME<>"" ORDER BY FBBANAME" Need to update a table in ascending order

This query is not complete. You can use inner SQL statement based on your requirement and update the table based on that.

You're not assigning a value to FIRSTBBA. Also, not sure what database you're using but I don't think SQL server allows an order by clause in an update statement. you would have to refer to a post like this one: How to update and order by using ms-sql