how can i assign values that are not found in my table during select statement from table ?

Question

i am using vb.net and sql server 2000
create table mytable(country varchar(20),city varchar(20))
insert into mytable values('Ethiopia','Mekelle)
insert into mytable values(('USA','newyork')
insert into mytable values('England','Chelsea')
dim str as string
str=select * from mytable where country=' "&txtcountry.text&" '
then when I enter country name from the textbox
let me enter, Ethiopia, USA, England, it works fine becuase these values are available in my table but when i try to enter values that don't exists on my table, i want to transfer it to other textbox or to dispaly as error message,
let me try to enter, kenya,then since 'Kenya' is not my table ,i will expect error message so how can i do this?

Answer 1

Select with 'Kenya' will return an empty recordset. You should check whether returned recordset has both EOF and BOF properties set to true. If so, there is no match and you can put in the other text box whatever you want.

Answer 2

A dogs eating human nutrition is okay moderately as far as well-being is concered. As long its no longer something poisonous or wealthy to dogs of direction. in case you're making a selfmade dogs recipe, they decide you to apply human nutrition so this os no longer the undertaking. what's regarding is the region and way your dogs is fed. in case you're cooking interior the kitchen and you throw your dogs a scrap, do you think of they're going to depart? in the event that they do, that is purely a be counted of time to eat earlier the dogs is physically powerful lower back decrease than your feet. in case you dont supply your dogs anymore nutrition they're going to whine cry and plead for extra. This will become very unsightly in due time. The begging additionally visit pot whilst there is scraps available in diverse places and eventualities. case in point, in case you supply your dogs scraps everytime your eating at a table, or interior the refrigerator or possibly a sprint one throwing nutrition will then save your dogs coming lower back to whine and beg. This places them in rank with your loved ones which will reason behavioral subject and adverse manors. wish this helps you recognize. in spite of the undeniable fact that table scraps on my own are no longer terrible to your dogs. this is particularly wonderful, quite. you possibly HAD SET YOUR RULE of what's suitable and what isn't, OR YOUR dogs is purely THAT properly BEHAVED. IF it works to your loved ones AND THE dogs, IT seen NO subject. ;-) it is beneficial to evaluate some dogs handle recipes, they final long and are very healthful! this is how I save funds whilst preparation.