zhuangyeinsert.aspx.cs

来自「SQL+Asp.net(c#)网上考试系统」· CS 代码 · 共 68 行

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

public partial class HouAdmin_ZhuangyeInsert : System.Web.UI.Page
{
    Datacon dataconn = new Datacon();
    protected void Page_Load(object sender, EventArgs e)
    { 
    }
    protected void Button1_Click(object sender, EventArgs e)
    {
        dataconn.eccom("insert into tb_Profession(Name)values('" + txtProName.Text + "')");
        Page.Response.Redirect("zhuanye_xinxi.aspx");
    }
    protected void Button2_Click(object sender, EventArgs e)
    {
        Page.Response.Redirect("zhuanye_xinxi.aspx");
    }
    protected void TreeView1_SelectedNodeChanged(object sender, EventArgs e)
    {
        if (TreeView1.SelectedNode.Text == "退出系统")
        {
            Response.Write("<script lanuage=javascript>window.close();location='javascript:history.go(-1)'</script>");
        }
    }
    protected void btnTest_Click(object sender, EventArgs e)
    {
        string sqlstr = "select * from tb_Profession";
        SqlConnection sqlconn = dataconn.getcon();
        sqlconn.Open();
        SqlCommand sqlcom = new SqlCommand(sqlstr, sqlconn);
        SqlDataReader read = sqlcom.ExecuteReader();
        while (read.Read())
        {
            if (this.txtProName.Text.Trim() == read["Name"].ToString().Trim())
            {
                //Response.Write("<script lanuage=javascript>alert('该专业已经存在，请重新填写专业名称');location='javascript:history.go(-1)'</script>");
                Label2.Text = "该专业已经存在，请重新填写专业名称";
                txtProName.Text = "";
                txtProName.Focus();
                Label2.Visible = true;
                return;
            }
            else
            {
                //Response.Write("<script lanuage=javascript>alert('该专业可以进行正常注册');location='javascript:history.go(-1)'</script>");
                Label2.Text = "该专业可以进行正常注册";
                
            }
        }
        read.Close();
        sqlconn.Close();btnTest.Enabled = false;
        if (btnTest.Enabled == false)
        {
            btnAdd.Enabled = true;
        }
    }
}