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_Hyperlink_UpdateHyperlink : 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_hyperlink where ID=" + Request["ID"], "tb_hyperlink");
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_hyperlink where ID=" + Request["ID"], myconnection);
25            //DataSet ds = new DataSet();
26            //mydataadapter.Fill(ds, "tb_hyperlink");
27            DataRowView rowview = ds.Tables["tb_hyperlink"].DefaultView[0];
28            txthyperlinkname.Text = Convert.ToString(rowview["Name"]);
29            txthyperlinkAddress.Text = Convert.ToString(rowview["Address"]);
30        }
31    }
32    protected void btnupdate_Click(object sender, EventArgs e)
33    ...{
34        can.ExecSqlCom("update tb_hyperlink set Name='" + this.txthyperlinkname.Text + "',Address='" + txthyperlinkAddress.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_hyperlink set Name='" + this.txthyperlinkname.Text + "',Address='" + txthyperlinkAddress.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='Hyperlink.aspx'</script>"); 
43    }
44}
45