t + "
"; Label1.Text += "
您的专业:" + zy.Text + "
"; Label1.Text += "
您的年级:" + nj.Text.Replace("\n", "
"); cc4.close(); } protected void xh_TextChanged(object sender, EventArgs e) { } }
二、class2
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; namespace mydb2 { ///
/// Class2 的摘要说明 /// public class Class2 : Page { protected OleDbConnection conn; protected OleDbCommand cmd; protected OleDbDataReader dr; protected string connString;
public Class2() { connString = @"Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" + Server.MapPath("../App_Data\\mydb.mdb"); } public void databind(GridView myGrid, string sql)//GridView的数据绑定 { OleDbConnection con = new OleDbConnection(connString);//创建连接对象 OleDbDataAdapter adp = new OleDbDataAdapter(sql, con);//DA从数据库con读取数据 DataSet ds = new DataSet();//内存中数据库DS adp.Fill(ds);//DA将con读取的数据传到Ds中 myGrid.DataSource = ds.Tables[0].DefaultView;//把ds.table【0】的数据都显示到 GridView //GridView1.DataMember = "userinf"; myGrid.DataBind(); con.Close(); } } }
三、删除页面跳转
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.OleDb; using mydb; public partial class manager_deletejump : System.Web.UI.Page { protected void Page_Load(object sender, EventArgs e) { if (Session["Manager"] == null) Response.Redirect("managerlogin_now.aspx"); else { string idd = Request.QueryString["idd"]; Class1 a = new Class1();
string sql = "delete from news where [ID]=" + idd; a.dboperation(sql); a.close(); Response.Write("
"); } } }
四、密码修改
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.OleDb; using
mydb; public partial class manager_change_passwordm : System.Web.UI.Page { protected void Page_Load(object sender, EventArgs e) { if ( Session["Manager"] == null) Response.Write("
"); } protected void Submit1_ServerClick(object sender, EventArgs e) { // String userID= xh.Text; if (y.Text.Equals(Session["userpass"].ToString())) { String userPass = qd.Text; String sql = "update Manage set [pass
word]= '" + userPass + " ' + /*userID*/Session["Manager"].ToString() + " ' "; Class1 cc4 = new Class1(); cc4.dboperation(sql); Label1.Text += "
修改 密码成功"; cc4.close(); } where account='"
else { Label1.Text += "
密码 修改失败,可能是原密码有误,请重试..."; } } }
五,
课程处理
using Sy