GridView那点事之【如何使用ExecuteReader()来绑定数据显示到表格中】 .

//从web.config中引用连接字符串
        string strConn = WebConfigurationManager.ConnectionStrings["NorthwindConnectionString"].ConnectionString;
        SqlConnection myConn = new SqlConnection(strConn);
        string strSQL = "SELECT Top 5 CategoryID,CategoryName,Description From Categories";
        SqlCommand myCommand = new SqlCommand(strSQL, myConn);
        myConn.Open();
        myGv.DataSource = myCommand.ExecuteReader();
        myGv.DataBind();
        myConn.Close();