一、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;
using System.Data.SqlClient;
using System.Configuration;
public partial class diaocha : System.Web.UI.Page
{
private string dcid;
private string leixing;
private string ConnStr = null;
protected void Page_Load(object sender, System.EventArgs e)
{
if (!IsPostBack)
{
// 在此处放置用户代码以初始化页面
ConnStr = ConfigurationSettings.AppSettings["connstr"];
SqlConnection con = new SqlConnection(ConnStr);
con.Open();
SqlCommand cmd = new SqlCommand("select top 1 id,title,types from V_title order by id desc", con);
SqlDataReader rs = cmd.ExecuteReader();
if (rs.Read())
{
Labtitle.Text = rs["Title"].ToString();
dcid = rs["id"].ToString();
leixing = rs["types"].ToString();
Label1.Text=rs["types"].ToString();
Label2.Text = rs["id"].ToString();
}
rs.Close();
SqlCommand cmd1 = new SqlCommand("select id,cont from V_vote where lid='" + dcid + "' order by id desc", con);
SqlDataReader rs1 = cmd1.ExecuteReader();
if (leixing == "1") //1为单选2为多选
{
dcradio.DataSource = rs1;
dcradio.Visible = true;
dcradio.DataTextField = "cont";
dcradio.DataValueField = "id";