学步园

default.aspx.cs

using System;<br /> using System.Collections;<br /> using System.Configuration;<br /> using System.Data;<br /> using System.Linq;<br /> using System.Web;<br /> using System.Web.Security;<br /> using System.Web.UI;<br /> using System.Web.UI.HtmlControls;<br /> using System.Web.UI.WebControls;<br /> using System.Web.UI.WebControls.WebParts;<br /> using System.Xml.Linq;</p> <p>using System.Data.SqlClient;<br /> using System.Data.OleDb;<br /> using System.IO;</p> <p>namespace Web0531<br /> {<br /> public partial class _Default : System.Web.UI.Page<br /> {<br /> protected void Page_Load(object sender, EventArgs e)<br /> {<br /> if (!IsPostBack)<br /> {<br /> db.dataBind(ListView1, "select * from exam order by id");<br /> try<br /> {<br /> int PageSize = (int)Session["PageSize"]; // 保证从修改页面能返回到原来的页面<br /> int StartRowIndex = (int)Session["StartRowIndex"];<br /> ((DataPager)ListView1.FindControl("DataPager1")).SetPageProperties(StartRowIndex, PageSize, true);<br /> }<br /> catch { }<br /> }<br /> }</p> <p> // 数据项绑定后，将正确答案的选项“蓝色、加粗”显示<br /> protected void ListView1_ItemDataBound(object sender, ListViewItemEventArgs e)<br /> {<br /> try<br /> {<br /> Label lb = (Label)e.Item.FindControl("answerLabel"); // 取答案<br /> string ans = lb.Text.Trim() + "Label"; // 如果答案是a;b;c;d其中之一<br /> Label lbans = (Label)e.Item.FindControl(ans); // 没有答案时会出错<br /> lbans.CssClass = "bb"; // 设置答案选项的样式<br /> }<br /> catch { }<br /> }</p> <p> // 翻页时执行<br /> protected void ListView1_PagePropertiesChanged(object sender, EventArgs e)<br /> {<br /> int PageSize = ((DataPager)ListView1.FindControl("DataPager1")).PageSize; // 每页记录数<br /> int StartRowIndex = ((DataPager)ListView1.FindControl("DataPager1")).StartRowIndex; // 首行的索引值<br /> int TotalRowCount = ((DataPager)ListView1.FindControl("DataPager1")).TotalRowCount; // 总记录数</p> <p> //Response.Write("PageSize = " + PageSize.ToString() + " ; StartRowIndex = " + StartRowIndex.ToString() + " ; TotalRowcount = " + TotalRowCount.ToString() + ";");<br /> ((DataPager)ListView1.FindControl("DataPager1")).SetPageProperties(StartRowIndex, PageSize, false);<br /> db.dataBind(ListView1, "select * from exam order by id"); // 重新绑定数据<br /> Session["StartRowIndex"] = StartRowIndex; // 记录信息到 Session，用于从修改页面返回时能回到原来的页面<br /> Session["PageSize"] = PageSize;<br /> }</p> <p> // 删除记录<br /> protected void ListView1_ItemDeleting(object sender, ListViewDeleteEventArgs e)<br /> {<br /> string id = ((Label)ListView1.Items[e.ItemIndex].FindControl("idLabel")).Text; // 要删记录的 id 号<br /> OleDbConnection cn = db.AccessConnection();<br /> cn.Open();<br /> OleDbCommand cmd = new OleDbCommand("delete from exam where id=" + id, cn);<br /> cmd.ExecuteNonQuery();<br /> cn.Close();<br /> cmd.Dispose();</p> <p> int PageSize = ((DataPager)ListView1.FindControl("DataPager1")).PageSize; // 若删除的是最后页面中的记录，可能需要调整<br /> int StartRowIndex = ((DataPager)ListView1.FindControl("DataPager1")).StartRowIndex;<br /> int TotalRowCount = ((DataPager)ListView1.FindControl("DataPager1")).TotalRowCount;<br /> if (TotalRowCount < 3) // 若记录要删除完，回复原来的所有记录<br /> {<br /> File.Copy(Server.MapPath("App_Data/peixun.bak"), Server.MapPath("App_Data/peixun.mdb"), true);<br /> }<br /> else<br /> {<br /> if (StartRowIndex == TotalRowCount - 1) // 若最后页的记录删完<br /> {<br /> StartRowIndex -= PageSize; // 要切回到原最后页的前一页，DataPager本身不会处理<br /> ((DataPager)ListView1.FindControl("DataPager1")).SetPageProperties(StartRowIndex, PageSize, false);<br /> Session["StartRowIndex"] = StartRowIndex;<br /> Session["PageSize"] = PageSize;<br /> }<br /> }<br /> db.dataBind(ListView1, "select * from exam order by id"); // 重新绑定数据<br /> }<br /> }<br /> }<br />

modify.aspx.cs

using System;<br /> using System.Collections;<br /> using System.Configuration;<br /> using System.Data;<br /> using System.Linq;<br /> using System.Web;<br /> using System.Web.Security;<br /> using System.Web.UI;<br /> using System.Web.UI.HtmlControls;<br /> using System.Web.UI.WebControls;<br /> using System.Web.UI.WebControls.WebParts;<br /> using System.Xml.Linq;</p> <p>using System.Data.OleDb;</p> <p>namespace Web0531<br /> {<br /> public partial class modify : System.Web.UI.Page<br /> {<br /> protected void Page_Load(object sender, EventArgs e)<br /> {<br /> if (!IsPostBack)<br /> {<br /> string urlId = Request.QueryString["id"]; // 要修改记录的 id 号<br /> //if (string.IsNullOrEmpty(urlId)) urlId = "4"; // 测试用<br /> OleDbConnection conn = db.AccessConnection();<br /> conn.Open();<br /> OleDbCommand cmd = new OleDbCommand("select * from exam where id=" + urlId, conn);<br /> OleDbDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection);<br /> if (dr.Read())<br /> {<br /> id.Value = dr["id"].ToString(); // 把原来的题目信息显示出来<br /> tm.Text = dr["question"].ToString();<br /> a.Text = dr["a"].ToString();<br /> b.Text = dr["b"].ToString();<br /> c.Text = dr["c"].ToString();<br /> d.Text = dr["d"].ToString();<br /> int i = dr["answer"].ToString()[0] - 'A'; // 仅处理单选<br /> if(i>=0 && i<=3) da.Items[i].Selected = true;<br /> }<br /> conn.Close();<br /> dr.Close();<br /> }<br /> }</p> <p> // 更新记录<br /> protected void Button1_Click(object sender, EventArgs e)<br /> {<br /> string rda = null;<br /> for (int i = 0; i < da.Items.Count; ++i)<br /> {<br /> if (da.Items[i].Selected)<br /> {<br /> rda = Convert.ToString((char)('A' + i)); // 答案，仅处理单选<br /> break;<br /> }<br /> }<br /> if (string.IsNullOrEmpty(rda)) rda = " ";<br /> string sql = "update exam set question='" + tm.Text.Replace("'", "''") + "',a='" + a.Text.Replace("'", "''") + "',b='" + b.Text.Replace("'", "''") + "',c='" + c.Text.Replace("'", "''") + "',d='" + d.Text.Replace("'", "''") + "',answer='" + rda + "' where id=" + id.Value;</p> <p> OleDbConnection conn = db.AccessConnection();<br /> conn.Open();<br /> OleDbCommand cmd = new OleDbCommand(sql, conn);<br /> cmd.ExecuteNonQuery(); // 执行更新<br /> conn.Close();<br /> Response.Redirect("default.aspx"); // 返回到原来的页面<br /> }<br /> }<br /> }<br />

new.aspx.cs

using System;<br /> using System.Collections;<br /> using System.Configuration;<br /> using System.Data;<br /> using System.Linq;<br /> using System.Web;<br /> using System.Web.Security;<br /> using System.Web.UI;<br /> using System.Web.UI.HtmlControls;<br /> using System.Web.UI.WebControls;<br /> using System.Web.UI.WebControls.WebParts;<br /> using System.Xml.Linq;</p> <p>using System.Data.OleDb;</p> <p>namespace Web0531<br /> {<br /> public partial class _new : System.Web.UI.Page // 插入新的考试题目<br /> {<br /> // 插入新记录<br /> protected void Button1_Click(object sender, EventArgs e)<br /> {<br /> string rda = null;<br /> for (int i = 0; i < da.Items.Count; ++i) // 选择的答案<br /> {<br /> if (da.Items[i].Selected)<br /> {<br /> rda = Convert.ToString((char)('A' + i)); // 转换成字符串<br /> break; // 仅考虑单选<br /> }<br /> }<br /> if (string.IsNullOrEmpty(rda)) rda = " ";<br /> string sql = "insert into exam(question,a,b,c,d,answer) values ('" + tm.Text.Replace("'", "''") + "','" + a.Text.Replace("'", "''") + "','" + b.Text.Replace("'", "''") + "','" + c.Text.Replace("'", "''") + "','" + d.Text.Replace("'", "''") + "','" + rda + "')";</p> <p> OleDbConnection conn = db.AccessConnection();<br /> conn.Open();<br /> OleDbCommand cmd = new OleDbCommand(sql, conn); // 插入到数据库<br /> cmd.ExecuteNonQuery();<br /> conn.Close();<br /> Response.Redirect("default.aspx"); // 返回到原来所在的页面，要看刚插入的题目，可单击“最后一页”按钮<br /> }<br /> }<br /> }<br />

完整项目下载：

http://download.csdn.net/source/2417259