StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POasp.net variable passing
primarykey
Id
11886700
data
AcceptedAnswerId
11886939
AnswerCount
2
ClosedDate
CommentCount
2
CommunityOwnedDate
CreationDate
2012-08-09T15:25:22.873
FavoriteCount
0
LastActivityDate
2013-04-29T09:03:36.140
LastEditDate
2013-04-29T09:03:36.140
LastEditorUserId
813602
OwnerUserId
277480
ParentId
0
PostTypeId
1
Score
0
ViewCount
38
LastEditorDisplayName
text
Body
I am having an odd accuence when i am trying to get my page loaded value to place into a database after the user submits. When the page loads i have this: <pre><code>Public theProductName As String = "" Dim theProductCategory As String = "" Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load If Not IsPostBack Then LoadProductName() End If End Sub Private Sub LoadProductName() objConn = New MySqlConnection(product.strConnString) objConn.Open() strSQL = "SELECT id, name, category " & _ "FROM product " & _ "WHERE id = 4;" Try objCmd = New MySqlCommand(strSQL, objConn) dtReader = objCmd.ExecuteReader() While dtReader.Read() theProductName = dtReader("name") theProductCategory = dtReader("category") btnSubmit.Text = "Add Item to " & theProductName End While dtReader.Close() dtReader = Nothing objConn.Close() objConn = Nothing Catch ex As Exception MsgBox("LoadProductName: " & ex.Message) End Try End Sub </code></pre> When i check those values on startup of the page they have the correct values and even the submit button has the products name. However, once i got to save it after pushing the button it has that same variable as nothing?? <pre><code>Private Sub btnSubmit_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles btnSubmit.Click Dim productName As String = theProductName.Replace(" ", "-") Dim imageName As String = productName & "\" & Trim(txtModel.Text) & ".jpg'" Dim theCat as String = theProductCategory End Sub </code></pre> productName here is nothing as is theCat What could i be overlooking?
Tags
<asp.net><variables>
Title
asp.net variable passing
singulars
PostAcceptedAnswerId
1. PO
 singulars
 PostTypePostTypeId
 PTAnswer
PostParentId
1. This table or related slice is empty.
PostTypePostTypeId
1. PTQuestion
UserLastEditorUserId
1. USIngo Karkat
UserOwnerUserId
1. USStealthRT
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. PO
 singulars
 PostTypePostTypeId
 PTAnswer
2. PO
 singulars
 PostTypePostTypeId
 PTAnswer
VotesPostIdCreationDate
1. This table or related slice is empty.
CommentsPostId
1. COWhat is 'theProductName'? It looks like a string - where is it declared/set?
 singulars
 PostPostId
 POasp.net variable passing
 UserUserId
 USn8wrl
2. CO@n8wrl: I have updated my OP with that information. I have **Public** for **theProductName** since i am using that within my html page **(<%=theProductName%>)**
 singulars
 PostPostId
 POasp.net variable passing
 UserUserId
 USStealthRT

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.