private void button6_Click(object sender, EventArgs e) { history_page o = new history_page(); o.Tag = textBox4.Text; o.Text = this.Text; o.Show(); this.Hide(); }
private async void button1_Click(object sender, EventArgs e) { SqlConnection = new OleDbConnection(connectString); await SqlConnection.OpenAsync(); OleDbDataReader sqlReader = null; if (textBox2.Text != "") { OleDbCommand command = new OleDbCommand("INSERT INTO [Чат] (Пользователь, Текст, Роль)VALUES(@login, @text, @rol)", SqlConnection); command.Parameters.AddWithValue("login", this.Text); command.Parameters.AddWithValue("text", textBox2.Text); command.Parameters.AddWithValue("rol", "Консультант"); await command.ExecuteNonQueryAsync(); command = new OleDbCommand("SELECT * FROM [Чат]", SqlConnection); sqlReader = command.ExecuteReader(); while (sqlReader.Read()) { int for_id = 0; while (true) { if (for_id == Convert.ToInt32(sqlReader["Код"])) { if (this.Text == Convert.ToString(sqlReader["Пользователь"])) { textBox1.Text += "Вы" + ": " + Convert.ToString(sqlReader["Текст"]) + "\r\n" + "\r\n"; } else { textBox1.Text += Convert.ToString(sqlReader["Пользователь"]) + " (" + Convert.ToString(sqlReader["Роль"]) + "): " + Convert.ToString(sqlReader["Текст"]) + "\r\n" + "\r\n"; } break; } for_id++; } } history_page a = new history_page(); a.Text = this.Text; a.Tag = this.Tag; a.Show(); this.Hide(); } else { textBox2.BackColor = Color.Peru; } }