Loading

Use C# to create SQLCE database table with numbers in name

Tim Borowsky

Hello,

I'm trying to write an app that allows the user to select a date, and then create a table with that date's name (i.e. 8/5/2014), but the SQL query doesn't like the numbers being used.

cmd = new SqlCeCommand("CREATE TABLE " + dateTimePicker1.Value.Date.ToShortDateString()

+ " (Foo_ID NVARCHAR(20), FooData NVARCHAR(20))",

Conn);

Any suggestions? I'd rather not use a switch-case that spells out month/date/year, as that can get tedious.

Thanks!

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Guest User12y ago
Tim, i've question at your requirement, we can do that say creating 1day=1table, but isn't it messy to manage so many tables, imaging 365 tables in year?

the other design approach is to have single table and add column as date to identify records?

what do you think?