Create database table using c#.net with variable of table name

Question

I tried so many things but I couldn't find a solution..

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);
            }



    }

and the error is:

incorrect syntax near '('.

Apart from the simple syntax error which you could've spotted by inspecting the string, why do you want to create tables on demand? Shouldn't PanoNo simply be a column in the same table? — CodeCaster
– CodeCaster, Commented Nov 30, 2018 at 10:25

Tim Schmelter · Accepted Answer · 2018-11-30 10:01:14Z

3

There is no space between CREATE TABLE and the table-name. Instead use:

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

answered Nov 30, 2018 at 10:01

Tim Schmelter

462k79 gold badges719 silver badges980 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Create database table using c#.net with variable of table name

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related