private void SendNewTicket_Click(object sender, EventArgs e) { //if (string.IsNullOrEmpty(NewTicketState.Text)) //{ // MessageBox.Show("Selecteer een Ticketstatus."); //} //else //{ // if (string.IsNullOrEmpty(NewSubjectBox.Text)) // { // MessageBox.Show("Het ticketonderwerp ontbreekt vul deze in a.u.b."); // } // else // { // if (string.IsNullOrEmpty(NewIssueBox.Text)) // { // MessageBox.Show("Het issueveld is leeg vul dit in a.u.b."); // } // else // { doTicket obj = new doTicket(); obj.Issue = NewIssueBox.Text; obj.Subject = NewSubjectBox.Text; if (obj.IsValid()) { //Ticketinformatie naar de database sturen string insertCmdText = obj.InsertStatement();// "INSERT INTO dbo.Tickets(ticket_subject, ticket_issue, ticket_state)values('" + this.NewSubjectBox.Text + "','" + this.NewIssueBox.Text + "','" + this.NewTicketState.Text + "');"; SqlCommand sqlCom = new SqlCommand(insertCmdText, con); sqlCom.ExecuteNonQuery(); MessageBox.Show("De Ticket is aangemaakt, u ontvangt zo spoedig mogelijk terugkoppeling."); } // } // } //} }
private void button1_Click(object sender, EventArgs e) { List <String> columnData = new List <String>(); SqlConnection connection = con; { //connection.Open(); string query = "SELECT * FROM Tickets"; using (SqlCommand command = new SqlCommand(query, connection)) { using (SqlDataReader reader = command.ExecuteReader()) { while (reader.Read()) { doTicket obj = new doTicket(reader); obj.FillListViewItem(listView1.Items.Add("")); String test = obj.InsertStatement(); } } } // connection.Close(); } }