//------------------------------------------------------------------------------- internal static void dbAutoComplSearch(string connectStringDB, string autocomplitWord) { var findWorldDict = new Dictionary <string, int>(); var keyForRemove = new List <string>(); dataSetSimpleText ds = new dataSetSimpleText(); dataSetSimpleText.NameDataTable tblName = ds.Name; dataSetSimpleTextTableAdapters.NameTableAdapter daName; daName = new dataSetSimpleTextTableAdapters.NameTableAdapter(); Console.WriteLine(daName.ClearBeforeFill); tblName.Clear(); daName.Fill(tblName); foreach (dataSetSimpleText.NameRow rowName in tblName) { if (findWorldDict.ContainsKey(rowName.word) || !rowName.word.StartsWith(autocomplitWord)) { continue; } findWorldDict.Add(rowName.word, rowName.wordCount); } findWorldDict = findWorldDict. OrderByDescending(pair => pair.Value). ToDictionary(pair => pair.Key, pair => pair.Value); // Место для сортировки по ключу при равных значениях Value. printDisplayFiveValue(findWorldDict, 5); }
internal static void dbInitialMethod(string connectStringDB, Dictionary <string, int> frequency) { dataSetSimpleText ds = new dataSetSimpleText(); dataSetSimpleText.NameDataTable tblName = ds.Name; dataSetSimpleTextTableAdapters.NameTableAdapter daName; daName = new dataSetSimpleTextTableAdapters.NameTableAdapter(); Console.WriteLine(daName.ClearBeforeFill); var dataCount = daName.ScalarQuery(); if (dataCount != 0) { dbDeleteMethod(connectStringDB); } // Console.WriteLine(daName.Fill(tblName)); Console.WriteLine("Load data..."); foreach (var e in frequency) { daName.Insert(e.Key, e.Value); } Console.WriteLine("End Load data..."); }
//------------------------------------------------------------------------------- internal static void dbUpdateMethod(string connectStringDB, Dictionary <string, int> frequency) { dataSetSimpleText ds = new dataSetSimpleText(); dataSetSimpleText.NameDataTable tblName = ds.Name; dataSetSimpleTextTableAdapters.NameTableAdapter daName; daName = new dataSetSimpleTextTableAdapters.NameTableAdapter(); Console.WriteLine(daName.ClearBeforeFill); foreach (var e in frequency) { tblName.AddNameRow(e.Key, e.Value); } Console.WriteLine("Update data ..."); daName.Update(tblName); Console.WriteLine("End Update data "); }