public DataSet GetPOListFiltered(string status) { StringBuilder sql; SqlDataAdapter da; DataSet ProgramData; DalDbConn dbConn = new DalDbConn(); SqlConnection conn = dbConn.GetConnection(); ProgramData = new DataSet(); sql = new StringBuilder(); sql.AppendLine("SELECT *"); sql.AppendLine("FROM Delivery"); sql.AppendLine("WHERE deliveryStatus = @PS"); sql.AppendLine("ORDER BY trackingID DESC"); try { da = new SqlDataAdapter(sql.ToString(), conn); da.SelectCommand.Parameters.AddWithValue("PS", status); da.Fill(ProgramData); } catch (Exception ex) { string errMsg = ex.Message; } finally { conn.Close(); } return(ProgramData); }