DATABASE SQL

To connect multiple buttons to a database in a C# application, you can follow these steps:

1. Set Up Your Database Connection: Ensure you have a connection string to your database. This string contains the information needed to connect to your database, such as the server name, database name, user ID, and password.

2. Create Event Handlers for Your Buttons: Each button should have an event handler that will execute when the button is clicked. In these event handlers, you can write the code to interact with the database.

3. Use ADO.NET to Interact with the Database: ADO.NET provides classes to connect to a database, execute commands, and retrieve data. You can use SqlConnection, SqlCommand, and other related classes to perform database operations.

Here’s an example to illustrate how you can connect multiple buttons to a database in a C# Windows Forms application:

using System;
using System.Data;
using System.Data.SqlClient;
using System.Windows.Forms;

public partial class MainForm : Form
{
    private string connectionString = "your_connection_string_here";

    public MainForm()
    {
        InitializeComponent();
    }

    private void btnInsert_Click(object sender, EventArgs e)
    {
        using (SqlConnection connection = new SqlConnection(connectionString))
        {
            string query = "INSERT INTO YourTable (Column1, Column2) VALUES (@Value1, @Value2)";
            using (SqlCommand command = new SqlCommand(query, connection))
            {
                command.Parameters.AddWithValue("@Value1", textBox1.Text);
                command.Parameters.AddWithValue("@Value2", textBox2.Text);

                connection.Open();
                command.ExecuteNonQuery();
                MessageBox.Show("Data inserted successfully.");
            }
        }
    }

    private void btnUpdate_Click(object sender, EventArgs e)
    {
        using (SqlConnection connection = new SqlConnection(connectionString))
        {
            string query = "UPDATE YourTable SET Column1 = @Value1 WHERE Column2 = @Value2";
            using (SqlCommand command = new SqlCommand(query, connection))
            {
                command.Parameters.AddWithValue("@Value1", textBox1.Text);
                command.Parameters.AddWithValue("@Value2", textBox2.Text);

                connection.Open();
                command.ExecuteNonQuery();
                MessageBox.Show("Data updated successfully.");
            }
        }
    }

    private void btnDelete_Click(object sender, EventArgs e)
    {
        using (SqlConnection connection = new SqlConnection(connectionString))
        {
            string query = "DELETE FROM YourTable WHERE Column1 = @Value1";
            using (SqlCommand command = new SqlCommand(query, connection))
            {
                command.Parameters.AddWithValue("@Value1", textBox1.Text);

                connection.Open();
                command.ExecuteNonQuery();
                MessageBox.Show("Data deleted successfully.");
            }
        }
    }

    private void btnSelect_Click(object sender, EventArgs e)
    {
        using (SqlConnection connection = new SqlConnection(connectionString))
        {
            string query = "SELECT * FROM YourTable WHERE Column1 = @Value1";
            using (SqlCommand command = new SqlCommand(query, connection))
            {
                command.Parameters.AddWithValue("@Value1", textBox1.Text);

                connection.Open();
                using (SqlDataReader reader = command.ExecuteReader())
                {
                    if (reader.HasRows)
                    {
                        while (reader.Read())
                        {
                            // Process the data
                            MessageBox.Show($"Column1: {reader["Column1"]}, Column2: {reader["Column2"]}");
                        }
                    }
                    else
                    {
                        MessageBox.Show("No data found.");
                    }
                }
            }
        }
    }
}

 

In this example:

• btnInsert_Click: Inserts data into the database.
• btnUpdate_Click: Updates data in the database.
• btnDelete_Click: Deletes data from the database.
• btnSelect_Click: Selects and displays data from the database.

Each button click event handler uses SqlConnection to connect to the database, SqlCommand to execute SQL queries, and SqlDataReader to read data from the database.

Thanks