public List<FinishingLine> getFinishingLineAll() { List<FinishingLine> fininshinglines = new List<FinishingLine>(); FinishingLine f; try { conn = db.openConn(); sb = new StringBuilder(); sb.Remove(0, sb.Length); sb.Append(" SELECT id,name FROM finishing_lines "); string sql; sql = sb.ToString(); comm = new SqlCommand(); comm.CommandText = sql; comm.CommandType = CommandType.Text; comm.Connection = conn; dr = comm.ExecuteReader(); if (dr.HasRows) { DataTable dt = new DataTable(); dt.Load(dr); foreach (DataRow drw in dt.Rows) { f = new FinishingLine(); f.ID = Convert.ToInt32(drw["id"].ToString()); f.Name= drw["name"].ToString(); fininshinglines.Add(f); } } } catch (Exception ex) { dr.Close(); conn.Close(); return null; throw ex; } finally { conn.Close(); } return fininshinglines; }