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

('"& StudID &"', '"& Email &"')" i am assuming StudID and Email are text boxes. You have to use

('"& StudID.text &"', '"& Email.text &"')"

Mart.

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 &"')"

Im not certain what you mean, but if there are StudentID FirstName LastName BirthDate Password and EmailName columns then the SQL you posted will work.

For more info on INSERT INTO http://www.w3schools.com/sql/sql_insert.asp - http://www.w3schools.com/sql/sql_insert.asp

Mart.

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.

You dont need password fields in your db you can just use

If not password1.Text = Password2.Text Then
'if the passwords are wrong
End If

And if you click buttons twice your browser will request the page again thus the insert into query to your database so there will be two lots of the record.

Marty, the problem with the create account button is that sometimes when its pressed once the record isnt created and i have to click it again for it to be put in.

Do i not need a password field in the DB for when the user returns to log into his account????

Wait. That routine is used to be sure the data gets into the database, because you have to push the button twice. Not really efficient, but it works.

Can you think of any reason why i am having trouble inserting the password data only?? its the only field it wont take.

Post you code. It should look like this:

If txtPwd1.Text = txtPwd2.Text Then
'The database routine
Else
'The error msg.
End If

By the way, VB.NET has validators, which do this kind of validation BEFORE the data goes into the database. That might be a solution.