CRUD Operation and SQL App using C# with Source Code

Submitted by Abdul Wahab on Saturday, April 17, 2021 - 10:40.

Language

This is a simple Source Code called CRUD Operation with Search in C# and SQL. This simple prohram will help you to learn how create a C# program that has a Create, Read, Update and Delete features with Search data. The source code itself uses only a single form where the said operation/feature can be done.

Controls & Database

The below list are the controls I have used.

Forms
TextBox
Label
Button
ComboBox
DataGridView

I have created a test database in my SQL Server and created a "Register" Table as the storage of the data. The following list are the columns inside the Register Table.

id
Name
Salery
Age
Gender
Tax

Interface

The image presented below the interface I created for this simple program.

Scripts

The following scripts/code are ones I have used to manage the data.

Database Connection

SqlConnection conn = new SqlConnection(@"Data Source=DESKTOP-2LLV29I\MSSQLSERVER01;Initial Catalog=test1;Integrated Security=True");

Save to Database

 private void btnsave_Click(object sender, EventArgs e)
{
 
    if (txtid.Text == "" || txtname.Text == "" || txtsalery.Text == "" || txttax.Text == "" || txtage.Text == "" || comboBox1.Text == "")
        {
            MessageBox.Show("please fill the cell first");
        }
        else
        {
            conn.Open();
            SqlDataAdapter sda = new SqlDataAdapter("insert into Register(id,name,gender,salery,age,tax)values('" + txtid.Text + "','" + txtname.Text + "','" + comboBox1.Text + "','" + txtsalery.Text + "','" + txtage.Text + "','" + txttax.Text + "')", conn);
 
            sda.SelectCommand.ExecuteNonQuery();
            conn.Close();
            MessageBox.Show("data entered succesfully. . . .");
            panel1.Enabled = false;
 
        }
 
}

View Data

private void load_data()
{
    conn.Open();
    SqlDataAdapter sda = new SqlDataAdapter("select * from Register", conn);
    DataTable data = new DataTable();
    sda.Fill(data);
    dataGridView1.DataSource = data;
    conn.Close();
}

Update Data

private void btnUpdate_Click(object sender, EventArgs e)
{
    if (panel1.Enabled == true)
    {
 
        if (txtid.Text == "" || txtname.Text == "" || txtsalery.Text == "" || txttax.Text == "" || txtage.Text == "" || comboBox1.Text == "")
        {
            MessageBox.Show("please fill the cell first");
        }
        else
        {
            conn.Open();
            SqlDataAdapter sda = new SqlDataAdapter("UPDATE Register SET id ='" + txtid.Text + "',name = '" + txtname.Text + "',Gender = '" + comboBox1.Text + "', Salery = '" + txtsalery.Text + "',age = '" + txtage.Text + "',tax = '" + txttax.Text + "' where id ='" + txtid.Text + "'", conn);
 
            sda.SelectCommand.ExecuteNonQuery();
            conn.Close();
            MessageBox.Show("data updated succesfully. . . .");
            load_data();
            panel1.Enabled = false;
        }
 
    }
    else
    {
        MessageBox.Show("please select what you want to update");
    }
 
}

Delete Data

private void btndelete_Click(object sender, EventArgs e)
{
    if (panel1.Enabled == true)
    {
 
        if (txtid.Text == "" || txtname.Text == "" || txtsalery.Text == "" || txttax.Text == "" || txtage.Text == "" || comboBox1.Text == "")
        {
            MessageBox.Show("please select the record");
        }
        else
        {
            conn.Open();
            SqlDataAdapter sda = new SqlDataAdapter("delete from Register where id ='" + txtid.Text + "'", conn);
 
            sda.SelectCommand.ExecuteNonQuery();
            conn.Close();
            MessageBox.Show("data deleted succesfully. . . .");
            load_data();
            panel1.Enabled = false; 
        }
 
    }
    else
    {
        MessageBox.Show("please select the record first");
    }
 
}

The source code is free to download. Feel Free to download the source code to understand more about how does the program work.

How to Run

Requirements

Download and Install Microsoft Visual Studio Software/li>
Download and Install Microsoft SQL Server Express

Download and Install SQL Server Management Studio

Installation/Setup

Download and Extract the source code zip file. (download button is located the below)
Locate the MDF File in the extracted source code folder. The file is known as "test1.mdf".
Open your SQL Server Management Studio Software and connect to a server.
Attach the MDF file in the database.
Locate the solution file in the extracted source code folder. The file is known as "Data_Entry.sln".
Open the solution file with your MS Visual Studio software.
Configure the SqlConnection according to your database connection string.
Press the "F5" key to start the program.

Demo

That's it! I hope this CRUD (Create, Read, Update, and Delete) with Search Program in C# and SQL will help you to develop your programming skills.

Enjoy :)

Note: Due to the size or complexity of this submission, the author has submitted it as a .zip file to shorten your download time. After downloading it, you will need a program like Winzip to decompress it.

Virus note: All files are scanned once-a-day by SourceCodester.com for viruses, but new viruses come out every day, so no prevention program can catch 100% of them.

FOR YOUR OWN SAFETY, PLEASE:

1. Re-scan downloaded files using your personal virus checker before using it.
2. NEVER, EVER run compiled files (.exe's, .ocx's, .dll's etc.)--only run source code.