SqlReader通过字段名读取数据

    using(SqlDataReader    SDR=    SQLHelper.ExecuteReader("SP_****",SqlParameter))
                ...{
                    
                    while( SDR.Read())
                    ...{

                        int Count    =    SDR.FieldCount;

                        for (    int i=0;i<Count;i++    )
                        ...{
                            string fieldName    =    SDR.GetName(i);

                            
                            //ID
                            if    (fieldName    =="ID")
                            ...{
                                if    (    SDR.IsDBNull(i)    )
                                ...{    Roster.ID    =    "";}
                                else
                                ...{    Roster.ID    =    SDR.GetString(i);    }
                            }
                            //Name
                            if    (fieldName    =="Name")
                            ...{
                                if    (    SDR.IsDBNull(i)    )
                                ...{    Roster.Name    =    "";}
                                else
                                ...{    Roster.Name    =    SDR.GetString(i);    }
                            }
                            //Sex
                            if    (fieldName    =="Sex")
                            ...{
                                if    (    SDR.IsDBNull(i)    )
                                ...{    Roster.Sex     =    "";}
                                else
                                ...{    Roster.Sex    =    SDR.GetString(i);    }
                            }

                            //Photo
                            if    (fieldName    =="Photo")
                            ...{
                                if    (    SDR.IsDBNull(i)    )
                                ...{    //Roster.Photo.Sex     =    "";
                                }
                                else
                                ...{    Roster.Photo    =(byte[])SDR["Photo"];    }
                            }

                        }

                    }

                    SDR.Close();
                }