c# - 使用带有表名变量的 c#.net 创建数据库表

Question

我尝试了很多方法，但找不到解决方案......

private void button1_Click_1(object sender, EventArgs e)
    {

        string NewTable = TxtPanoNo.Text;


        try
        {
            using (SqlCommand command = new SqlCommand("CREATE TABLE" + NewTable + ""+ "(id tinyint,KullanilanAdet smallint,Tip nchar(20),Kod varchar(50),Ad varchar(50),Aciklama varchar(500),Favori bit)", bgl.baglanti()))
            command.ExecuteNonQuery();

        MessageBox.Show("Succeed");
        }

        catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }



    }

错误是:

incorrect syntax near '('.

Answer 1

CREATE TABLE 和表名之间没有空格。而是使用:

"CREATE TABLE " + NewTable + "(id tinyint, ... and so on