mysql - 索引超出范围。必须为非负数且小于集合的大小

我有以下代码来获取对象中的表数据，但出现错误，而且我不知道哪里出错了。

    public List<ModelGetEmployeeList> GetEmployeeList()
            {

               List<ModelGetEmployeeList> empList = new List<ModelGetEmployeeList>();
                DataTable dt = new DataTable();

                string q = "select uid,fname,lname from nworksuser;";
                MySqlCommand cmd = new MySqlCommand(q,conn);
                MySqlDataAdapter adapter = new MySqlDataAdapter(cmd); ;
                conn.Open();
                adapter.Fill(dt);
                conn.Close();
                for (int i = 0; i < dt.Rows.Count; i++)
                {
                    foreach (DataRow row in dt.Rows)
                    {
                        //Here I am getting following error
                        // Index was out of range. Must be non-negative and less than the size of the collection.
                        empList[i].uid = row["uid"].ToString();
                        empList[i].fname = row["fname"].ToString();
                        empList[i].lname = row["lname"].ToString();
                    }
                }
                return empList;
            }

而且ModelGetEmployeeList类是这样的-

public class ModelGetEmployeeList
    {
        public string uid { get; set; }
        public string fname { get; set; }
        public string lname { get; set; }
    }

最佳答案

因为您的empList为空。

将ModelGetEmployeeList添加到列表的正确方法是：

ModelGetEmployeeList employee;

foreach (DataRow row in dt.Rows)
{
    employee = new ModelGetEmployeeList();
    employee.uid = row["uid"].ToString();
    employee.fname = row["fname"].ToString();
    employee.lname = row["lname"].ToString();

    empList.Add(employee);
}

关于mysql - 索引超出范围。必须为非负数且小于集合的大小，我们在Stack Overflow上找到一个类似的问题：https://stackoverflow.com/questions/38760197/