A button click event is supposed to execute the SQL query, but clicking the button does nothing.

private void btnAddRecord_Click(object sender, EventArgs e) { // Define the connection string and SQL query string connectionString = "Data Source=myServerAddress;Database=myDataBase;User Id=myUsername;Password=myPassword;"; string query = "INSERT INTO TableName (ColumnName1, ColumnName2) VALUES (@Value1, @Value2)"; // Get values from input fields (replace with actual control names) string value1 = textBoxValue1.Text; string value2 = textBoxValue2.Text; // Use a try-catch-finally block for error handling using (SqlConnection connection = new SqlConnection(connectionString)) { try { // Create the SQL command and add parameters to prevent SQL injection SqlCommand command = new SqlCommand(query, connection); command.Parameters.AddWithValue("@Value1", value1); command.Parameters.AddWithValue("@Value2", value2); // Open the connection and execute the query connecti

IDENTIFY THE ERROR: INSERT INTO Employees (EmployeeID, Name, Salary, Position) VALUES (1, 'John Doe', Developer, '50000');

INSERT INTO Employees (EmployeeID, Name, Position, Salary) VALUES (1, 'John Doe', 'Developer', 50000);

IDENTIFY THE ERROR: DELETE FROM Employees WHERE is EmployeeID = 1;

DELETE FROM Employees WHERE EmployeeID = 1;

The code should filter data based on a user-entered customer ID in textBoxCustomerID and display the result in lblCustomerName. It runs but displays nothing.

string query = "SELECT CustomerName FROM Customers WHERE CustomerID = @CustomerID"; SqlCommand command = new SqlCommand(query, connection); command.Parameters.AddWithValue("@CustomerID", textBoxCustomerID.Text); connection.Open(); lblCustomerName.Text = command.ExecuteScalar()?.ToString() ?? "No customer found"; connection.Close();

The code should connect to a SQL database and fill a DataGridView with data. However, it does not work. Identify the issue.

string connectionString = "Data Source=myServerAddress;Database=myDataBase;User Id=myUsername;Password=myPassword;";

The code should insert a new user's gender into the database based on the selected radio button (radioMale or radioFemale). However, it always inserts "Unknown".

string gender = radioMale.Checked ? "Male" : radioFemale.Checked ? "Female" : "Unknown";

The code below is supposed to display the total number of customers in lblTotalCustomers, but it always shows zero.

string query = "SELECT COUNT(*) FROM Customers"; SqlCommand command = new SqlCommand(query, connection); connection.Open(); lblTotalCustomers.Text = command.ExecuteScalar()?.ToString() ?? "0"; connection.Close();

This code updates a customer's email in the database, but it updates all customers instead of just one.

string query = "UPDATE Customers SET Email = @Email WHERE CustomerID = @CustomerID"; SqlCommand command = new SqlCommand(query, connection); command.Parameters.AddWithValue("@Email", textBoxEmail.Text); command.Parameters.AddWithValue("@CustomerID", textBoxCustomerID.Text); connection.Open(); command.ExecuteNonQuery(); connection.Close();

The btnDelete button stops working after an error occurs while attempting to delete a record.

try { string query = "DELETE FROM Orders WHERE OrderID = @OrderID"; SqlCommand command = new SqlCommand(query, connection); command.Parameters.AddWithValue("@OrderID", textBoxOrderID.Text); connection.Open(); command.ExecuteNonQuery(); MessageBox.Show("Order deleted successfully."); } catch (Exception ex) { MessageBox.Show("Error: " + ex.Message); } finally { connection.Close(); }

The code is supposed to insert a username from textBoxUsername into the database, but it throws an error when the text box is empty.

if (string.IsNullOrWhiteSpace(textBoxUsername.Text)) { MessageBox.Show("Please enter a username."); return; } string username = textBoxUsername.Text; string query = "INSERT INTO Users (Username) VALUES (@Username)"; SqlCommand command = new SqlCommand(query, connection); command.Parameters.AddWithValue("@Username", username); connection.Open(); command.ExecuteNonQuery(); connection.Close();

ITD103_Windows Form

Presentation

•

Computers

•

University

•

Practice Problem

•

Medium

Wency Jorda

Used 5+ times

FREE Resource

2 Slides • 36 Questions

Object Oriented
Programming 2

ITD103L

Wency N. Jorda

Instructor

C# Windows Forms
Applications

Multiple Choice

What is the primary purpose of Windows Forms in the .NET Framework?

To create web applications

To simplify the development of desktop applications for Windows

To manage databases

To create console applications

Multiple Choice

What type of applications can be created using Windows Forms?

Web applications

Console applications

Windows desktop applications

Cloud Application

Multiple Choice

In Visual Studio, which namespace is commonly imported for Windows Forms applications?

System.Console

System.Drawing

System.IO

System.Windows.Forms

Fill in the Blanks

Type answer...

Multiple Choice

What is the purpose of the InitializeComponent() method in a Windows Forms application?

It starts the application’s process loop

It initializes and sets up the form and its controls

It handles user input validation

It defines the form’s layout and appearance

Multiple Select

How can you add a Button control to a form in Visual Studio?

(Select all the correct answers)

By typing the code manually in the Program.cs file

By dragging it from the Toolbox to the form

By selecting it from the Solution Explorer

By writing code in Form1.Designer.cs

Multiple Choice

What is the purpose of the ErrorProvider component in Windows Forms?

To log errors in the application

To provide tooltips for controls

To validate user input and show error messages

To display confirmation messages

Fill in the Blanks

Type answer...

Multiple Choice

Blank organizes related control within a labeled container

GroupBox

ComboBox

Panel

RadioButton

Multiple Choice

Which SQL command is used to retrieve data in a CRUD operation?

SELECT

RETRIEVE

READ

GET

Multiple Choice

Which C# class is commonly used to interact with a SQL database?

SqlManager

SqlDatabase

SqlConnection

SqlClient

Fill in the Blanks

Type answer...

Multiple Choice

This component allow the selection of one option from a group

ComboBox

Button

RadioButton

GroupBox

Fill in the Blanks

Type answer...

Open Ended

What are the steps to create a new Windows Forms project in Visual Studio?

Type response here

Open Ended

Explain the difference between TextBox and Label controls.

Type response here

Open Ended

What is the purpose of NuGet Package Manager?

Type response here

Fill in the Blanks

Type answer...

Open Ended

What is the purpose of ErrorProvider?

Type response here

Multiple Choice

What is the purpose of the Form1.Designer.cs file in a Windows Forms project?

It contains event-handling code for form events

It holds the auto-generated code for form layout and controls

It is the main code file where execution starts

It contains resource files for the project

Fill in the Blanks

Type answer...

Multiple Choice

Which of the following is the Radio button?

Multiple Choice

Which of the following is the Check button?

Fill in the Blanks

Type answer...

Multiple Choice

Which of these allows the user to modify the properties of components?

Multiple Choice

Which of these allows the user to check the files within the project?

Multiple Choice

Which of these allows the user to add gui components?

Multiple Choice

Which of these allows the user to add forms, class, and existing project?

Fill in the Blanks

Type answer...

Multiple Choice

Which of these allows the user to add database connection?

Multiple Choice

Which of these allows the user to modify the events of the component?

Multiple Choice

To display a message box in Windows Forms, which class should be used?

Display

Show

Message

MessageBox

Fill in the Blanks

Type answer...

Multiple Choice

What is the default file extension for a Windows Forms application in C#?

.csh

.cs

.form

.exe

Fill in the Blanks

Type answer...

Multiple Choice

What namespace must be included to use Windows Forms in C#?

System.IO

System.Windows.Forms

System.Data

System.Drawing

Object Oriented
Programming 2

ITD103L

Wency N. Jorda

Instructor

Show answer

Auto Play

Slide 1 / 38

SLIDE

Similar Resources on Wayground

34 questions

Week 3 - Functions (DCS1101)

Presentation

•

University

31 questions

Chapter 7 Part 8

Presentation

•

KG - Professional Dev...

37 questions

Week 7 - DCS2103 (Strings)

Presentation

•

University

37 questions

SGBD

Presentation

•

University

25 questions

01 Python Basics

Presentation

•

University

32 questions

Pronouns 02 _ Síncrona

Presentation

•

University

35 questions

Μάσκα δικτύου, Διευθύνσεις δικτύου & Εκπομπής

Presentation

•

12th Grade

35 questions

LITERASI

Presentation

•

KG - University

Popular Resources on Wayground

6 questions

Secondary Safety Quiz

Presentation

•

9th - 12th Grade

10 questions

Afterschool Activities & Sports

Quiz

•

6th - 8th Grade

19 questions

ROAR Week 2026

Quiz

•

9th - 12th Grade

20 questions

Lab Safety Quiz

Quiz

•

6th Grade

15 questions

Cool Tool:Chromebook

Quiz

•

6th - 8th Grade

22 questions

would you rather

Quiz

•

3rd - 11th Grade

21 questions

Continents and Oceans

Quiz

•

6th Grade

20 questions

Parts of Speech

Quiz

•

5th Grade

Discover more resources for Computers

12 questions

Academic Integrity

Presentation

•

University

20 questions

IR Writing 201

Quiz

•

University

20 questions

Disney Trivia

Quiz

•

University

40 questions

Famous Logos

Quiz

•

7th Grade - University

4 questions

Benefits of Saving

Quiz

•

5th Grade - University

25 questions

USCB Policies and Procedures

Quiz

•

University

18 questions

Parent Functions

Quiz

•

9th Grade - University

20 questions

Empirical Rule Homwwork

Quiz

•

10th Grade - University