this is my state table:
create table tbl_state(id bigint primary key identity,state nvarchar(max))
this is my city table:
create table tbl_city(id bigint primary key identity,state bigint,city nvarchar(max))
if i selected dropdownlist1 means it want to come that state here... but this my qry is displaying only id but i want to display city name how ?
adap = new SqlDataAdapter("select *from tbl_city where state='" + DropDownList1.SelectedItem.Value + "'", con);
this is my bindgrid qry:
adap = new SqlDataAdapter("select b.state,c.city,a.hotelname,a.hotelimage from tbl_hotel a,tbl_state b,tbl_city c where a.state=b.id and a.city=c.id", con);