Our Training Programs

View all

AI & Machine Learning
Mastering Large Language Models
Mastering Prompt Engineering
Certified Vibe Coder
Github Copilot Training
Generative AI for Beginners
n8n Automation & AI Agents Training

About Us Contact Us Privacy Policy Terms Brand Guidelines Partners C# Tutorials Consultants Ideas Report A Bug FAQs Sitemap Stories CSharp TV DB Talks Web3 Universe Jumpstart Blockchain

All contents are copyright of their authors.

Using C# to create table in SQLCE database with date for nam

Home
Forums
Visual Basic .NET

Using C# to create table in SQLCE database with date for nam

Tim Borowsky

12yAsked Aug 5, 2014, 3:08 PM1.4kVisual Basic .NET

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!

2 Replies

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

It is the same account you read, post and publish with — and you will come straight back to this page.

Tim Borowsky12y ago
Thanks! That did the trick.
Vulpes12y ago
I'm not sure what the rules for identifiers are in SQL CE but, if they're the same as its 'big brother' SQL Server, then:

1. They can't begin with a number.

2. They can't include '/' but they can include '_' and can also begin with it.

So I'd try using a name such as _8_5_2014:

cmd = new SqlCeCommand("CREATE TABLE " + dateTimePicker1.Value.Date.ToString("_M_d_yyyy")
+ " (Foo_ID NVARCHAR(20), FooData NVARCHAR(20))",
Conn);