i have created a table as a cityMaster.i have column Id,city and state.
but i am confused ,
In a webform i have a textboxes like city and state.
if i select any cityname ,on basis of cityName i want the state.i wrote only select query
select * from citymaster with (nolock).
for this ,what will be the stored PRocedure.
how should i get it ??
kindly give me Idea..