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_CompanyPresentation : 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_Intro where id=1", "tb_Intro");
22            //SqlConnection mycon = new SqlConnection("server=(local);user id=sa;PWD=sa;DataBase=db_ComPany");
23            //mycon.Open();
24            //SqlDataAdapter myadapter = new SqlDataAdapter("select * from tb_Intro where id=1", mycon);
25            //DataSet myds = new DataSet();
26            //myadapter.Fill(myds, "tb_Intro");
27            DataRowView rowview = ds.Tables["tb_Intro"].DefaultView[0];
28            this.TextBox1.Text = rowview["intro"].ToString();
29        }
30    }
31    protected void Button1_Click(object sender, EventArgs e)
32    ...{
33        can.ExecSqlCom("update tb_Intro set intro='" + this.TextBox1.Text + "' where ID=1");
34        //SqlConnection mycon = new SqlConnection("server=(local);user id=sa;PWD=sa;DataBase=db_ComPany");
35        //mycon.Open();
36        //SqlCommand mycom = new SqlCommand("update tb_Intro set intro='" + this.TextBox1.Text + "' where ID=1", mycon);
37        //mycom.ExecuteNonQuery();
38        //mycom.Dispose();
39        //mycon.Close();
40        Response.Write("<script lanuage=javascript>alert('修改成功！');location='javascript:history.go(-1)'</script>");
41    }
42    protected void Button2_Click(object sender, EventArgs e)
43    ...{
44        DataSet ds = null;
45        ds = can.GetDataSet("select * from tb_Intro where id=2", "tb_Intro");
46        //SqlConnection mycon = new SqlConnection("server=(local);user id=sa;PWD=sa;DataBase=db_ComPany");
47        //mycon.Open();
48        //SqlDataAdapter myadapter = new SqlDataAdapter("select * from tb_Intro where id=2", mycon);
49        //DataSet ds = new DataSet();
50        //myadapter.Fill(ds, "tb_Intro");
51        DataRowView rowview = ds.Tables["tb_Intro"].DefaultView[0];
52        this.TextBox1.Text = rowview["intro"].ToString();
53    }
54}
55