tianjia.aspx.cs

用asp.net开发的考试系统

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 Default4 : System.Web.UI.Page
{
    SqlConnection cn;
    SqlCommand com;
    protected void Page_Load(object sender, EventArgs e)
    {
    
       DropDownList dd1 = new DropDownList();
       getconn();
       com.CommandText = "select * from kecheng";
       SqlDataReader dr = com.ExecuteReader();
       while (dr.Read()) { ListItem l1=new ListItem (dr.GetString(1),dr.GetString(0));
       dd1.Items.Add(l1); 
    
       }
       Table1.Rows[1].Cells[1].Controls.Add(dd1);
        TextBox t1 = new TextBox();
       // TextBox t2 = new TextBox();
        t1.Width = 300;
        //t2.Width = 300;
        Table1.Rows[2].Cells[1].Controls.Add(t1);
        Table1.Rows[3].Cells[1].Text = DateTime.Now.ToShortDateString();
        Button b1 = new Button();
        b1.Text = "添加试题";
        b1.Click += new System.EventHandler(this.button_click);
        Table1.Rows[4].Cells[0].Controls.Add(b1);
    }

    public void button_click(object sender,EventArgs e) {
    
        string title=((TextBox )Table1.Rows[2].Cells[1].Controls[0]).Text ;
        if (title == "")
        {
            Response.Write("<script language=javascript>window.alert('题目不能为空')</script>");
           
        }
        else
        {
            string s = ((DropDownList)Table1.Rows[1].Cells[1].Controls[0]).SelectedValue;
            getconn();

            com.CommandText = "insert into kaoshi(title,jointime,courseid) values('" + title + "','" + Table1.Rows[3].Cells[1].Text + "','" + s + "')";
            com.ExecuteNonQuery();
            string sql2 = "select top 1 * from kaoshi order by id desc";
            com.CommandText = sql2;
            int i = (int)com.ExecuteScalar();
            cn.Close();

            Session["kaoti"] = true;

            // Response.Write("<script language=javascript>window.alert('添加成功')</script>");
            Response.Redirect("tianjiatimu.aspx?kaoshiid=" + i);
        }
    }
    public void getconn(){
    
     string conn = ConfigurationManager.AppSettings["strconn"];
      cn = new SqlConnection(conn);
        cn.Open();
        com = new SqlCommand();
        com.Connection = cn;
    }



}