private int CheckInAvailableLibrary(string partnumber) { int retval = 0; foreach (DataRow dr in partnumbers.Rows) { if (dr["PARTNUMBER"] != DBNull.Value) { if (dr["PARTNUMBER"].ToString() == partnumber) { retval = 1; break; } } } return retval; }