Member Avatar for Z33shan

hello :)

i'm using MS access as a database of my Windows form application.
i'm having problem with create table query, with variable table name. i have tried, but it din't work, as i tried. plz provide an example that can make me understand.
suppose,

string city = "newyork";

and city should be the name of table in example.

Thanks :)

  • 3 Contributors
  • 3 Replies
  • 261 Views
  • 1 Day Discussion Span
  • Latest Post Latest Post by aquilax
Member Avatar for ChrisPadgham

please post the sql that is not working

Member Avatar for Z33shan

heres the query that i have used:

"create table '" + new_city + "' (ID AUTONUMBER, population TEXT, area TEXT)";

try to mention adding primary key constraint aswell.

thanks :)

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.