用C#将数据插入数据库，判断是否重复

protected void submit_Click(object sender, EventArgs e)

{

string code;

code = Convert.ToString(this.TextBox1.Text);

System.Text.RegularExpressions.Regex regex = new System.Text.RegularExpressions.Regex(@"'", System.Text.RegularExpressions.RegexOptions.IgnoreCase);

code = regex.Replace(code, " ");

SqlConnection conn = new SqlConnection("Data Source=.;Initial Catalog=CodeRead;uid=sa;pwd= ");

conn.Open();

string sql = "select Count(1) from code where numble=('" + code + "')";

SqlCommand cmd1 = new SqlCommand(sql, conn);

int count = (int)cmd1.ExecuteScalar();

if (count > 1)

Response.Write("数据重复！");

else

{

SqlCommand cmd = new SqlCommand("insert into code(numble) values('" + code + "')", conn);

cmd.ExecuteNonQuery();

if (cmd.ExecuteNonQuery() > 0)

Response.Write(code + "数据导入成功！");

else

Response.Write("数据导入错误！");

conn.Close();

}