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();
}
|