您应该在查询中使用参数来防止攻击,例如有人输入
'); drop table ArticlesTBL;--'了其中一个作为值之一。
string query = "INSERT INTO ArticlesTBL (ArticleTitle, ArticleContent, ArticleType, ArticleImg, ArticleBrief, ArticleDateTime, ArticleAuthor, ArticlePublished, ArticleHomeDisplay, ArticleViews)";query += " VALUES (@ArticleTitle, @ArticleContent, @ArticleType, @ArticleImg, @ArticleBrief, @ArticleDateTime, @ArticleAuthor, @ArticlePublished, @ArticleHomeDisplay, @ArticleViews)";SqlCommand myCommand = new SqlCommand(query, myConnection);myCommand.Parameters.AddWithValue("@ArticleTitle", ArticleTitleTextBox.Text);myCommand.Parameters.AddWithValue("@ArticleContent", ArticleContentTextBox.Text);// ... other parametersmyCommand.ExecuteNonQuery();


