网上书店信息管理系统
this.Title = \删?除y记?录?\;
LabelMsg.Text = \单蹋?击?“?确ó?定¨”a将?删?除y当獭?前?记?录?！?\; OleDbConnection conn = new OleDbConnection();
conn.ConnectionString = \ + \Source=\ + Server.MapPath(\);
string SqlStr = \;
OleDbDataAdapter da = new OleDbDataAdapter(SqlStr, conn); DataTable dt = new DataTable(); da.Fill(dt);
GridView1.DataSource = dt; GridView1.DataBind(); conn.Close(); } }
protected void ButtonOK_Click(object sender, EventArgs e) {
OleDbConnection conn = new OleDbConnection(); conn.ConnectionString
=
\ +
\
Source=\
+
Server.MapPath(\);
string SqlStr = \ + DropID.SelectedItem.Text + \; OleDbCommand DelCom = new OleDbCommand(SqlStr, conn); OleDbDataAdapter da = new OleDbDataAdapter(); conn.Open();
da.DeleteCommand = DelCom; da.DeleteCommand.ExecuteNonQuery(); conn.Close();
Response.Write(\language=javascript>alert('记?录?已?成é功|删?除y，?请?单蹋?击?“?返う?回?”a回?到?主?页?面?！?');\); }
protected void DropID_SelectedIndexChanged(object sender, EventArgs e) {
OleDbConnection conn = new OleDbConnection(); conn.ConnectionString =
\
+
\
Source=\
+
Server.MapPath(\);
string SqlStr = \ + DropID.Text + \; OleDbDataAdapter da = new OleDbDataAdapter(SqlStr, conn); DataTable dt = new DataTable(); da.Fill(dt);
GridView1.DataSource = dt; GridView1.DataBind(); conn.Close(); }
protected void ButtonBack_Click(object sender, EventArgs e) {
Response.Redirect(\);
30
web数据库程序设计语言课程设计
} }
Del_mem.aspx.cs: using System;
using System.Collections.Generic; using System.Linq; using System.Web; using System.Web.UI;
using System.Web.UI.WebControls; using System.Data; using System.Data.OleDb;
public partial class del : System.Web.UI.Page {
protected void Page_Load(object sender, EventArgs e) {
if (!IsPostBack) {
this.Title = \删?除y记?录?\;
LabelMsg.Text = \单蹋?击?“?确ó?定¨”a将?删?除y当獭?前?记?录?！?\; OleDbConnection conn = new OleDbConnection();
conn.ConnectionString = \ + \Source=\ + Server.MapPath(\); string SqlStr = \;
OleDbDataAdapter da = new OleDbDataAdapter(SqlStr, conn); DataTable dt = new DataTable(); da.Fill(dt); GridView1.DataSource = dt; GridView1.DataBind(); conn.Close(); } }
protected void ButtonOK_Click(object sender, EventArgs e) {
OleDbConnection conn = new OleDbConnection(); conn.ConnectionString =
\
+
\
Source=\
+
Server.MapPath(\);
string SqlStr = \ + DropID.SelectedItem.Text + \; OleDbCommand DelCom = new OleDbCommand(SqlStr, conn); OleDbDataAdapter da = new OleDbDataAdapter(); conn.Open();
da.DeleteCommand = DelCom;
da.DeleteCommand.ExecuteNonQuery(); conn.Close();
Response.Write(\language=javascript>alert('记?录?已?成é功|删?除y，?请?单蹋?击?“?返う?回?”a回?到?主?页?面?！?');\);
31
网上书店信息管理系统
}
protected void DropID_SelectedIndexChanged(object sender, EventArgs e) {
OleDbConnection conn = new OleDbConnection(); conn.ConnectionString
=
\
+
\
Source=\
+
Server.MapPath(\);
string SqlStr = \ + DropID.Text + \; OleDbDataAdapter da = new OleDbDataAdapter(SqlStr, conn); DataTable dt = new DataTable(); da.Fill(dt);
GridView1.DataSource = dt; GridView1.DataBind(); conn.Close(); }
protected void ButtonBack_Click(object sender, EventArgs e) {
Response.Redirect(\); } }
Enter.aspx.cs: using System;
using System.Collections.Generic; using System.Linq; using System.Web; using System.Web.UI;
using System.Web.UI.WebControls; using System.IO; using System.Data; using System.Data.OleDb;
public partial class _Default : System.Web.UI.Page {
protected void Page_Load(object sender, EventArgs e) {
this.Title = \陕?西?科?技?大洙?学§网?上?书酣?店台?; Label13.Text = (string)(Session[\]); }
protected void ButtonRegister_Click(object sender, EventArgs e) {
Response.Redirect(\); }
protected void ButtonSearch_Click(object sender, EventArgs e) {
if (DropKey.Text == \书酣?名?\)
32
web数据库程序设计语言课程设计
{
OleDbConnection conn = new OleDbConnection();
conn.ConnectionString = \ + \Source=\ + Server.MapPath(\); conn.Open();
string StrSQL = \ + TextKey.Text + \; OleDbCommand com = new OleDbCommand(StrSQL, conn); OleDbDataReader dr = com.ExecuteReader(); dr.Read(); if (dr.HasRows) {
string name = TextKey.Text + \; Response.Redirect(name); conn.Close();
} else {
Response.Write(\您?所e查é找í的?书酣?不?存?在?！?');\);
conn.Close();
} } } }
Finish.aspx.cs: 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;
public partial class Finish : System.Web.UI.Page {
protected void Page_Load(object sender, EventArgs e) {
this.Title = \结á账?\; if (Session[\] == null) {
33
网上书店信息管理系统
Response.Redirect(\); } else {
string BookName = Session[\].ToString(); BookName = BookName.Remove(BookName.Length - 1, 1); string BookNum = Request.QueryString[\];
Response.Write(\你?选?购o的?\ + BookNum + \本?图?书酣?有瓺：阰\ + BookName + \);
float Cost = 15 * int.Parse(BookNum);
Response.Write(\本?站?所e有瓺图?书酣?单蹋?价?均e为a15元a，?你?应畖付?\ + Cost.ToString() + \元a\); } } }
Manage_book.aspx.cs: using System;
using System.Collections.Generic; using System.Linq; using System.Web; using System.Web.UI;
using System.Web.UI.WebControls; using System.Data; using System.Data.OleDb;
public partial class manage1 : System.Web.UI.Page {
protected void Page_Load(object sender, EventArgs e) {
this.Title = \图?书酣?管ò理え?; LinkIns.Text = \插?入?记?录?\; LinkUpdate.Text = \修T改?记?录?\; LinkDel.Text = \删?除y记?录?\;
OleDbConnection conn = new OleDbConnection(); conn.ConnectionString =
\
+
\
Source=\
+
Server.MapPath(\);
string StrSel = \; OleDbDataAdapter da = new OleDbDataAdapter(StrSel, conn); DataTable dt = new DataTable(); da.Fill(dt);
GridView1.DataSource = dt; GridView1.DataBind();
GridView1.Caption = \浏ˉ览え?全?部?记?录?\; GridView1.Width = 350; conn.Close(); }
34