using System;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using System.Data.OleDb;

public partial class Ex5_2 : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
      if (!IsPostBack)
      {
        string acon = System.Configuration.ConfigurationManager.AppSettings["strcon"].ToString();
        OleDbConnection oconn = new OleDbConnection(acon);
        OleDbDataAdapter oda = new OleDbDataAdapter("select * from vote", oconn);
        DataSet ds = new DataSet();
        oda.Fill(ds);
        rblvote.DataSource = ds;
        rblvote.DataTextField = "vname";
        rblvote.DataValueField = "vid";
        rblvote.DataBind();
      }
    }
    protected void Button1_Click(object sender, EventArgs e)
    {
      lblmes.Text ="你选择的是："+rblvote.SelectedItem.Text;
      string acon = System.Configuration.ConfigurationManager.AppSettings["strcon"].ToString();
      OleDbConnection oconn = new OleDbConnection(acon);
      oconn.Open();
      string sql0="update vote set vnum=vnum+1 where vid=" + rblvote.SelectedValue;
      OleDbCommand ocmd = new OleDbCommand(sql0,oconn);
      ocmd.ExecuteNonQuery();
      oconn.Close();
    }
}
