在线求助：无法将类型“System.Data.SqlClient.SqlDataReader”隐式转换为“System.Data.SqlClient.SqlDa

[ldneedu]

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;
public partial class vote : System.Web.UI.Page
{
public string voteID = "2";
protected void Page_Load(object sender, EventArgs e)
{
string sdr = "server=MICROSOF-58DADF\\SQLEXPRESS;database=vote;uid=sa;pwd=root;";
SqlConnection conn = new SqlConnection(sdr);
conn.Open();
SqlCommand cmd = new SqlCommand("select voteTitle from voteMaster where voteID="+this.voteID,conn);
string title =Convert.ToString( cmd.ExecuteScalar());
lblVoteTitle.Text = title;

SqlCommand cmdItem = new SqlCommand("select voteDetailsID,voteItem from voteDetails where voteID="+this.voteID,conn);
SqlDataAdapter sdr_cmd = cmdItem.ExecuteReader();
this.rBtnVoteItem.DataSource = sdr_cmd;
this.rBtnVoteItem.DataValueField = "voteDetailsID";
this.rBtnVoteItem.DataTextField = "voteItem";
this.rBtnVoteItem.DataBind();

sdr_cmd.Close();
conn.Close();



}
protected void btnVote_Click(object sender, EventArgs e)
{

}
}

==========================================================================================================
错误 1 无法将类型“System.Data.SqlClient.SqlDataReader”隐式转换为“System.Data.SqlClient.SqlDataAdapter” F:\C#教程\新建文件夹\vote\vote.aspx.cs 25 34 F:\...\vote\
错误 2 “System.Data.SqlClient.SqlDataAdapter”并不包含“Close”的定义 F:\C#教程\新建文件夹\vote\vote.aspx.cs 31 17 F:\...\vote\

[MSDNXGH]

SqlDataAdapter和dataset搭配的，

[shichao102471077]

你这是把sqldatareader 和SqlDataAdapter 搞混淆 了。。

看看你这行代码
SqlDataAdapter sdr_cmd = cmdItem.ExecuteReader();

SqlDataAdapter 改为sqldatareader

[ldneedu]

谢谢啊，搞定啦，恩，这两个长的太想啦，不小心把它给搞混了，呵呵