student_course_search.aspx.cs

来自「本套软件适用于各大高校、中小学、幼儿园、培训机构等单位的教学管理软件。」· CS 代码 · 共 74 行

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 jianke;
public partial class Student_course_search: System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
      
    }

    public void Course_choice_searchBind()
    {
        SqlConnection Conn = DB.creatconnection();
        Conn.Open();


        SqlDataAdapter da = new SqlDataAdapter("Select * from VIEW1 where student_sno='" + Session["Users_id"].ToString() + "' and grade='" + this.DropDownList1.SelectedValue + " '", Conn); // 绑定到满足条件的 数据上  ?
        DataSet ds = new DataSet();
        da.Fill(ds);
        dg.DataSource = ds;
        dg.DataBind();
        Conn.Close();
     
    }



 
















    protected void delete(object source, DataGridCommandEventArgs e)
    {
      //  TableRow row = e.Item;
        //    DataGrid row = e.Item;
        SqlConnection Conn = DB.creatconnection();
        Conn.Open();
        String h = "DELETE FROM student_course_choice  where  id='" + dg.DataKeys[e.Item.ItemIndex] + "'and grade='" + this.DropDownList1.SelectedValue + " '";      //dg.DataKeys[e.Item.ItemIndex]
        SqlCommand activecm = new SqlCommand(h, Conn);
        activecm.ExecuteNonQuery();
        Conn.Close();
        Course_choice_searchBind();
    }

    protected void Button1_Click(object sender, EventArgs e)
    {
        Course_choice_searchBind();
    }
}