Click here to Skip to main content
15,905,607 members

Comments by simanungkalit (Top 1 by date)

simanungkalit 5-Feb-13 2:10am View    
i have problem with modification Header table

Example Table:

<table class="TableTour2" border="0" cellSpacing="0" cellPadding="0" width="500">
<tr>
<td width="157" rowspan="2"><div align="center">No</div></td>
<td colspan="4"><div align="center">Class</div></td>
</tr>
<tr>
<td width="147"><div align="center">City</div></td>
<td width="137"><div align="center">Deluxe Class</div></td>
<td width="162"><div align="center">Superior Class</div></td>
<td width="75"><div align="center">Standard Class</div></td>
</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>
<td><%Response.Write(drPH("CityName"))%> </td>
<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
%>
</table>

=====================================
If i Display with gridview i not have modification header

thanks