private void button3_Click(object sender, EventArgs e) { ResultsTextBox.Clear(); //ResultsTextBox.Text = CommandOne(procedureString, connectOne); using (SqlConnection connection = new SqlConnection(connectOne)) { try { SqlCommand command = new SqlCommand(queryString, connection); command.CommandType = CommandType.StoredProcedure; command.CommandText = "[Ten Most Expensive Products]"; command.Connection.Open(); SqlDataReader reader = command.ExecuteReader(); StringBuilder results = new StringBuilder(); while (reader.Read()) { for (int i = 0; i < reader.FieldCount; i++) { results.Append(reader[i].ToString() + "\t"); } results.Append(Environment.NewLine); } ResultsTextBox.Text = results.ToString(); } catch (SqlException ex) { MessageBox.Show(ex.Message, "Ошибка!", MessageBoxButtons.OK, MessageBoxIcon.Error); } } }
/* * Celem ćwiczenia jest uzupełnienie poniższych metod. * Każda metoda powinna zawierać kod C#, który z pomocą LINQ'a będzie realizować * zapytania opisane za pomocą SQL'a. * Rezultat zapytania powinien zostać wyświetlony za pomocą kontrolki DataGrid. * W tym celu końcowy wynik należy rzutować do Listy (metoda ToList()). * Jeśli dane zapytanie zwraca pojedynczy wynik możemy je wyświetlić w kontrolce * TextBox WynikTextBox. */ /// <summary> /// SELECT * FROM Emps WHERE Job = "Backend programmer"; /// </summary> public void Example1Button_Click(object sender, EventArgs e) { //var res = new List<Emp>(); //foreach(var emp in Emps) //{ // if (emp.Job == "Backend programmer") res.Add(emp); //} //1. Query syntax (SQL) // var res = from emp in Emps // where emp.Job == "Backend programmer" // select new // { // Nazwisko = emp.Ename, // Zawod = emp.Job // }; //2. Lambda and Extension methods var res = Emps.Where(emp => emp.Job.Equals("Backend programmer")).Select(emp => new { emp.Ename, emp.Salary }).ToList(); ResultsTextBox.Clear(); ResultsList.DataSource = res; }
private void RefreshResultsForm() { //MaintextBox.AppendText(grade.ToString()); // MaintextBox.AppendText("\r\n"); ResultsTextBox.Clear(); ResultsTextBox.AppendText($"TotalScore: {quiz.CorrectAnswers} / {quiz.NumberOfQuestions}"); }
/// <summary> /// SELECT MAX(Salary) FROM Emps; /// </summary> public void Example3Button_Click(object sender, EventArgs e) { var res = Emps.Max(emp => emp.Salary); ResultsTextBox.Clear(); ResultsTextBox.AppendText(res.ToString()); ResultsList.DataSource = null; }
private void SendAllButton_Click(object sender, EventArgs e) { ResultsTextBox.Clear(); var responses = ComObject.GetResponsesAtBaudRate(PortsComboBox.SelectedItem.ToString(), GetAllSelectedBauds()); string result = string.Join("\r\n", responses.Select(x => $"Baud {x.Key},{x.Value ?? "No response"}")); ResultsTextBox.Text = result; }
/// <summary> /// Zwróć wartość "true" jeśli choć jeden /// z elementów kolekcji pracuje jako "Backend programmer". /// </summary> public void Example8Button_Click(object sender, EventArgs e) { var res = Emps.Any(emp => "Backend programmer".Equals(emp.Job)); ResultsTextBox.Clear(); ResultsTextBox.AppendText(res.ToString()); ResultsList.DataSource = null; }
//Znajdź pracownika z najwyższą pensją wykorzystując metodę Aggregate() public void Example11Button_Click(object sender, EventArgs e) { var res = Emps.Aggregate((empA, empB) => empA.Salary > empB.Salary ? empA : empB); ResultsTextBox.Clear(); ResultsTextBox.AppendText(res.ToString()); ResultsList.DataSource = null; }
private void button5_Click(object sender, EventArgs e) { ResultsTextBox.Clear(); thisCity = CityTextBox.Text; string paramRequest = "SELECT CustomerID, CompanyName, City FROM Customers WHERE City = @City"; ResultsTextBox.Text = CommandTwo(paramRequest, connectOne, thisCity); }
/// <summary> /// SELECT TOP 1 * FROM Emp WHERE Job="Frontend programmer" /// ORDER BY HireDate DESC; /// </summary> public void Example9Button_Click(object sender, EventArgs e) { var res = Emps.Where(emp => "Frontend programmer".Equals(emp.Job)) .Take(1) .ToList(); ResultsTextBox.Clear(); ResultsList.DataSource = res; }
//Z pomocą języka LINQ i metody SelectMany wykonaj złączenie //typu CROSS JOIN public void Example12Button_Click(object sender, EventArgs e) { var res = Emps.SelectMany(emp => Depts.Select(dept => new { emp.Ename, dept.Dname })).ToList(); ResultsTextBox.Clear(); ResultsList.DataSource = res; }
/// <summary> /// SELECT ename AS Nazwisko, job AS Praca FROM Emps; /// </summary> public void Example5Button_Click(object sender, EventArgs e) { var res = Emps.Select(emp => new { Nazwisko = emp.Ename, Praca = emp.Job }).ToList(); ResultsTextBox.Clear(); ResultsList.DataSource = res; }
/// <summary> /// SELECT Job AS Praca, COUNT(1) LiczbaPracownikow FROM Emps GROUP BY Job; /// </summary> public void Example7Button_Click(object sender, EventArgs e) { var res = Emps.GroupBy(emp => emp.Job) .Select(emps => new { Praca = emps.Key, Count = emps.Count() }).ToList(); ResultsTextBox.Clear(); ResultsList.DataSource = res; }
/// <summary> /// SELECT * FROM Emps WHERE Salary=(SELECT MAX(Salary) FROM Emps); /// </summary> public void Example4Button_Click(object sender, EventArgs e) { var res = Emps.Where(emp => emp.Salary == Emps.Max(empSal => empSal.Salary)) .Select(emp => new { emp.Ename, emp.Salary }).ToList(); ResultsTextBox.Clear(); ResultsList.DataSource = res; }
/// <summary> /// SELECT Emps.Ename, Emps.Job, Depts.Dname FROM Emps /// INNER JOIN Depts ON Emps.Deptno=Depts.Deptno /// Rezultat: Złączenie kolekcji Emps i Depts. /// </summary> public void Example6Button_Click(object sender, EventArgs e) { var res = Emps.Join(Depts, emp => emp.Deptno, dept => dept.Deptno, (emp, dept) => new { emp.Ename, emp.Job, dept.Dname }).ToList(); ResultsTextBox.Clear(); ResultsList.DataSource = res; }
/// <summary> /// SELECT * FROM Emps Job = "Frontend programmer" AND Salary>1000 ORDER BY Ename DESC; /// </summary> public void Example2Button_Click(object sender, EventArgs e) { var res = Emps.Where(emp => emp.Job.Equals("Frontend programmer") && emp.Salary >= 1000) .Select(emp => new { emp.Ename, emp.Salary }).ToList(); ResultsTextBox.Clear(); ResultsList.DataSource = res; }
private void FindButton_Click(object sender, EventArgs e) { ResultsTextBox.Clear(); string input = AddressTextBox.Text; if (LookupRadioButton.Checked) { var result = AddressFinder.Find(input); ResultsTextBox.Text = result.ToString(); } else { var result = AddressFinder.Parse(input); ResultsTextBox.Text = result.ToString(); } }
/// <summary> /// SELECT Ename, Job, Hiredate FROM Emps /// UNION /// SELECT "Brak wartości", null, null; /// </summary> public void Example10Button_Click(object sender, EventArgs e) { var res = Emps.Union( new List <Emp> { new Emp { Ename = "Brak wartości", Job = null, HireDate = null } }) .Select(emp => new { emp.Ename, emp.Job, emp.HireDate }).ToList(); ResultsTextBox.Clear(); ResultsList.DataSource = res; }
private void TestRegexButton_Click(object sender, EventArgs e) { ResultsTextBox.Clear(); try { RegexOptions selectedRegexOptions = this.GetSelectedRegexOptions(); Regex regex = new Regex(this.RegexTextBox.Text, selectedRegexOptions); var mch = regex.Match(this.InputTextBox.Text); if (mch.Success) { //this.ResultsTextBox.Text = "MATCH FOUND"; //this.ResultsTextBox.ForeColor = Color.Black; ShowMatch(true); var sb = new StringBuilder(); if (mch.Groups.Count > 0) { sb.AppendLine($"Groups[{mch.Groups.Count}]:"); sb.AppendLine("-------------------------------"); } foreach (var mgo in mch.Groups) { Group mg = mgo as Group; var idx = (mg.Success, mg.Index, End : (mg.Index + mg.Length)); var idxTxt = idx.Success ? $"{idx.Index:0000} - {idx.End:0000}" : " fail! "; sb.AppendLine($"[{idxTxt}]<{mg.Name}>:{mg.Value}"); } ResultsTextBox.Text = sb.ToString(); } else { //this.ResultsTextBox.Text = "NO MATCH FOUND"; //this.ResultsTextBox.ForeColor = Color.Red; ShowMatch(false); } } catch (ArgumentException exception) { this.ResultsTextBox.ForeColor = Color.Red; this.ResultsTextBox.Text = "There was an error in your regular expression:" + Environment.NewLine + exception.Message; } }
private void button6_Click(object sender, EventArgs e) { ResultsTextBox.Clear(); using (SqlConnection connection = new SqlConnection(connectOne)) { try { SqlCommand command = new SqlCommand(queryString, connection); command.CommandType = CommandType.StoredProcedure; command.CommandText = "SalesByCategory"; command.Parameters.Add("@CategoryName", SqlDbType.VarChar, 80).Value = CategoryNameTextBox.Text; command.Parameters.Add("@OrdYear", SqlDbType.Int).Value = OrdYearTextBox.Text; command.Connection.Open(); SqlDataReader reader = command.ExecuteReader(); StringBuilder results = new StringBuilder(); while (reader.Read()) { for (int i = 0; i < reader.FieldCount; i++) { results.Append(reader[i].ToString() + "\t"); } results.Append(Environment.NewLine); } ResultsTextBox.Text = results.ToString(); } catch (SqlException ex) { MessageBox.Show(ex.Message, "Ошибка!", MessageBoxButtons.OK, MessageBoxIcon.Error); } finally { connection.Close(); } } }
private void SearchButton_Click(object sender, EventArgs e) { ResultsTextBox.Clear(); worker.RunWorkerAsync(); }
private void button2_Click(object sender, EventArgs e) { ResultsTextBox.Clear(); ResultsTextBox.Text = CommandOne(queryStringTwo, connectOne); }
private void ClearButton_Click(object sender, EventArgs e) { ResultsTextBox.Clear(); }
private async void solveBtn_Click(object sender, EventArgs e) { solveBtn.Enabled = false; solveBtn.Text = "Solving..."; TOTAL_SOLUTIONS = 0; ResultsTextBox.Clear(); #region TEST COLLECTION: //short[,] A = new short[,] //{ // { 1, 1, 1 }, // { 1, 0, 1 } //};//4 Distinct //short[,] B = new short[,] //{ // { 0, 1 }, // { 0, 1 }, // { 1, 1 }, // { 0, 1 } //};//8 Distinct //short[,] C = new short[,] //{ // { 1 }, // { 1 }, //};//2 Distinct //short[,] D = new short[,] //{ // { 1, 0 }, // { 1, 0 }, // { 1, 1 } //};//8 Distinct //var sm = new ShapeMan(new List<Shape> { new Shape(A), new Shape(B), new Shape(C), new Shape(D) }); //foreach (var item in sm.ReadyShapesLists) // await new Solver(item, this).TrySolve(); //if(TOTAL_SOLUTIONS == 0) // WriteLine("No Possible Solution!"); #endregion if (await ReadShapes()) { ShapeMan sm = new ShapeMan(shapes); List <Task> tasks = new List <Task>(sm.ReadyShapesLists.Count); foreach (var item in sm.ReadyShapesLists) { tasks.Add(new Solver(item, this).TrySolve()); //auto writes } var sw = new Stopwatch(); #region Solving Parallel sw.Start(); Thread.BeginThreadAffinity(); Parallel.ForEach(tasks, task => task.Start()); Thread.EndThreadAffinity(); await Task.WhenAll(tasks); sw.Stop(); #endregion if (TOTAL_SOLUTIONS == 0) { WriteLine(string.Format("No Possible Solution!, Time Elapsed: {0}s.", (sw.ElapsedMilliseconds / 1000.0).ToString())); } else { WriteLine(string.Format("Total Possible Solutions : {0}, Time Elapsed: {1}s.", TOTAL_SOLUTIONS.ToString(), (sw.ElapsedMilliseconds / 1000.0).ToString())); } } else { WriteLine("Cannot Read Shapes!,"); WriteLine("Please Check & Format Input Correctly."); } solveBtn.Text = "Solve"; solveBtn.Enabled = true; }