additems.aspx.cs

很好的毕业设计拿了可以直接用

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 addItems : System.Web.UI.Page
{
    DB db = new DB();
    protected void Page_Load(object sender, EventArgs e)
    {
        string voteTitle = Request.QueryString["voteTitle"].ToString().Trim();
        this.labTitle.Text = voteTitle.ToString();
        //取出相应题目的ID
        string strid = "select id from voteMaster where voteTitle='" + voteTitle + "'";
        int ID=Convert.ToInt32(db.executeGetReturn(strid));
     
    }
    protected void Button1_Click(object sender, EventArgs e)
    {　//添加选项
        string voteTitle = Request.QueryString["voteTitle"].ToString().Trim();
        string strid = "select id from voteMaster where voteTitle='" + voteTitle + "'";
        int ID = Convert.ToInt32(db.executeGetReturn(strid));
        string strsql = "insert into voetDetails(voteItem,id) values('" + this.TextBox1.Text.ToString() + "'," + ID + ")";
        db.NonQueryexecute(strsql);
        Response.Write("<script> alert('添加成功，请继续添加！')　</script>");
        this.TextBox1.Text = "";

    }

    protected void Button2_Click(object sender, EventArgs e)
    {　//完成选项添加，跳转到主页面
        Response.Redirect("index.aspx");
    }
}