editscore.aspx.cs

程序学生信息管理系统(SQL2000+ASP.NET+c#+)

using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;
using SMS;

public partial class Default2 : System.Web.UI.Page
{
    OPDataBase op = new OPDataBase();
    static string sql = "select *from Score2";
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            sql = "select *from Score2";
            op.BinData(sql, GridView1);
            GridView1.DataKeyNames = new string[] { "StudentID" };
        
            //for (int i = 0; i < GridView1.Rows.Count; i++)
            //{
            //    ImageButton Imgselect = (ImageButton)GridView1.Rows[i].FindControl("ImageButton7");

            //    Imgselect.Attributes.Add("onclick", "javascript:return confirm('你确认要删除吗?')");


            //} 
          
        
        }
        if ((int)Session["Power"] != 0)
        {
            GridView1.Columns[8].Visible = false;
            GridView1.Columns[9].Visible = false;
        }
        GridView1.Attributes.Add("style", "table-layout:fixed");
        GridView1.Attributes.Add("style", "word-break:keep-all;word-wrap:normal");
    
    }
    public void Bin()
    {

      
        op.BinData(sql, GridView1);
        GridView1.DataKeyNames = new string[] { "StudentID"};
    
    }

    protected void GridView1_PageIndexChanging(object sender, GridViewPageEventArgs e)
    {
        try
        {

            GridView1.PageIndex = e.NewPageIndex;
            Bin();
        }
        catch {
        
            }
    }
    protected void GridView1_RowEditing(object sender, GridViewEditEventArgs e)
    {
        GridView1.EditIndex = e.NewEditIndex ;
        Bin();
    }
    protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
    {
        string sqlstr = "update Score2  set 计算机网络='" +
          ((TextBox)(GridView1.Rows[e.RowIndex].Cells[2].Controls[0])).Text.ToString().Trim() + "',[ASP.NET]='" +
          ((TextBox)(GridView1.Rows[e.RowIndex].Cells[3].Controls[0])).Text.ToString().Trim() + "',计算机应用='" +
          ((TextBox)(GridView1.Rows[e.RowIndex].Cells[4].Controls[0])).Text.ToString().Trim() + "',[Ado.net]='" +
          ((TextBox)(GridView1.Rows[e.RowIndex].Cells[5].Controls[0])).Text.ToString().Trim() + "',网页设计='" +
          ((TextBox)(GridView1.Rows[e.RowIndex].Cells[6].Controls[0])).Text.ToString().Trim() + "',Windows应用设计='" +
          ((TextBox)(GridView1.Rows[e.RowIndex].Cells[7].Controls[0])).Text.ToString().Trim() + "' where StudentID='" +
          GridView1.DataKeys[e.RowIndex].Value.ToString() +"'";
        SqlConnection conn = op.sqlConnection();
        conn.Open();
        SqlCommand cmd = new SqlCommand(sqlstr, conn);
        try
        {

            cmd.ExecuteNonQuery();
            
            //op.BindCommand(sql);
        }
        catch ( SqlException es)
        {
            Label2.Text = es.Message.ToString();
        }
        GridView1.EditIndex = -1;
        Bin();
    }
 
    protected void GridView1_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e)
    {
        GridView1.EditIndex = -1;
        Bin();
    }
   


    protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
    {
        string sqlstr = "delete from Score2 where StudentID='" + GridView1.DataKeys[e.RowIndex].Value.ToString() +"'";
        op.BindCommand(sqlstr);
        Bin();
    }
    protected void ImageButton5_Click(object sender, ImageClickEventArgs e)
    {
        try
        {
            if(TextBox1.Text != "" || TextBox2.Text != "")
            {
                sql = "select * from Score2 where " + DropDownList1.SelectedValue.ToString().Trim() + "='" + TextBox1.Text.Trim() + "'OR " +
                    DropDownList2.SelectedValue.ToString() + "<='" + TextBox2.Text.Trim() + "'OR " + DropDownList1.SelectedValue.ToString().Trim() + "='" + TextBox1.Text.Trim() + "'AND " +
                    DropDownList2.SelectedValue.ToString() + "<='" + TextBox2.Text.Trim() + "'";
                op.BinData(sql, GridView1);
                TextBox1.Text = "";
                if(GridView1.Rows.Count < 1)
                {
                    Label2.Text = "*没有数据,请从新输入！*";
                }
                else
                {
                    Label2.Text = "";
                }


            }
            else
            {
                sql = "select * from Score2";
                Bin();
                Label2.Text = "*请输入字符后再查询！*";



            }
        }
        catch
        {
            sql = "select * from Score2";
            Label2.Text = "*你输入的字符类型不匹配！*";

        }
       

    }
    protected void ImageButton6_Click(object sender, ImageClickEventArgs e)
    {
        sql = "select *from Score2";
        TextBox1.Text = "";
        Label2.Text = "";
        Bin();
    }

    protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
    {
        if (e.Row.RowType == DataControlRowType.DataRow )
        {
            //鼠标经过时，行背景色变 
           e.Row.Attributes.Add("onmouseover", "this.style.backgroundColor='#E6F5FA'");
            //鼠标移出时，行背景色变 
         e.Row.Attributes.Add("onmouseout", "this.style.backgroundColor='#FFFFFF'");
            //((ImageButton)(e.Row.Cells[9].Controls[0])).Attributes.Add("onclick", "return confirm('你确认要删除吗?')");
            //如果是绑定数据行 //清清月儿http://blog.csdn.net/21aspnet 
        }
      
      
    }
   
}