Пример #1
0
        private void button1_Click(object sender, EventArgs e)
        {
            /*var userRepository = new UserRepository("Users");
             * Console.WriteLine(" Save into table users ");
             * var guid = Guid.NewGuid();
             * await userRepository.InsertAsync(new User()
             * {
             *  FirstName = "Test2",
             *  Id = guid,
             *  LastName = "LastName2"
             * });
             *
             *
             * await userRepository.UpdateAsync(new User()
             * {
             *  FirstName = "Test3",
             *  Id = guid,
             *  LastName = "LastName3"
             * });
             *
             *
             * List<User> users = new List<User>();
             *
             * for (var i = 0; i < 100000; i++)
             * {
             *  var id = Guid.NewGuid();
             *  users.Add(new User
             *  {
             *      Id = id,
             *      LastName = "aaa",
             *      FirstName = "bbb"
             *  });
             * }
             *
             * var stopwatch = new Stopwatch();
             * stopwatch.Start();
             *
             *
             * Console.WriteLine($"Inserted {await userRepository.SaveRangeAsync(users)}");
             *
             * stopwatch.Stop();
             * var elapsed_time = stopwatch.ElapsedMilliseconds;
             * Console.WriteLine($"Elapsed time {elapsed_time} ms");
             * Console.ReadLine();*/


            DataTable result = SqliteDataAccess.Consulta(textBox1.Text);

            dataGridView1.DataSource = result;
            dataGridView1.Refresh();
            dataGridView1.EndEdit();
        }