title: System.Data.SqlClient.SqlException: Incorrect syntax near the keyword 'file'
body: <p>i'm new to AsP.net when i'm trying my usual code to connect to database there's exception keep shown and idon't know what's wrong<br>
  the exception is :</p>
  
  <pre><code>" System.Data.SqlClient.SqlException: Incorrect syntax near the keyword 'file'."
  </code></pre>
  
  <p>and this my code :</p>
  
  <pre><code>string ID = Request.QueryString["id"];
  
  SqlCommand cmd = new SqlCommand("select title,file path,Upload Date from [Media] where ID=@id", conn);
  cmd.CommandType = CommandType.Text;
  SqlDataReader rdr=null;
  
  try
  {
      conn.Open();
      rdr = cmd.ExecuteReader();
      try
      {
          conn.Open();
          rdr = cmd.ExecuteReader();
  
          // print the CustomerID of each record
          while (rdr.Read())
          {
              pathTextBox.Text = rdr["file Path"].ToString();
              DateTextBox.Text = rdr["Upload Date"].ToString();
              titleTextBox.Text = rdr["title"].ToString();
          }
  
          Image1.ImageUrl = pathTextBox.Text;
      }
  </code></pre>