Getting error invalid syntax near: "ResourceName"

[Norris Chappell]

Hi,

I getting an error when trying to debug my code. It is giving me an error: invalid syntax near "ResourceName"

When I remove the where not exists(select * FROM [SP2010_EDCStaffing_AppDB].[dbo].StaffTracking WHERE tempname.Name = Stafftracking.ResourceName"); it run fine

using System;
using System.Configuration;
using System.Data;
using System.Data.Common;
using System.Data.SqlClient;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;

namespace StaffingWebParts.VisualWebPart1
{
public partial class VisualWebPart1UserControl : UserControl
{
public SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["SQLStaffingConn"].ConnectionString);
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
DataTable dt = new DataTable();
dt.Columns.Add("Name");

            SqlDataReader myReader = null;
            SqlCommand cmd = new SqlCommand("select Name FROM \[SP2010\_EDCStaffing\_AppDB\].\[dbo\].\[Tempname\] where not exists (select \* FROM \[SP2010\_EDCStaffing\_AppDB\].\[dbo\].StaffTracking WHERE tempname.Name = Stafftracking.ResourceName");            
                     
            cmd.Connection = conn;
            conn.Open();
            myReader = cmd.ExecuteReader();
            while (myReader.Read())
            {
                DataRow dr = dt.NewRow();
                dr\[0\] = myReader\["Name"\].ToString();
                                             
                dt.Rows.Add(dr);
            }
                      
            GridView1.DataSource = dt;
            GridView1.DataBind();
            conn.Close();
        }
    }
   
  }
}