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 Class_tianjia : System.Web.UI.Page
{
    SqlConnection con;
   
    SqlCommand cmd, cmd1;
    SqlDataReader dr,dr1;
    sqldata sqldata;
    string strsql, strsql1;
    protected void Page_Load(object sender, EventArgs e)
    {
        TreeView1.ExpandAll();//展开树的所有节点
        /* if (!this.IsPostBack)
        {
            if (Session["name"] == null)
            {
                Response.Redirect("login.aspx");
            }
            else
            {
                this.lblname.Text = Convert.ToString(Session["name"]);
            }
        }*/

        if (!IsPostBack)
        {
            con = sqldata.createcon();
            con.Open();
            strsql = "select Col_name from College ";
            cmd = new SqlCommand(strsql, con);
            dr = cmd.ExecuteReader();
            this.ddlxueyuan.DataSource = dr;
            this.ddlxueyuan.DataTextField = "Col_name";
            this.ddlxueyuan.DataBind();
            con.Close();

            con = sqldata.createcon();
            con.Open();
            strsql1 = "select Pro_name from Professional ";
            cmd1 = new SqlCommand(strsql1, con);
            dr1 = cmd1.ExecuteReader();
            this.ddlzhuanye.DataSource = dr1;
            this.ddlzhuanye.DataTextField = "Pro_name";
            this.ddlzhuanye.DataBind();


            this.ddlzhuanye.Items.Add("请选择您的专业名称");
            this.ddlzhuanye.SelectedIndex = this.ddlzhuanye.Items.Count - 1;



            this.ddlxueyuan.Items.Add("请选择您的学院名称");
            this.ddlxueyuan.SelectedIndex = this.ddlxueyuan.Items.Count - 1;
            con.Close();
        }
    }
 
    protected void btnyes_Click(object sender, EventArgs e)
    {
        //校验数据

        string Col_name, Pro_name, Cla_name, Cla_teacher,Cla_else;
        Col_name = this.ddlxueyuan.Text;
        Pro_name = this.ddlzhuanye.Text;
        Cla_name = this.txtname.Text;
        Cla_teacher = this.txtteacher.Text;
        Cla_else = this.txtelse.Text;

        //连接数据库
        SqlConnection con = new SqlConnection();

        con = sqldata.createcon();
        con.Open();

        SqlCommand cmd = new SqlCommand();
        cmd.Connection = con;
         = CommandType.Text;
         = "select * from Class where Cla_name='"+this .txtname .Text +"'";
        SqlDataReader dr;
        dr = cmd.ExecuteReader();
        if (dr.Read())
        {
            lbltishi.Text = "该班级信息已存在！";

        }
        else
        {

            dr.Close();


            SqlCommand cmd1 = new SqlCommand();
            cmd1.Connection = con;
             = CommandType.Text;
             = "insert into Class (Col_name, Pro_name, Cla_name, Cla_teacher,Cla_else) values ('" +this .ddlxueyuan .SelectedItem .Value .ToString ()+ "','" +this .ddlzhuanye .SelectedItem .Value .ToString () + "','" + txtname .Text + "','"+txtteacher .Text +"','"+txtelse .Text +"')";

            try
            {

                cmd1.ExecuteNonQuery();
                Response.Write("<script language=javascript>alter('添加信息成功！');history.go(-1);</script>");
                // btnchakan.Enabled = true;
                Response.End();


            }
            catch (SqlException s)
            {
                Response.Write("<script language=javascript>alter('添加信息失败！');history.go(-1);</script>");

            }


            finally
            {

                con.Close();

            }
        }      
    }
    protected void btnno_Click(object sender, EventArgs e)
    {
       this.txtname.Text="";
       this.txtteacher.Text="";
       this.txtelse.Text="";
    }
    protected void btnchakan_Click(object sender, EventArgs e)
    {

    }
}

我也是菜鸟，哪块的代码添加不进去数据呀？

刚刚修改了一下数据库  填是填进去了  但是后半部分的

            try
            {

                cmd1.ExecuteNonQuery();
                Response.Write("<script language=javascript>alter('添加信息成功！');history.go(-1);</script>");
                // btnchakan.Enabled = true;
                Response.End();


            }
            catch (SqlException s)
            {
                Response.Write("<script language=javascript>alter('添加信息失败！');history.go(-1);</script>");

            }


            finally
            {

                con.Close();

            }
        }      

不起作用  添加成功后 直接变成白页

我有点不懂你的意思！asp网页，你每刷新一次页面，它都会从服务器上重新下载页面！