Hey guys,

I've run into a situation where I simply need to take the value returned by my SQL SELECT statement and store that into a string variable. Until now my SELECT statements have just been used to populate datagrids. Here is the statement:

Code:
cmd2.CommandText = "SELECT custemail from customers where businessname='" & newTicket.ComboBox1.Text & "'"
What is the best way to store this value into a string variable for later use? I tried googling but everything I could find is more complicated than what I'm trying to do. Thanks!