C#中具有可变表名的插入命令中的语法错误 [英] syntax error in insert command with variable tablename in c#

问题描述

你好.

我必须执行各种sql查询，但是我的表名存储在变量中.
我在插入INSERT INTO命令的数据代码时遇到问题，显示语法错误:

Hello.

I have to execute various sql queries but my table name is stored in a variable.
I am having problem in inserting data code of INSERT INTO command shows syntax error:

using (OleDbCommand cmd = con.CreateCommand())
            {
                cmd.CommandText = "INSERT INTO" + inp_table + ""+ "([date],[open],[high],[low],[close],[volume])" + "values(@date, @open,@high,@low,@close,@volume)";

                 String dt = dateTimePicker1.Value.ToShortDateString();
                cmd.Parameters.AddRange(new OleDbParameter[]
                {
                    new OleDbParameter("@date",dt),
                    new OleDbParameter("@open",textBox1.Text ),
                    new OleDbParameter("@high",textBox2.Text ),
                    new OleDbParameter("@low",textBox3.Text ),
                    new OleDbParameter("@close",textBox4.Text),
                    new OleDbParameter("@volume",textBox5.Text)
                });
                cmd.ExecuteNonQuery();
            }

请帮助 asap

Please help asap

推荐答案

我认为您可能会发现需要添加几个空格并重新格式化字符串:

I think you may find you need to add a couple of spaces and reformat the string:

cmd.CommandText = "insert into " + inp_table + " ([date],[open],[high],[low],[close],[volume]) values(@date, @open,@high,@low,@close,@volume)";

我不会提到存储过程. :-)

I won''t mention stored procedures. :-)

这篇关于C#中具有可变表名的插入命令中的语法错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！