nethoutai/Exam.aspx.cs

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

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

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;
using CommonLib;
using DBUtility;
public partial class admin_Exam : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        if (Request.QueryString["id"].ToString() != null)
        {
            SqlHelper.BindGridview(GridView1, SqlHelper.ConnectionStringLocalTransaction, CommandType.Text, "select *from T_Exams where ChapterId='" + Request.QueryString["id"].ToString()+ "'", null);
        }
    }
   
    
    protected void Button1_Click1(object sender, EventArgs e)
    {
        string qwe, anw1, anw2, anw3, anw4, anw;
        qwe = TextBox2.Text;
        anw1 = TextBox3.Text;
        anw2 = TextBox7.Text;
        anw3 = TextBox4.Text;
        anw4 = TextBox5.Text;
        anw = TextBox6.Text;
        SqlConnection conn = new DBCon().getCon();
        SqlCommand cmd = new SqlCommand();
        cmd.Connection = conn;
        cmd.CommandText = "insert into  T_Exams(ExamQue,A,B,C,D,ExamAns,ChapterId)values('" + qwe + "','" + anw1 + "','" + anw2 + "','" + anw3 + "','" + anw4 + "','" + anw + "','"+Request.QueryString["id"].ToString()+"')";
        int i = cmd.ExecuteNonQuery();
        if (i > 0)
        {
            JavaScriptHelper.Alert("添加成功");
            TextBox2.Text = "";
            TextBox3.Text = "";
            TextBox4.Text = "";
            TextBox5.Text = "";
            TextBox6.Text = "";
            TextBox7.Text = "";
        }
        else
        {
            JavaScriptHelper.Alert("添加失败");

        }
        SqlHelper.BindGridview(GridView1, SqlHelper.ConnectionStringLocalTransaction, CommandType.Text, "select *from T_Exams where ChapterId='" + Request.QueryString["id"].ToString()+ "'", null);
    }
    protected void GridView1_RowEditing(object sender, GridViewEditEventArgs e)
    {
        
        string a,b,c,d,m,f,g;
        a = ((Label)GridView1.Rows[e.NewEditIndex].Cells[0].FindControl("Label1")).Text;