admin/zhuanye_insert.aspx.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

using System;
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;
using System.Data.SqlClient;

public partial class admin_zhuanye_insert : System.Web.UI.Page
{
    DataCode dataconn = new DataCode();
    protected void Page_Load(object sender, EventArgs e)
    {

    }

    protected void btnTest_Click(object sender, EventArgs e)
    {
        string sqlstr = "select * from tb_Profession where Name='" + this.txtProName.Text + "'";
        //创建一个新的数据库连接对象
        SqlConnection sqlconn = dataconn.getcon();
        //打开数据库连接
        sqlconn.Open();
        //定义并初使化命令对象
        SqlCommand sqlcom = new SqlCommand(sqlstr, sqlconn);
        //创建一个数据阅读器
        SqlDataReader read = sqlcom.ExecuteReader();
        //如果记录不为空
        read.Read();
        if (read.HasRows)
        {
            if (this.txtProName.Text.Trim() == read["Name"].ToString().Trim())
            {
                Label2.Text = "专业已经存在，请重新填写";
                txtProName.Text = "";
                txtProName.Focus();
                btnAdd.Enabled = false;
                Label2.Visible = true;
                btnTest.Enabled = true;
                return;
            }
            else
            {
                Label2.Visible = true;
                Label2.Text = "该专业可以进行正常注册";
                btnAdd.Enabled = true;
                btnTest.Enabled = false;
            }
        }
        else
        {
            Label2.Visible = true;
            Label2.Text = "该专业可以进行正常注册";
            btnAdd.Enabled = true;