StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
primarykey
Id
2285946
data
AcceptedAnswerId
0
AnswerCount
0
ClosedDate
CommentCount
2
CommunityOwnedDate
CreationDate
2010-02-18T02:43:45.940
FavoriteCount
0
LastActivityDate
2010-02-20T18:09:55.790
LastEditDate
2010-02-20T18:09:55.790
LastEditorUserId
96062
OwnerUserId
96062
ParentId
2285666
PostTypeId
2
Score
1
ViewCount
0
LastEditorDisplayName
text
Body
I would suggest using the built in grid controls. Here is a walkthrough <a href="http://msdn.microsoft.com/en-us/library/sdba1d59.aspx" rel="nofollow noreferrer">Walkthrough: Editing and Inserting Data in Web Pages with the DetailsView Web Server Control</a> . It might be better to start with <a href="http://msdn.microsoft.com/en-us/library/tw738475.aspx" rel="nofollow noreferrer">Walkthrough: Basic Data Access in Web Pages</a>. If you choose to move forward with HTML then here is one way to do it based on what you provided. You can add an update button and try this code in that event: <pre><code>'Create an update Command with the apropriate paramaters' Dim sql = ("UPDATE SO_Prices SET Price = @Price WHERE ID = @ID") Dim Cmd As New SqlCommand(sql, connection) Cmd.Parameters.Add("@Price", SqlDbType.SmallMoney) Cmd.Parameters.Add("@ID", SqlDbType.Int) connection.Open() 'Loop through the fields returned' For Each Key As String In Request.Form.Keys 'Make sure you only process fields you want' If Key.StartsWith("price") Then 'Pull the ID out of the field name by splitting on the underscore' ' then choosing the second item in the array' Dim ID As String = Key.Split("_")(1) 'Update the paramaters for the update query' Cmd.Parameters("@ID").Value = ID Cmd.Parameters("@Price").Value = Request.Form(Key) 'Run the SQL to update the record' Cmd.ExecuteNonQuery() End If Next connection.Close() </code></pre> Let me know if you need any additional assitance. If not, please mark this as the correct answer.
Tags
Title
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. POHow do I add htmltablecell data to database after I click submit
 singulars
 PostTypePostTypeId
 PTQuestion
PostTypePostTypeId
1. PTAnswer
UserLastEditorUserId
1. USBentley Davis
UserOwnerUserId
1. USBentley Davis
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. This table or related slice is empty.
PostsParentIdCreationDate
1. This table or related slice is empty.
VotesPostIdCreationDate
1. VO
 singulars
 PostPostId
 PO
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTUpMod
CommentsPostId
1. COi have to use html table, the code is already done. now how do i save the new value in text boxes to database?
 singulars
 PostPostId
 PO
 UserUserId
 USiuers
2. COiuers, I updated my code. Does this solve your question?
 singulars
 PostPostId
 PO
 UserUserId
 USBentley Davis

Querying!

Guidance

A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.