if same city name are there then it can'n repeat?

Dhimesh Parmar

8y796.NET

i need help to dislpy unic city name if city name are same then city data is disply but city name is not display?

my code like this:

string tmp = "";

tmp=Convert.ToString(dstTourData1.Rows[i]["CityName"]);

if (tmp !=Convert.ToString(dstTourData1.Rows[i]["CityName"]))

{

for (int j = 0; j

{

<%=dstTourData1.Rows[i]["detail"] %>

Address : <%=dstTourData1.Rows[i]["address"] %>

" height="60" width="60" style="margin-right:25px" />

}

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Nitin Sontakke8y ago
Query is correct. But you have not disclosed entire code. The outer bigger for loop is missing. You can exclude most of the mark-up code and just post the loops. I think you are initializing tmp variable everytime and also not storing the previous value which you should.
Dhimesh Parmar8y ago
SqlDataAdapter sqlData = new SqlDataAdapter("select tl.*,s.stateId,s.stateName, c.cityId,c.CityName,cn.countryId,cn.CountryName,l.locationId,l.name as lname,l.detail,l.address,l.image1,l.image2,l.image3,l.image4,l.image5,t.tourId from tourLocation tl LEFT JOIN country cn on cn.countryId = tl.countryId and cn.status <> 2 LEFT JOIN state s on s.stateId = tl.stateId and s.status <> 2 LEFT JOIN city c on c.cityId = tl.cityId and c.status <> 2 LEFT JOIN LOCATION l on l.locationId = tl.locationId and l.status <> 2 LEFT JOIN tour t on t.tourId = tl.tourId and t.status <> 2 where tl.tourId = "+TOURID+ " order by tl.cityId", connection);
Nitin Sontakke8y ago
where is the data coming from? SQL Server? Share the query. Did you apply the order by clause there?