当前文件： AthletesFile/matchrecord.aspx.cs[3K，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.Sql;
 12using System.Data.SqlClient;
 13
 14
 15public partial class xxx : System.Web.UI.Page
 16...{
 17    protected void Page_Load(object sender, EventArgs e)
 18    ...{
 19
 20    }
 21    protected void LinkButton3_Click(object sender, EventArgs e)
 22    ...{
 23        Panel2.Visible = false;
 24        Panel3.Visible = true;
 25        Panel4.Visible = false;
 26    }
 27    protected void LinkButton4_Click(object sender, EventArgs e)
 28    ...{
 29        Panel2.Visible = false;
 30        Panel3.Visible = false ;
 31        Panel4.Visible = true;
 32    }
 33    protected void LinkButton2_Click(object sender, EventArgs e)
 34    ...{
 35        Panel2.Visible = true ;
 36        Panel3.Visible = false;
 37        Panel4.Visible = false ;
 38    }
 39  
 40    protected void TextBox9_TextChanged(object sender, EventArgs e)
 41    ...{
 42
 43    }
 44    protected void Button1_Click1(object sender, EventArgs e)
 45    ...{
 46      
 47       
 48        
 49        int b = SqlDataSource3.Update();
 50        if (b==0)
 51            Response.Write("<script language='javascript'>alert('对不起更新失败!')</script>");
 52        else Response.Write("<script language='javascript'>alert(' 更新成功!')</script>");
 53    }
 54
 55  
 56   
 57    protected void Button3_Click(object sender, EventArgs e)
 58    ...{
 59        
 60       int a= SqlDataSource2.Insert();
 61       
 62           if (a==0)
 63               　 Response.Write("<script language='javascript'>alert('对不起插入失败!')</script>");
 64           else 　Response.Write("<script language='javascript'>alert(' 插入成功!')</script>");
 65     
 66    }
 67
 68    protected void Button1_Click(object sender, EventArgs e)
 69    ...{
 70      SqlDataSource4.Select(DataSourceSelectArguments.Empty);
 71       
 72        GridView1.Visible = true;
 73
 74    }
 75    protected void SqlDataSource3_Selecting(object sender, SqlDataSourceSelectingEventArgs e)
 76    ...{
 77
 78    }
 79    protected void Button7_Click(object sender, EventArgs e)
 80    ...{
 81        SqlConnection conn = new SqlConnection();
 82        conn.ConnectionString = "Data Source=.\\Sql2005;Database=shi;Integrated Security=SSPI";
 83        conn.Open();
 84        String Sp_num = TextBox10.Text;
 85           SqlCommand com = new SqlCommand("select * from Jilu where Sp_num='" + Sp_num + "'",conn);
 86        SqlDataReader dr = com.ExecuteReader();         
 87            while (dr.Read())
 88            ...{   
 89                TextBox8.Text = dr.GetString(0);
 90                TextBox2.Text = dr.GetString(1);
 91                TextBox1.Text = dr.GetString(2);
 92                RadioButtonList3.Text = dr.GetString(3);
 93                TextBox6.Text = dr.GetSqlDateTime(4).ToString();
 94                TextBox5.Text = dr.GetString(5);
 95                RadioButtonList4.Text = dr.GetBoolean(6).ToString();
 96                TextBox7.Text = dr.GetString(7);
 97            }
 98        　　
 99            conn.Close();
100       
101    }
102    protected void Button6_Click(object sender, EventArgs e)
103    ...{
104        Panel4.Visible = false;
105        GridView1.Visible = false;
106    }
107    protected void Button4_Click(object sender, EventArgs e)
108    ...{
109        Panel3.Visible = false;
110    }
111    protected void Button2_Click(object sender, EventArgs e)
112    ...{
113        Panel2.Visible = false;
114    }
115}
116