新手 帮忙看一下有什么错误

[63712885]

SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["SqlDatabase1"].ConnectionString);
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "INSERT INTO * from NewsArticlefrom where Title='" + this.txtTitle.Text + "'and SubTitle='" + this.txtSubTitle.Text + "'and Content='" + this.txtWriter.Text + "'and Writer='" + this.txtContent.Text + "'";
cmd.Connection = conn;
conn.Open();
cmd.ExecuteNonQuery();
conn.Close();
Response.Write("<script language=javascript>alert('添加成功！')</script>");
Response.Redirect("WebForm2.aspx"); 

cmd.ExecuteNonQuery();提示这个附近有语法错误

[bdmh]

sql语句有问题，自己查查

[508938326]

INSERT INTO table(aa,bb)values("value1","value2");

[F15Eagle]

INSERT的主要用法参考以下两种例子 1、用 VALUES 子句为一行指定数据值： INSERT INTO MyTable (PriKey, Description) VALUES (123, 'A description of part 123.') 2、用 SELECT 子查询为一行或多行指定数据值： INSERT INTO MyTable (PriKey, Description) SELECT ForeignKey, Description FROM SomeView

[PPMMOOT]

引用 2 楼 lijunhu1 的回复:

INSERT INTO table(aa,bb)values("value1","value2");

INSERT INTO * from？正确语法

[EnForGrass]

你这个sql的基本语法都不会，还想写好程序，先去学习sql 插入语句 Insert into tableName(column1,column2.........) values(value1,value2.........) cmd.CommandText = "INSERT INTO NewsArticlefrom values ('" + this.txtTitle.Text + "','" + this.txtSubTitle.Text + "','" + this.txtWriter.Text + "','" + this.txtContent.Text + "'";

[F15Eagle]

第二个例子补充一下，如何加条件，感觉楼主是想用第二种方式插入数据啊。 INSERT INTO MyTable (PriKey, Description) SELECT ForeignKey, Description FROM SomeView <where 具体条件> 再多补充一下，2楼的头像居然高我一档啊，哈哈，小心禽流感啊，猛禽先生。

[insus]

什么数据据呀，第一次看到这样写法？


如果是Accesss或是Sql

INSERT INTO [NewsArticlefrom] ([Title],[SubTitle],[Content],[Writer]) VALUES ('" + this.txtTitle.Text + "','" + this.txtSubTitle.Text + "','" + this.txtWriter.Text + "','" + this.txtContent.Text + "')

[63712885]