Author: purplepint | Posted on: 4/5/2010 6:36:47 AM | Views : 249

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 ...