Error CS1026

[knight1001]

I have Error CS1026 for this line of Code:

commandx = new OleDbCommand("SELECT [Username] FROM Users WHERE [Username]= "Username = Request.Form("Username");

I can't figure out why i am recieving this error on that line.

 

[knight1001]

sorry that line was wrong: this is the script

Line 21: if (!(IsPostBack))
Line 22: {
Line 23: commandpartthree = new OleDbCommand("SELECT [Username] FROM Users WHERE [Username]= "Username = Request.Form("Username"));
Line 24: commandpartthree.Connection = connectionpartthree;
Line 25: connectionpartthree.Open();

 

[trollacious]

Shouldn't it be:

commandpartthree = new OleDbCommand("SELECT [Username] FROM Users WHERE [Username]= " + Request.Form("Username"));

Lee

 

[steven290]

actually this looks like a .net question (new OleDbCommand is .net), and this forum is for classic asp try forum855

but i believe the problem is in your sql

try you sql like this

commandpartthree = new OleDbCommand("SELECT [Username] FROM [Users] WHERE [Username]='" & Request.Form("Username") & "'");