Search code examples
htmldata-conversionselectlistitem

DataType Conversion Issue from DataTable to SelectItemList

Here is my code. In which I'am trying to convert table into list. Data type of PatientAdmissionStatusId is long from table. Whats the right way to convert it or assign without conversion.

DataTable dtPatientAddmissionStatus = // Some Function returning dataTable
List<SelectListItem> list = dtPatientAddmissionStatus.AsEnumerable().Select(x => new SelectListItem
            {
                Value = x.Field<long>("PatientAdmissionStatusId").ToString(),
                Text = x.Field<string>("PatientAdmissionStatusName").ToString()
            }).ToList<SelectListItem>();

also tried

    x.Field<string>("PatientAdmissionStatusId").ToString(),
    x.Field<long>("PatientAdmissionStatusId")
Solution

  • Are you sure DataType is long? try int

    x.Field<long>("PatientAdmissionStatusId")