asp.net编写sql语句出现问题

            string name = TextBox2.Text;

            string place = TextBox3.Text;

            string roll = TextBox4.Text;

            string country = TextBox5.Text;

            string str = "INSERT INTO Table( 网站名,网址,排名,国家 ) VALUES ('" + name + "," + place + "," + roll + "," + country + "')"; //INSERT INTO Websites(name, url, alexa, country) VALUES('百度', 'https://www.baidu.com/', '4', 'CN');

            string sql = "Data Source=(LocalDB)\\MSSQLLocalDB;AttachDbFilename=C:\\Users\\wyb\\OneDrive\\ASP\\WebApplication2\\数据库\\新建数据库.mdf;Integrated Security=True;Connect Timeout=30";

            SqlConnection con = new SqlConnection(sql);

            con.Open();

            SqlCommand sqlopen = new SqlCommand(str, con);

            sqlopen.ExecuteNonQuery();

            con.Close();

报错是关键字Table附近语法不正确，我的sql数据表叫Table

insert into [table] 你的表名外边加个中括号就可以了

可以参考我的文章 https://blog.csdn.net/superwfei/article/details/103780405?spm=1001.2014.3001.5502

sql = "INSERT INTO Table( 网站名,网址,排名,国家 ) VALUES ('" + name + "," + place + "," + roll + "," + country + "')"

"INSERT INTO Table( 网站名,网址,排名,国家 ) VALUES ('" 
+ name 
+ "," 
+ place 
+ "," 
+ roll 
+ "," 
+ country 
+ "')"

整个看下来，values 里只有一个值，为什么呢，因为全部都在一个单引号里

sql = "INSERT INTO Table( 网站名,网址,排名,国家 ) VALUES ('" + name + "','" + place + "'," + roll + ",'" + country + "')"

您好，我是有问必答小助手，您的问题已经有小伙伴解答了，您看下是否解决，可以追评进行沟通哦~

如果有您比较满意的答案 / 帮您提供解决思路的答案，可以点击【采纳】按钮，给回答的小伙伴一些鼓励哦～～

ps:问答VIP仅需29元，即可享受5次/月 有问必答服务，了解详情>>>https://vip.csdn.net/askvip?utm_source=1146287632