public static List<Batch> getAllBatchList(string batchName) { OleDbConnection connection = new OleDbConnection(global::ResultManagement.Properties.Settings.Default.ConnectionString); String cmdString = @"SELECT batch FROM Student WHERE 1 "; if (batchName != null) { cmdString += " AND batch = '" + batchName + "'"; } cmdString += " GROUP BY batch"; OleDbCommand cmd = new OleDbCommand(cmdString, connection); List<Batch> batchList = new List<Batch>(); try { connection.Open(); OleDbDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { Batch b = new Batch(); b.batchName = (string)reader.GetValue(reader.GetOrdinal("batch")); b.batchID = b.batchName; batchList.Add(b); } } finally { connection.Close(); } return batchList; }
public static Batch getAllMapping() { Batch b = new Batch(); b.batchID = null; b.batchName = "(All)"; return b; }