SqlDataReader填充结构体

本文关键字:结构体 填充 SqlDataReader | 更新日期: 2023-09-27 17:51:09

有一个私有的"Employee"类对象,它镜像了公共结构体"empStruct"。我需要使用SQLReader从查询中读取行值来填充结构,然后将对象设置为等于结构值。我认为有一个更简单的方法,但我是新手。

public struct empStruct
    {
        public int eid;
        public string lastname;
        public string firstname;
        public DateTime birthdate;
        public DateTime hiredate;
        public bool ishourly;
        public decimal payrate;
    }
        public static bool SelectEmployee(int eid)
    {
        empStruct SelectRecord = new empStruct();
        Employee newEmp = new Employee();
        string sqlText;
        sqlText = "SELECT EID,EID, LastName, FirstName, BirthDate, HireDate, IsHourly, PayRate ";
        sqlText += "FROM Employee ";
        sqlText += "WHERE EID = @EID ";
        using (SqlConnection connection = new SqlConnection(connectionString))
        {
            SqlCommand command = new SqlCommand(sqlText, connection);
            command.CommandType = CommandType.Text;
            command.Parameters.AddWithValue("@EID", eid);
            connection.Open();
            SqlDataReader reader = command.ExecuteReader();
            //Call Read before accessing data.
            while (reader.Read())
            {
                ???
            }
            newEmp = SelectRecord;
        }

我明白"//Call Read…"之后的一切都是不完整的,我不能确切地弄清楚这个阅读器是如何工作的。

SqlDataReader填充结构体

while (reader.Read())
{
newEmp.eid = (int)reader("EID");
newEmp.firstname = (string)reader("FirstName");
....
}

像这样加载结构体

while (reader.Read())            {
   newEmp.lastname = reader.GetString(1);
   newEmp.firstname  = reader.GetString(2);

}