using?System;
using?System.Data;
using?System.Configuration;
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.OleDb;

///?

///?Class1?的摘要說明
///?

public?class?oledata
{
????#region?全局變量
????///?

????///?創(chuàng)建時間：2008.1.15
????///?創(chuàng)建人：史純武
????///?用來定義全局變量
????///?

????private?OleDbConnection?con;
????private?OleDbCommand?com;
????#endregion

????#region?構(gòu)造函數(shù)
????///?

????///?創(chuàng)建時間：2008.1.15
????///?創(chuàng)建人：史純武
????///?初始化時用來連接數(shù)據(jù)庫
????///?

????public?oledata（）
	{
????????con?=?new?OleDbConnection（ConfigurationManager.AppSettings[“constr“]）;
????????con.Open（）;
????}
????#endregion

????#region?返回oleDataReader類型的數(shù)據(jù)
????///?

????///?創(chuàng)建人：史純武
????///?創(chuàng)建時間：2008.1.15
????///?此方法用于返回SqlDataReader類型的數(shù)據(jù)
????///?

????///?
????///?
????public?OleDbDataReader?executeread（string?olecom）
????{
????????OleDbCommand?com?=?new?OleDbCommand（olecomcon）;
????????OleDbDataReader?dr?=?com.ExecuteReader（）;
????????return?dr;
????}
????#endregion

????#region?執(zhí)行sql語句
????///?

????///?創(chuàng)建時間：2008.1.15
????///?創(chuàng)建人：史純武
????///?此方法用來執(zhí)行sql語句
????///?

????///?
????///?
????public?bool?excutesql（string?strsql）
????{
????????com?=?new?OleDbCommand（strsqlcon）;
????????try
????????{
????????????com.ExecuteNonQuery（）;
????????????return?true;
????????}
????????catch
????????{
????????????return?false;
????????}
????????finally
????????{
????????????con.Close（）;
????????}
????}
????#endregion

????#region?執(zhí)行g(shù)ridview的數(shù)據(jù)邦定
????///?

????///?創(chuàng)建時間：2008.1.15
????///?創(chuàng)建人：史純武
????///?此方法用來邦定數(shù)據(jù)
????///?

????///?
????public?bool?executegridview（GridView?gridviewn?string?strstring?sdk）
????{
????????OleDbDataAdapter?myad?=?new?OleDbDataAdapter（str?con）;
????????DataSet?ds?=?new?DataSet（）;
????????myad.Fill（ds）;
????????gridviewn.DataSource?=?ds;
????????gridviewn.DataKeyNames?=?new?string[]?{?sdk?};
????????try
????????{
????????????gridviewn.DataBind（）;
????????????return?true;
????????}
????????catch
????????{
????????????return?false;
????????}
????????finally
????????{
????????????con.Close（）;
????????}
????}
????#endregion

????#region?執(zhí)行g(shù)ridviewbind數(shù)據(jù)綁定
????public?void?executedatabind（GridView?GridviewN?string?str）
????{
????????OleDbDataAdapter?ole?=?new?OleDbDataAdapter（str?con）;
????????DataSet?ds?=?new?DataSet（）;
????????ole.Fill（ds）;
????????GridviewN.DataSource?=?ds;
????????try
????????{
????????????GridviewN.DataBind（）;
???????????
????????}
????????finally
????????{
????????????con.Close（）;
????????}
????}
????#endregion

????#region?用來填充數(shù)據(jù)集
????public?DataSet?getdataset（string?str?string

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----

?????文件???????3511??2008-02-25?00:19??教育網(wǎng)站后臺管理系統(tǒng)源代碼\App_Code\oledata.cs

?????文件?????434176??2008-03-13?18:43??教育網(wǎng)站后臺管理系統(tǒng)源代碼\App_Data\tb_ysmz.mdb

?????文件???????4142??2008-03-05?09:21??教育網(wǎng)站后臺管理系統(tǒng)源代碼\skin.css

?????文件???????1677??2008-01-11?13:54??教育網(wǎng)站后臺管理系統(tǒng)源代碼\Web.Config

?????文件???????4090??2008-03-08?11:42??教育網(wǎng)站后臺管理系統(tǒng)源代碼\ysmzadmin\article\articleadd.aspx

?????文件???????3921??2008-03-13?18:42??教育網(wǎng)站后臺管理系統(tǒng)源代碼\ysmzadmin\article\articleadd.aspx.cs

?????文件???????3461??2008-03-08?11:42??教育網(wǎng)站后臺管理系統(tǒng)源代碼\ysmzadmin\article\articlemanager.aspx

?????文件???????2433??2008-03-13?18:42??教育網(wǎng)站后臺管理系統(tǒng)源代碼\ysmzadmin\article\articlemanager.aspx.cs

?????文件???????4572??2008-03-08?11:42??教育網(wǎng)站后臺管理系統(tǒng)源代碼\ysmzadmin\article\updatearticle.aspx

?????文件???????7874??2008-03-13?18:42??教育網(wǎng)站后臺管理系統(tǒng)源代碼\ysmzadmin\article\updatearticle.aspx.cs

?????文件???????1488??2008-03-04?16:59??教育網(wǎng)站后臺管理系統(tǒng)源代碼\ysmzadmin\article\userleft.ascx

?????文件????????434??2008-02-27?14:42??教育網(wǎng)站后臺管理系統(tǒng)源代碼\ysmzadmin\article\userleft.ascx.cs

?????文件???????2784??2008-03-08?11:42??教育網(wǎng)站后臺管理系統(tǒng)源代碼\ysmzadmin\baseinfo\baseinfo.aspx

?????文件???????7193??2008-03-10?14:35??教育網(wǎng)站后臺管理系統(tǒng)源代碼\ysmzadmin\baseinfo\baseinfo.aspx.cs

?????文件???????1489??2008-03-04?16:59??教育網(wǎng)站后臺管理系統(tǒng)源代碼\ysmzadmin\baseinfo\userleft.ascx

?????文件????????435??2008-01-12?21:26??教育網(wǎng)站后臺管理系統(tǒng)源代碼\ysmzadmin\baseinfo\userleft.ascx.cs

?????文件???????3293??2008-03-08?11:42??教育網(wǎng)站后臺管理系統(tǒng)源代碼\ysmzadmin\boarder\boarderinfo.aspx

?????文件???????2012??2008-03-13?18:42??教育網(wǎng)站后臺管理系統(tǒng)源代碼\ysmzadmin\boarder\boarderinfo.aspx.cs

?????文件???????2201??2008-03-08?11:42??教育網(wǎng)站后臺管理系統(tǒng)源代碼\ysmzadmin\boarder\boardmanage.aspx

?????文件???????2350??2008-03-13?18:42??教育網(wǎng)站后臺管理系統(tǒng)源代碼\ysmzadmin\boarder\boardmanage.aspx.cs

?????文件???????2216??2008-03-08?11:42??教育網(wǎng)站后臺管理系統(tǒng)源代碼\ysmzadmin\boarder\updateboardmanage.aspx

?????文件???????2829??2008-03-13?18:42??教育網(wǎng)站后臺管理系統(tǒng)源代碼\ysmzadmin\boarder\updateboardmanage.aspx.cs

?????文件???????1488??2008-02-27?18:56??教育網(wǎng)站后臺管理系統(tǒng)源代碼\ysmzadmin\boarder\userleft.ascx

?????文件????????434??2008-02-27?14:45??教育網(wǎng)站后臺管理系統(tǒng)源代碼\ysmzadmin\boarder\userleft.ascx.cs

?????文件???????3912??2008-03-08?11:42??教育網(wǎng)站后臺管理系統(tǒng)源代碼\ysmzadmin\classmanager\addclass.aspx

?????文件???????2268??2008-03-13?18:42??教育網(wǎng)站后臺管理系統(tǒng)源代碼\ysmzadmin\classmanager\addclass.aspx.cs

?????文件???????3279??2008-03-08?11:42??教育網(wǎng)站后臺管理系統(tǒng)源代碼\ysmzadmin\classmanager\classmanager.aspx

?????文件???????2591??2008-03-13?18:42??教育網(wǎng)站后臺管理系統(tǒng)源代碼\ysmzadmin\classmanager\classmanager.aspx.cs

?????文件???????4013??2008-03-08?11:42??教育網(wǎng)站后臺管理系統(tǒng)源代碼\ysmzadmin\classmanager\updateclass.aspx

?????文件???????2890??2008-03-13?18:42??教育網(wǎng)站后臺管理系統(tǒng)源代碼\ysmzadmin\classmanager\updateclass.aspx.cs

............此處省略51個文件信息