& Problem

This is similar to the problem further down the page but im still stumped.

The error is: BC30452: Operator '&' is not defined for types 'String' and 'System.Web.UI.WebControls.TextBox'

my SQL statement is as follows.

aQuery = "Insert Into Students(StudentID, EmailName) VALUES ('"& StudID &"', '"& Email &"')"

Im trying to take the StudID and Email from two textboxes. Is there a couple of lines to take the data from the textboxes and convert it or where am i going wrong??
Appreciate and suggestions.

Thanks

Thanks very much marty,

Was having awful trouble with what is a simple error! Only started ASP.Net few weeks ago.

Marty another question, say i have 5 fields on my form, Student Id, First Name, Last Name, Password, Email.  In my table they are not in that order.  Does that make a difference for taking them in?? I can get it to work for just the StudID and Email but when i try adding the next few i get an error that theres wrong SQL syntax.

Bit messy:

Insert Into Students(StudentID, FirstName, LastName, BirthDate, Password, EmailName)

VALUES ('"& StudID.Text &"', '"& F_Name.Text &"', '"& L_Name.Text &"', '"& D_O_B.Text &"', '"& Password1.Text &"', '"& Email.Text &"')"

Disregard the last question marty.  Realised it doesnt.

The problem is with the password entry. at the moment i have 2 password fields, password1, password2.  I intend to do a comaprison to ensure they match but at the moment if i only enter data into the first box it gives me an error, when i leave password out of the sql statement it enters the rest perfect. 

Also, sometimes i have to click the create account button twice for the record to go in. the second time i press it, it tells me that theres already a record in there matching.