Question

无法将类型“object”隐式转换为“System.Data.SqlClient.SqlDataReader

string coonstring = @"data source=ZHANGQI-FBFAF99;initial catalog=dbasp;integrated security=sspi";
SqlConnection coon = new SqlConnection(coonstring);

string cmdstring = "select shunxu from xs";
SqlCommand cmd = new SqlCommand(cmdstring, coon);
coon.Open();
SqlDataReader reder = cmd.ExecuteScalar();

xianshi.DataSource = reder;
xianshi.DataBind();
这段代码错在那里了.老这样提示,说SqlDataReader reder = cmd.ExecuteScalar();错了.可是就是看不明白.

Answer 1

将cmd.ExecuteScalar()改为cmd.ExecuteReader();即可

SqlDataReader reder = cmd.ExecuteReader();