อ่านข้อมูลจาก DataReader ไปเก็บไว้ใน List<object> ได้ข้อมูลแค่ Record สุดท้ายครับ

 
<script runat="server">
    private static List<object> goods;
 
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!X.IsAjaxRequest)
        {
            goods = new List<object>{
                                new  {
                                        Id = 1,
                                        Price = 71.72,
                                        Company = "3m Co",
                                        Date = new DateTime(2007, 9, 1),
                                        Size = "large",
                                        Visible = true
                                    },
                                new
                                    {
                                        Id = 27,
                                        Price = 45.45,
                                        Company = "Wal-Mart Stores, Inc",
                                        Date = new DateTime(2006, 09, 09),
                                        Size = "large",
                                        Visible = true
                                    }
            };
        }
    }
 
    protected void Store1_RefreshData(object sender, StoreRefreshDataEventArgs e)
    {
        List<object> data = new List<object>(goods); 
        //-- start paging ------------------------------------------------------------
        var limit = e.Limit;
        if ((e.Start + e.Limit) > data.Count)
        {
            limit = data.Count - e.Start;
        }
 
        List<object> rangeData = (e.Start < 0 || limit < 0) ? data : data.GetRange(e.Start, limit);
        //-- end paging ------------------------------------------------------------        
        e.Total = data.Count;
        this.Store1.DataSource = rangeData;
    }
</script>

<script runat="server">
  
    private static List<Object> sp;

    protected void Page_Load(object sender, EventArgs e)
    {
        if (!X.IsAjaxRequest)
        {

            SqlConnection myConnection;
            SqlCommand myCommand;
            SqlDataReader myDataReader;

            string strConn = System.Configuration.ConfigurationManager.ConnectionStrings["NorthwindSql"].ConnectionString;

            myConnection = new SqlConnection(strConn);
            myConnection.Open();

            myCommand = new SqlCommand("SELECT * FROM Suppliers WHERE supplierId <= 100", myConnection);
            myDataReader = myCommand.ExecuteReader();
            if (myDataReader.HasRows)
            {
                while (myDataReader.Read())
                {
                    sp = new List<object>
                    {
                        new
                        {
                                SupplierID = Convert.ToInt32(myDataReader["SupplierID"]),
                                CompanyName = myDataReader["CompanyName"].ToString(),
                                ContactName = myDataReader["ContactName"].ToString(),
                                ContactTitle = myDataReader["ContactTitle"].ToString()
                        }
                    };
                }
                myConnection.Close();
            }
        }
    }

    protected void Store1_RefreshData(object sender, StoreRefreshDataEventArgs e)
    {       
        List<object> data = new List<object>(sp);
		
        //-- start paging ------------------------------------------------------------
        var limit = e.Limit;
        if ((e.Start + e.Limit) > data.Count)
        {
            limit = data.Count - e.Start;
        }
 
        List<object> rangeData = (e.Start < 0 || limit < 0) ? data : data.GetRange(e.Start, limit);
        //-- end paging ------------------------------------------------------------            

        e.Total = data.Count;
        this.Store1.DataSource = rangeData;
    }
</script>	

                while (myDataReader.Read())
                {
                    sp = new List<object>
                    {
                        new
                        {
                                SupplierID = Convert.ToInt32(myDataReader["SupplierID"]),
                                CompanyName = myDataReader["CompanyName"].ToString(),
                                ContactName = myDataReader["ContactName"].ToString(),
                                ContactTitle = myDataReader["ContactTitle"].ToString()
                        }
                    };
                }

                while (myDataReader.Read())
                {
                    object newSp = new
                    {
                                SupplierID = Convert.ToInt32(myDataReader["SupplierID"]),
                                CompanyName = myDataReader["CompanyName"].ToString(),
                                ContactName = myDataReader["ContactName"].ToString(),
                                ContactTitle = myDataReader["ContactTitle"].ToString()
                    };
                    sp.Add(newSP);
                }