当前文件： AthletesFile/update.aspx.cs[4K，2009-6-12 11:32:51]，打开代码结构图

		            
  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 inup : System.Web.UI.Page
 14...{
 15    SqlConnection conn;
 16    
 17    protected void Page_Load(object sender, EventArgs e)
 18    ...{
 19
 20    }
 21    protected void ImageButton1_Click(object sender, ImageClickEventArgs e)
 22    ...{
 23        conn = new SqlConnection("Data Source=.\\Sql2005;Database=sport;Integrated Security=SSPI");
 24        string type = DropDownList4.SelectedValue;
 25        string key = TextBox1.Text;
 26        string select = "";
 27        if (type == "athlete")
 28        ...{
 29            Panel1.Visible = false;
 30            Panel2.Visible = true;
 31            select = "select * from athlete where A_no='" + key + "'";
 32            Data_sele(select);
 33        }
 34        else if (type == "team")
 35        ...{
 36            Panel1.Visible = true;
 37            Panel2.Visible = false;
 38            select = "select * from delegate where D_no='" + key + "'";
 39            Data_sele1(select);
 40        }
 41        else ...{ Response.Write("<script language='javascript'>alert('您的操作有误，请重新操作')<script>"); }
 42
 43
 44       
 45    }
 46    protected void Data_sele(string sele)
 47    ...{
 48        conn.Open();
 49        SqlCommand comm = new SqlCommand(sele, conn);
 50        SqlDataReader dr = comm.ExecuteReader();
 51        while (dr.Read())
 52        ...{
 53            no.Text = dr.GetString(0);
 54            DropDownList2.SelectedValue = dr.GetString(1);
 55            DropDownList3.SelectedValue = dr.GetString(1);
 56            TextBox3.Text = dr.GetString(2);
 57            sex.SelectedValue = dr.GetString(3);
 58            age.Text = dr.GetInt32(4).ToString();
 59            height.Text = dr.GetInt32(5).ToString();
 60            width.Text = dr.GetInt32(6).ToString();
 61            DropDownList1.SelectedValue = dr.GetString(7);
 62            TextBox2.Text = dr.GetString(8);
 63            remark.Text = dr.GetString(9);
 64            Image1.ImageUrl =dr.GetString(10).ToString();
 65
 66        }
 67        conn.Close();
 68    }
 69    protected void Data_sele1(string sele)
 70    ...{
 71        conn.Open();
 72        SqlCommand comm = new SqlCommand(sele, conn);
 73        SqlDataReader dr = comm.ExecuteReader();
 74        while (dr.Read())
 75        ...{
 76            D_no1.Text = dr.GetString(0);
 77            name1.Text = dr.GetString(1);
 78            place.Text = dr.GetString(2);
 79            management.Text = dr.GetString(3);
 80            count.Text = dr.GetInt32(4).ToString();
 81            detail.Text = dr.GetString(5);
 82        }
 83        conn.Close();
 84    }
 85    protected void ImageButton2_Click(object sender, ImageClickEventArgs e)
 86    ...{
 87        string type = DropDownList4.SelectedValue;
 88        if (type == "athlete")
 89        ...{
 90            try       
 91            ...{
 92               int a = sqlds.Update();
 93               if (a != 0)
 94               ...{
 95                   Response.Write("<script language='javascript'>alert('更新数据成功')</script>");
 96               }
 97           }
 98           catch (Exception exce)
 99           ...{
100               Response.Write(exce.Message.ToString());
101               Response.Write("<script language='javascript'>alert('更新数据失败')</script>");
102               DropDownList4.SelectedValue = "null";
103               TextBox1.Text = "";
104           }
105        }
106        else if (type == "team")
107        ...{
108            try
109            ...{
110                int a = SQLDS2.Update();
111                if (a != 0)
112                ...{
113                    Response.Write("<script language='javascript'>alert('更新数据成功')</script>");
114                }
115            }
116            catch (Exception exce)
117            ...{
118                Response.Write(exce.Message.ToString());
119                Response.Write("<script language='javascript'>alert('更新数据失败')</script>");
120                DropDownList4.SelectedValue = "null";
121                TextBox1.Text = "";
122            }
123        }
124        else
125        ...{ Response.Write("<script language='javascript'>alert('您的操作有误，请重试')</script>"); }
126
127    }
128}
129