C#+ rename Access database

• • Reply

  12 years ago

  by FRED596

  Brian Richardson

  , Australia

  Joined 13 years ago

   

  hey frens,

  actually i need to create tables with the user entered value at runtime . i tried providing table name in a string then cerate table through CREATE statement. but it creates table with name the variable name but not value in the variable.

  string r = list_tower.Items[1].ToString();

  string command2 = "CREATE TABLE '"+r+"'(name text(50) NOT NULL)";

  string command2 = "CREATE TABLE r(name text(50) NOT NULL)";

  i tried both of the statements above but failed to get the required result. i think an alternative to this problem is to first crate table and rename it. i need the syntax to rename.

  Thanks

  Radhika

  Report abuse