1using System;
 2using System.Data;
 3using System.Configuration;
 4using System.Collections;
 5using System.Web;
 6using System.Web.Security;
 7using System.Web.UI;
 8using System.Web.UI.WebControls;
 9using System.Web.UI.WebControls.WebParts;
10using System.Web.UI.HtmlControls;
11using System.Data.SqlClient;
12
13public partial class BackAdmin_Matter_UpdateMatter : System.Web.UI.Page
14...{
15    CAN can = new CAN();
16    protected void Page_Load(object sender, EventArgs e)
17    ...{
18        if (!IsPostBack)
19        ...{
20            DataSet ds = null;
21            ds = can.GetDataSet("select * from tb_question where ID=" + Request["ID"], "tb_question");
22            //SqlConnection myconnection = new SqlConnection("server=(local);user id=sa;PWD=sa;DataBase=db_ComPany");
23            //myconnection.Open();
24            //SqlDataAdapter mydataadapter = new SqlDataAdapter("select * from tb_question where ID=" + Request["ID"], myconnection);
25            //DataSet mydataset = new DataSet();
26            //mydataadapter.Fill(mydataset, "tb_question");
27            DataRowView rowview = ds.Tables["tb_question"].DefaultView[0];
28            txtques.Text = Convert.ToString(rowview["ques"]);
29            txtan.Text = Convert.ToString(rowview["an"]);
30        }
31    }
32    protected void btninsert_Click(object sender, EventArgs e)
33    ...{
34        can.ExecSqlCom("update tb_question set ques='" + this.txtques.Text + "',an='" + this.txtan.Text + "' where ID=" + Request["ID"]);
35        //SqlConnection myconnection = new SqlConnection("server=(local);user id=sa;PWD=sa;DataBase=db_ComPany");
36        //myconnection.Open();
37        //string SqlStr = "update tb_question set ques='" + this.txtques.Text + "',an='" + this.txtan.Text + "' where ID=" + Request["ID"];
38        //SqlCommand mycommand = new SqlCommand(SqlStr, myconnection);
39        //mycommand.ExecuteNonQuery();
40        //mycommand.Dispose();
41        //myconnection.Close();
42        Response.Write("<script lanuage=javascript>alert('修改成功！');location='Matter.aspx'</script>");
43    }
44    protected void Button1_Click(object sender, EventArgs e)
45    ...{
46        Page.Response.Redirect("Matter.aspx");
47    }
48}
49