Hi, I'm creating a table in a loop and placing the necessary values from my database into it. All this is stored in a string builder and then placed in a literal.
What I need to do next to cost is place a text box so a user can add the quantity. Any suggestions how I can do this inside the table (code shown below)?
Dim SqlGetSelectedExtras As String = "SELECT Extras.ExtraName, ExtrasToSchemes.Cost FROM Extras INNER JOIN ExtrasToSchemes ON Extras.ExtraID = ExtrasToSchemes.ExtraID WHERE ExtraToSchemeID = @ExtraToSchemeID"
Dim GetSelectedExtrasCmd As New SqlCommand(SqlGetSelectedExtras, con)
ExtrasLbl.Text = "<table><tr><td>Item</td><td>Cost</td><td> </td></tr>"
For k = 0 To ExtrasToSchemes.Count - 1
GetSelectedExtrasCmd.Parameters.Clear()
GetSelectedExtrasCmd.Param ...
Go to the complete details ...