public override void Save() { try { if (grdPostCodes.RowCount == 0) { ENUtils.ShowMessage("Required : Post Code"); return; } StringBuilder sb = new StringBuilder(); StringBuilder sb2 = new StringBuilder(); //sb.Append("delete from StreetsData.dbo.Localization;"); //sb.Append("delete from StreetsData.dbo.LocalizationDetails;"); List <string> objList = new List <string>(); string PostCode = string.Join(",", grdPostCodes.Rows.Select(c => c.Cells[COLS.PostCode].Value.ToStr()).ToArray <string>()); string NewPostCode = string.Empty; foreach (var item in PostCode.Split(',')) { string Word = string.Empty; for (int i = 0; i < item.Length; i++) { if (item[i].ToStr().IsNumeric() == true) { objList.Add(Word); break; } else { Word += item[i].ToStr(); } } } //var list = objList.Distinct().ToList(); //foreach (var item in list) //{ // sb.Append("insert into PAFDb.dbo.Localization (PostCode) values ('" + item.ToStr() + "%" + "');"); //} var list2 = grdPostCodes.Rows.Select(c => c.Cells[COLS.PostCode].Value).ToList(); foreach (var item in list2) { sb2.Append("insert into PAFDb.dbo.LocalizationDetail (PostCode) values ('" + item.ToStr() + "');"); } using (TaxiDataContext db = new TaxiDataContext()) { db.stp_SaveLocalaization(sb.ToStr(), sb2.ToStr()); } General.LoadZoneList(); this.Close(); } catch (Exception ex) { ENUtils.ShowMessage(ex.Message); } }