无法将类型“int”隐式转换为“System.Data.SqlClient.SqlDataReader
大_健 2013-01-17 05:28:25 protected void Page_Load(object sender, EventArgs e)
{
if ((string)Session["userRole"] != "0")
Response.Redirect("Login.aspx");
string tn = (string)Session["userName"];
SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString1"].ConnectionString);
SqlCommand cmd = conn.CreateCommand();
cmd.CommandText = "select * from 课程 where 教师号='" + tn + "'";
conn.Open();
SqlDataReader dr = cmd.ExecuteNonQuery();//问题所在处1
GridView1.DataSource = dr;
GridView1.DataBind();
dr.Close();
SqlCommand cmd1 = conn.CreateCommand();
cmd1.CommandText = "select 姓名 from 教师 where 教师号='" + tn + "'";
SqlDataReader dr1 = cmd1.ExecuteNonQuery();//问题所在处2
dr1.Read();
LabMes.Text = (string)dr1[0] + "老师的任课情况:";
Session["teacher"] = (string)dr1[0];
conn.Close();
}