Hi, not sure if you'll still after a reply for this post but if you run that SQL statement and store the result in a variable (or dataset, datatable), that result will be able to be applied to the text box.
E.g. If you executed the command like this
Dim result as String
result = cmd.ExecuteScalar()
the result could then be placed in the text box
TextBox.Text = result
Hope that helps,
Steve
"I will prepare and one day my chance will come."
|