Getting Error: The multi-part identifier "Table.Fiel d" could not be bound.

[mknoll217]

I am recieving this error from my code:
The multi-part identifier "PAR.Unique ID" could not be bound.
The multi-part identifier "Salary.UniqueI D" could not be bound.
The multi-part identifier "PAR.Unique ID" could not be bound.
The multi-part identifier "PAR.PAR_Status " could not be bound.
The multi-part identifier "Salary.New_Sal ary" could not be bound.
The multi-part identifier "Salary.UniqueI D" could not be bound.
The multi-part identifier "PAR.Unique ID" could not be bound.
The multi-part identifier "PAR.PAR_Status FROM" could not be bound.
Invalid column name 'PAR'.

SqlConnection adoConnSal = new SqlConnection("server=DEL-CD212; uid=sa;" +
                    "pwd=graver; database=PAR");
         adoConnSal.Open();
 
 
         string sqlSal = "SELECT Salary.New_Salary, Salary.UniqueID, PAR.UniqueID, PAR.PAR_Status";
sqlSal += "FROM Salary, PAR WHERE PAR.UniqueID=Salary.UniqueID AND PAR.UniqueID='100002' AND PAR.PAR_Status= 'current'";
 
         SqlCommand adoCmdSal = new SqlCommand(sqlSal, adoConnSal);
 
         SqlDataReader adoDRSal = adoCmdSal.ExecuteReader();
 
         if (adoDRSal.HasRows)
         {
             while (adoDRSal.Read())
             {
                 TextBox1.Text = (adoDRSal["Salary.New_Salary"].ToString());
             }
         }
 
         adoDRSal.Close();
         adoDRSal.Dispose();
         adoCmdSal.Dispose();
         adoConnSal.Close();
         adoConnSal.Dispose();
 
 

I can't figure out what the issue is. I know the SQL works because I ran it in SQL Server. It is giving the error at line 11. Thanks.

[Frinavale]

Hi MKnoll217!

Humor me and try changing:

tring sqlSal = "SELECT Salary.New_Salary, Salary.UniqueID, PAR.UniqueID, PAR.PAR_Status";
sqlSal += "FROM Salary, PAR WHERE PAR.UniqueID=Salary.UniqueID AND PAR.UniqueID='100002' AND PAR.PAR_Status= 'current'";

to:

tring sqlSal = "SELECT Salary.New_Salary, Salary.UniqueID, PAR.UniqueID, PAR.PAR_Status";
sqlSal += " FROM Salary, PAR WHERE PAR.UniqueID=Salary.UniqueID AND PAR.UniqueID='100002' AND PAR.PAR_Status= 'current'";