I have a simple question. I know how to do this, just can't remember exactly how to write it out. I don't have access to my notes, or books, and can't seem to find this on the web. So here it goes.
I have a store procedure as a simple select statement.
SELECT VisName FROM tblVis WHERE (VisID = 1)
He is my code.
Dim constr As New SqlConnection(PVDBConn) Try cmdUpd = New SqlCommand("SelVis1Name", constr) cmdUpd.CommandType = CommandType.StoredProcedure constr.Open() cmdUpd.ExecuteNonQuery() constr.Close() Catch ex As Exception MsgBox(ex.Message.ToString) End Try
I want to pass that one value to the property of the button.text property.
Can anybody jog my memory and remind how I pass that result from the SP to that property?