title: Must declare the table variable @table
body: <p>I'm a beginner in C# and SQL, i have this SQL insert statement that i want to perform. It asks for the table name among the other variables that i want to insert.</p>
  
  <p>But when i run this console app i get this error :</p>
  
  <blockquote>
    <p>Must declare the table variable @table</p>
  </blockquote>
  
  <p>This is a part of the code :</p>
  
  <pre><code>StreamReader my_reader =  getFile(args);
  string CS = formCS();
  try
  {
      using (SqlConnection con = new SqlConnection(CS))
      {
          SqlCommand com = new SqlCommand("insert into @table (time, date, pin) values (@time, @date, @pin)", con);                    
          con.Open();
          Console.WriteLine("Enter table name:");
          Console.Write("&gt;&gt; ");
          string tblname = Console.ReadLine();
          com.Parameters.AddWithValue("@table", tblname);
  
          string line = "";
          int count = 0;
          while ((line = my_reader.ReadLine()) != null)
          {
              Dictionary&lt;string, string&gt; result = extractData(line);                        
              com.Parameters.AddWithValue("@time", result["regTime"]);
              com.Parameters.AddWithValue("@date", result["regDate"]);
              com.Parameters.AddWithValue("@pin", result["regPin"]);
              count += com.ExecuteNonQuery();
              com.Parameters.Clear();                        
  
          }
          Console.WriteLine("Recoreds added : {0}", count.ToString());
          Console.WriteLine("Press Enter to exit.");
      }
      Console.ReadLine();
  }
  catch (SqlException ex)
  {
      Console.WriteLine(ex.Message);
  }
  catch (Exception ex)
  {
      Console.WriteLine(ex.Message);                
  }
  </code></pre>