资料

  static public DataTable GetDataTable(string strSQL)  
  {
   SqlConnection conn = GetConnection();
   DataTable dt = new DataTable();

   using(SqlDataAdapter da = new SqlDataAdapter(strSQL,conn))
   {
    try
    {
     da.FillSchema(dt,SchemaType.Mapped);
     da.Fill(dt);
    }
    catch (SqlException err)
    {
     
     ErrLog.WriteErrLog("数据库数据提取不成功！");
     ErrLog.WriteErrLog(err.Message);
     ErrLog.WriteErrLog("SQL语句为： " + strSQL);
    }
    catch (Exception err)
    {
     
     ErrLog.WriteErrLog("数据库数据提取不成功！");
     ErrLog.WriteErrLog("SQL语句为： " + strSQL + "错误信息=" + err.Message);
    }
    finally
    {
     conn.Close();
     conn.Dispose();
    }
   }
   return dt;
  }

==================================

    public DataTable GetStudentList(string StudentName)
    {
        string strSQL = "SELECT * FROM Experiment_Student WHERE StudentName Like '%" + StudentName + "%'";
        return CMMgr.GetDataTable(strSQL);
    }

====================================

    protected void btnFind_Click(object sender, EventArgs e)
    {
        this.initForm();
    }

=======================

 private void initForm()
    {
        StudentMgr mgr = new StudentMgr();
        this.dgList.DataSource = mgr.GetStudentList(this.txtCaption.Text);
        this.dgList.DataBind();
    }

========================

以上搜索

======================

以下删除

====================

    protected void dgList_RowDeleting(object sender, GridViewDeleteEventArgs e)
    {
        GridViewRow row = this.dgList.Rows[e.RowIndex];
        StudentMgr mgr = new StudentMgr();
        mgr.DelStudent(row.Cells[0].Text);
        this.initForm();
    }

==========================

#region　函数DelStudent | 删除Student信息
 /// <summary>
 /// 删除Student类信息
 /// </summary>
 /// <param name="StudentID">学号参数</param>
 public void DelStudent(string StudentID)
 {
  string strSQL = "DELETE FROM Experiment_Student WHERE StudentID = " + StudentID;
  CMMgr.ExecuteNonQuery(strSQL);
 }

 /// <summary>
 /// 删除Student类信息
 /// </summary>
 /// <param name="StudentID">学号</param>
 public void DelStudent(int StudentID)
 {
  this.DelStudent(StudentID.ToString());
 }

 /// <summary>
 /// 删除Student类信息
 /// </summary>
 /// <param name="student">Student类</param>
 public void DelStudent(Student student)
 {
  this.DelStudent(student.StudentID);
 }
 #endregion

 

=========================

   protected void Page_Load(object sender, EventArgs e)
    {
        this.ValidateAdmin();
        if (!this.IsPostBack)
        {
            this.initForm();
        }
    }

string strSqlSearch = @"select LOGONID,USERNAME,GROUPNAME from [USER] right join [GROUPUSER]
        on [USER].USERID=[GROUPUSER].USERID left join [GROUP] on [GROUP].GROUPID=[GROUPUSER].GROUPID where GROUPNAME='"+ddlSearch.SelectedValue+"'";