我是程序编写的初学者，老师上课写的代码都不知道什么意思，希望电脑高手们帮忙了，谢谢了！

Question

using System.Data.OleDb;

namespace vote
{
public partial class _Default : System.Web.UI.Page
{
int totalPs;
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
OleDbConnection conn = new OleDbConnection(@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=F:\Vs.Net2008\vote\vote\App_Data\db.mdb");
OleDbCommand cmd = new OleDbCommand();
conn.Open();
cmd.Connection = conn;
cmd.CommandText = "select top 1 * from votes ";
OleDbDataReader dr = cmd.ExecuteReader();
if (dr.Read())
{

lblVoteTitle.Text = dr["voteItem"].ToString();
string id = dr["id"].ToString();
lblTitleId.Text = id;
cmd.CommandText = "select * from votes where pid=" + id;
dr.Close();
dr = cmd.ExecuteReader();
while (dr.Read())
{
ListItem li = new ListItem(dr["voteItem"].ToString(), dr["id"].ToString());
chkVoteItem.Items.Add(li);
}
}
dr.Close();
conn.Close();
}
}

protected void btnVote_Click(object sender, EventArgs e)
{
OleDbConnection conn = new OleDbConnection(@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=F:\Vs.Net2008\vote\vote\App_Data\db.mdb");
OleDbCommand cmd = new OleDbCommand();
conn.Open();
cmd.Connection = conn;
for (int i = 0; i < chkVoteItem.Items.Count; ++i)
{
if (chkVoteItem.Items[i].Selected)
{
cmd.CommandText = "update votes set voteCount=voteCount+1 where id=" + chkVoteItem.Items[i].Value;
cmd.ExecuteNonQuery();
}
}
cmd.CommandText = "select sum(voteCount) from votes where pid=" + lblTitleId.Text;
totalPs = int.Parse(cmd.ExecuteScalar().ToString());
cmd.CommandText = "select * from votes where pid=" + lblTitleId.Text;
OleDbDataReader dr = cmd.ExecuteReader();
Repeater1.DataSource = dr;
Repeater1.DataBind();
dr.Close();
conn.Close();
}

protected void Repeater1_ItemDataBound(object sender, RepeaterItemEventArgs e)
{
try
{
double ps = int.Parse(((Label)e.Item.FindControl("Label3")).Text);
((Label)e.Item.FindControl("Label2")).Width = Unit.Percentage(ps * 100.0 / totalPs);
((Label)e.Item.FindControl("Label3")).Text += string.Format("<font color=blue> ({0:P})</font>", ps / totalPs);
}
catch { }
}
}
}

Answer 1

Asp.Net方面的知识，自己按照案例做，很容易就学会啦

using System.Data.OleDb;
//程序大致是网页中链接Access数据库的案例
namespace vote
{
public partial class _Default : System.Web.UI.Page
{
int totalPs;
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
//微软提供的oracle 数据库连接对象 OleDbConnection ，类似于sqlserver 的 SQLConnnection
//建立新的Access数据连接
OleDbConnection conn = new OleDbConnection(@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=F:\Vs.Net2008\vote\vote\App_Data\db.mdb");
OleDbCommand cmd = new OleDbCommand();
conn.Open();
cmd.Connection = conn;
cmd.CommandText = "select top 1 * from votes ";
//链接打开，发送sql语句

//处理数据库返回信息
OleDbDataReader dr = cmd.ExecuteReader();
if (dr.Read())
{

lblVoteTitle.Text = dr["voteItem"].ToString();
string id = dr["id"].ToString();
lblTitleId.Text = id;
cmd.CommandText = "select * from votes where pid=" + id;
dr.Close();
dr = cmd.ExecuteReader();
while (dr.Read())
{
ListItem li = new ListItem(dr["voteItem"].ToString(), dr["id"].ToString());
chkVoteItem.Items.Add(li);
}
}
dr.Close();
conn.Close();
//关闭链接
}
}

//估计是一个投票系统，点击投票后为指定的候选人添加选票数
protected void btnVote_Click(object sender, EventArgs e)
{
OleDbConnection conn = new OleDbConnection(@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=F:\Vs.Net2008\vote\vote\App_Data\db.mdb");
OleDbCommand cmd = new OleDbCommand();
conn.Open();
cmd.Connection = conn;
for (int i = 0; i < chkVoteItem.Items.Count; ++i)
{
if (chkVoteItem.Items[i].Selected)
{
//更新数据库选票信息
cmd.CommandText = "update votes set voteCount=voteCount+1 where id=" + chkVoteItem.Items[i].Value;
cmd.ExecuteNonQuery();
}
}
//显示已有票信息
cmd.CommandText = "select sum(voteCount) from votes where pid=" + lblTitleId.Text;
totalPs = int.Parse(cmd.ExecuteScalar().ToString());
cmd.CommandText = "select * from votes where pid=" + lblTitleId.Text;
OleDbDataReader dr = cmd.ExecuteReader();
Repeater1.DataSource = dr;
Repeater1.DataBind();
dr.Close();
conn.Close();
}

protected void Repeater1_ItemDataBound(object sender, RepeaterItemEventArgs e)
{
try
{
double ps = int.Parse(((Label)e.Item.FindControl("Label3")).Text);
((Label)e.Item.FindControl("Label2")).Width = Unit.Percentage(ps * 100.0 / totalPs);
((Label)e.Item.FindControl("Label3")).Text += string.Format("<font color=blue> ({0:P})</font>", ps / totalPs);
}
catch { }
}
}
}