Question

vs中C#写插入语句，运行时插入数据后，数据库中没有数据

using System;
using System.Data.SqlClient;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;

namespace Example05.Ex05_02
{
public partial class Ex05_19 : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{

}

protected void Button1_Click(object sender, EventArgs e)
{
SqlConnection myConnection = new SqlConnection("server=localhost;uid=sa;pwd=;database=Northwind");
string strSQL = "insert into zc(用户名，密码，学号，电子邮件) values ('" + TextBox1.Text + "','" + TextBox2.Text + "','" + TextBox4.Text + "','" + TextBox5.Text + "')";
try
{
myConnection.Open();
SqlCommand mySqlCommand = new SqlCommand(strSQL, myConnection);
mySqlCommand.ExecuteNonQuery();
Label1.Text = "注册成功!";
}
catch
{
Label1.Text = "数据库连接失败！";
}
finally
{
myConnection.Close();
}
}
}
}

代码就是这个，初学，这个问题折腾了几天，就是找不到毛病！
运行时不会报错，但是前台插入数据，就是提示数据库连接失败，然后看库中还是空的。

Answer 1

自己加断点调试一下，就知道具体哪错了。

Answer 2

把SA账户设个密码试试

Answer 3

strSQL一定错了