if city name is same then it print only one time?

C# Corner

Dhimesh Parmar

8y751.NET

my code like this:

if(dstTourData1 != null)

{

if(dstTourData1.Rows.Count > 0)

{

for (int i = 0; i < dstTourData1.Rows.Count; i++)

{

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

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

{

for (int j = 0; j <=dstTourData.Rows.Count; j++)

{

<%=dstTourData1.Rows[i]["CityName"] %>,<%=dstTourData1.Rows[i]["stateName"] %>,<%=dstTourData1.Rows[i]["CountryName"] %>

}

<%=dstTourData1.Rows[i]["CityName"] %>,<%=dstTourData1.Rows[i]["stateName"] %>,<%=dstTourData1.Rows[i]["CountryName"] %>

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

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

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

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

1 Reply

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

Nitin Sontakke8y ago
You could have continued on the same question you raised earlier...why raise another one.

In any case, following, is that I think you need. For better response, please put your data's expected output in MS-Word file or MS-Excel file and upload that.

All we can do is imagine. We cannot run your code and experiment with it.

Also, it is not clear what you want once and what you want repeatedly. I don't think you need the loop with j, that is creating all the problem, I think.

Check code below. Take A SAFE COPY of your code. I don't want to mess it up.
<%
if(dstTourData1 != null)
{
  if(dstTourData1.Rows.Count > 0)
  {
    String lastCityName = String.Empty; String thisCityName = String.Empty;
    for (int i = 0; i < dstTourData1.Rows.Count; i++)
    {
      thisCityName = Convert.ToString(dstTourData1.Rows[i]["CityName"]);
      %>
      class="row">
      <%
      if(lastCityName != thisCityName)
      {
        %>
        class="col-md-3">

<%=thisCityName%>,<%=dstTourData1.Rows[i]["stateName"] %>,<%=dstTourData1.Rows[i]["CountryName"] %>
<%
lastCityName = thisCityName
}
%>
class="col-md-9">
class="col-md-12">
<%=dstTourData1.Rows[i]["lname"] %>
<%=dstTourData1.Rows[i]["detail"] %>
Address : <%=dstTourData1.Rows[i]["address"] %>
"UploadImages/<%=dstTourData1.Rows[i][" image1"]%>" height="60" width="60" style="margin-right:25px" />
"UploadImages/<%=dstTourData1.Rows[i][" image2"]%>" height="60" width="60" style="margin-right:25px" />
"UploadImages/<%=dstTourData1.Rows[i][" image3"]%>" height="60" width="60" style="margin-right:25px" />
"UploadImages/<%=dstTourData1.Rows[i][" image4"]%>" height="60" width="60" style="margin-right:25px" />
"UploadImages/<%=dstTourData1.Rows[i][" image5"]%>" height="60" width="60" style="margin-right:25px" />

}

I had put the closing } because they were not in the code you posted.

if city name is same then it print only one time?

<%=dstTourData1.Rows[i]["CityName"] %>,<%=dstTourData1.Rows[i]["stateName"] %>,<%=dstTourData1.Rows[i]["CountryName"] %>

<%=dstTourData1.Rows[i]["CityName"] %>,<%=dstTourData1.Rows[i]["stateName"] %>,<%=dstTourData1.Rows[i]["CountryName"] %>

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

<%=thisCityName%>,<%=dstTourData1.Rows[i]["stateName"] %>,<%=dstTourData1.Rows[i]["CountryName"] %>

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