public static DataTable GetCustomerList(eSolutionDataContext db, Boolean argAll = false) { //EMSdb = new eSolutionDataContext(); DataTable dt = new DataTable(); DataColumn colValue = new DataColumn(); DataColumn colText = new DataColumn(); DataRow newRow; try { colText.ColumnName = HelperClass.DisplayName; colValue.ColumnName = HelperClass.CodeName; colText.DataType = typeof(System.String); colValue.DataType = typeof(System.String); dt.Columns.Add(colText); dt.Columns.Add(colValue); var sqlQuery = db.stp_CustomerList().ToList(); //var sqlQuery = from obj in db.Customers // group obj by new // { // obj.CustomerCode // , // obj.CustomerName // } // into grouping // select new { grouping.Key, grouping }; if (argAll == true) { newRow = dt.NewRow(); newRow[HelperClass.DisplayName] = "ALL"; newRow[HelperClass.CodeName] = ""; dt.Rows.Add(newRow); } foreach (var row in sqlQuery) { newRow = dt.NewRow(); //newRow[HelperClass.DisplayName] = row.Key.CustomerName; //newRow[HelperClass.CodeName] = row.Key.CustomerCode; newRow[HelperClass.DisplayName] = row.DisplayName; newRow[HelperClass.CodeName] = row.CodeName; dt.Rows.Add(newRow); } } catch { dt = null; } finally { } return(dt); }