Question

')' 附近有语法错误。

protected void Button1_Click(object sender, EventArgs e)
{
string _title = tbTitle.Text;
string _brief = tbBrief.Text;
string _authors = tbAuthors.Text;
string _source = tbSource.Text;
string _content = tbContents.Text;
string strSql = string.Format("insert into news(title,parentid,brief,citme,authors,source,contents,) values('{0}','{1}','{2}','{3}','{4}','{5}','{6}')", _title, 1, _brief, DateTime.Now, _authors, _source, _content);
SqlConnection conn = new SqlConnection("Data Source=.;Initial Catalog=class1;Persist Security Info=True;User ID=sa;Password=P@ssw0rd");
conn.Open();
SqlCommand cmd = new SqlCommand(strSql, conn);
int i = cmd.ExecuteNonQuery();
conn.Close();
}
}
int i = cmd.ExecuteNonQuery();
错误标出是这一行')' 附近有语法错误。

Answer 1

insert into news(title,parentid,brief,citme,authors,source,contents,) 这里contents后边多了个逗号