<table class="TableTour2" border="0" cellSpacing="0" cellPadding="0" width="500"> <tbody> <tr> <th scope=col>City</th> <th scope=col>Deluxe Class</th> <th scope=col>Superior Class</th> <th scope=col>Standard Class</th> </tr> <% Dim cnnPH As New System.Data.SqlClient.SqlConnection Dim drPH As System.Data.SqlClient.SqlDataReader Dim cmdPH As System.Data.SqlClient.SqlCommand Try cnnPH.ConnectionString = ConStr cnnPH.Open() cmdPH = New System.Data.SqlClient.SqlCommand("SELECT * from tbdata ") drPH = cmdPH.ExecuteReader While drPH.Read %> <tr> <th class=sub><%Response.Write(drPH("CityName"))%> </th> <td><% Response.Write(drPH("HotelName"))%></td> <td><% Response.Write(drPH("HotelName"))%></td> <td><% Response.Write(drPH("HotelName"))%></td> </tr> <% End While drPH = Nothing cnnPH.Close() : cnnPH = Nothing Catch ex As Exception MsgBox(ex.Message) drPH = Nothing cnnPH.Close() : cnnPH = Nothing End Try %> </tbody> </table>
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)