public DAL.DataSet1.gridDataTable GetDataByUsername(string username) { DAL.DataSet1.gridDataTable grid = Adapter.GetDataByUsername(); for (int i = 1; i < grid.Rows.Count; i++) { //if (grid.Rows[i]["title"].ToString() == grid.Rows[i - 1]["title"].ToString()) if (grid.Rows[i]["entry_id"].ToString() == grid.Rows[i - 1]["entry_id"].ToString()) { grid.Rows[i]["AuthorName"] = grid.Rows[i - 1]["AuthorName"] + ", " + grid.Rows[i]["AuthorName"]; grid.Rows[i - 1].Delete(); } } for (int i = 1; i < grid.Rows.Count; i++) { if (grid.Rows[i].RowState != DataRowState.Deleted && username != grid.Rows[i]["taken_by"].ToString()) { grid.Rows[i].Delete(); } } grid.Columns.Remove("entry_id"); grid.Columns.Remove("BooksLeft"); grid.Columns["book_id"].SetOrdinal(0); return(grid); }
public DAL.DataSet1.gridDataTable GetData(byte filter = 0) { //gridTableAdapter gridAdapter = new gridTableAdapter(); DAL.DataSet1.gridDataTable grid = Adapter.GetData(); for (int i = 1; i < grid.Rows.Count; i++) { if (grid.Rows[i]["title"].ToString() == grid.Rows[i - 1]["title"].ToString()) { grid.Rows[i]["AuthorName"] = grid.Rows[i - 1]["AuthorName"] + ", " + grid.Rows[i]["AuthorName"]; grid.Rows[i - 1].Delete(); } } if (filter == 1) { for (int i = 0; i < grid.Rows.Count; i++) { if (grid.Rows[i].RowState != DataRowState.Deleted && Convert.ToByte(grid.Rows[i]["BooksLeft"]) == 0) { grid.Rows[i].Delete(); } } } grid.Columns["book_id"].SetOrdinal(0); return(grid); //Adapter.GetData(); }