Must declare the table variable @table

by

You can’t do this. You can’t pass the table name as a parameter the way you did:

SqlCommand com = new SqlCommand("insert into @table ...");
...
com.Parameters.AddWithValue("@table", tblname);

You can do this instead:

Console.WriteLine("Enter table name:");
Console.Write(">> ");
string tblname = Console.ReadLine();

string sql = String.Format("insert into {0} (time, date, pin) values ... ", tblname);

SqlCommand com = new SqlCommand(sql, con);                    

...

More Related Contents:

  1. Can’t specify the ‘async’ modifier on the ‘Main’ method of a console app
  2. How do parameterized queries help against SQL injection?
  3. How to cancel Task await after a timeout period
  4. Show/Hide the console window of a C# console application
  5. How to execute an .SQL script file using c#
  6. Entering keys manually with Entity Framework
  7. How to stop C# console applications from closing automatically? [duplicate]
  8. Pass table valued parameter using ADO.NET
  9. How to run console application from Windows Service?
  10. Getting return value from stored procedure in C#
  11. SQL error: Incorrect syntax near the keyword ‘User’
  12. Could not find an implementation of the query pattern
  13. C# guid and SQL uniqueidentifier
  14. Local sequence cannot be used in LINQ to SQL implementation of query operators except the Contains() operator
  15. Stop SQL query execution from .net Code
  16. Entity Framework. Delete all rows in table
  17. Why does computing factorial of relatively small numbers (34+) return 0?
  18. Multi threading C# application with SQL Server database calls
  19. Use linq to generate direct update without select
  20. Is there a way to make a console application run using only a single file in .NET Core?
  21. How do I only allow number input into my C# Console Application?
  22. NHibernate – Many to Many Query using Junction/Joiner Table
  23. ThreadPool not starting new Thread instantly
  24. When is it better to write “ad hoc sql” vs stored procedures [duplicate]
  25. Convert SQL to LINQ Query [closed]
  26. how to recognize similar words with difference in spelling
  27. How do I find out what directory my console app is running in?
  28. System.drawing namespace not found under console application
  29. Mapping columns in a DataTable to a SQL table with SqlBulkCopy
  30. SQL connection string for microsoft access 2010 .accdb

Leave a Comment