Download retired
The original archive for this project is no longer available for direct download. These archives were published as educational reference material and are not actively maintained. We removed the download rather than keep distributing material we no longer support.
The full tutorial, screenshots, database structure, and feature documentation on this page remain accurate as a reference for building your own version. Full editorial position at the source code disclaimer. Questions: support@itsourcecode.com.
How to Delete and Retrieve Data in C# and SQL Server 2005
This time, I will teach you how to delete and retrieve the data in C#.net and SQL server 2005. Deleting records are not advisable to a system, however, in developing a system, you have to put a “delete” method so that, it will be easy for you to remove whatever data that you have saved in the database for the input testing.
So, let’s get started:
- Create a database and name it “testdb”.
- Open Microsoft Visual Studio and create new Windows Form Application.
- Do the Form as follows.
- Go to the Solution Explorer, click the “View Code” to display the code editor.
- Declare all the classes and variable that are needed.
//initialize all classes SqlConnection con = new SqlConnection(); SqlCommand cmd = new SqlCommand(); SqlDataAdapter da = new SqlDataAdapter(); DataTable dt = new DataTable(); //Declare a variable string query; int result;
Note: Put using System.Data.SqlClient; above the namespace to access sql server library.
- Go back to the design view, double-click the Form and do the following codes for the connection between C# and SQL server.
private void Form1_Load(object sender, EventArgs e)
{
//connection between sql server to c#
con.ConnectionString = "Data Source=.\\SQLEXPRESS;Database=testdb;trusted_connection=true;";
//calling a retrieve method
retrievedtg();
}- Create a method for retrieving the records in the database to the DataGridView.
private void retrievedtg()
{
try
{
//create a query for retrieving data in the database.
query = "SELECT * FROM tbltest";
//initialize new Sql commands
cmd = new SqlCommand();
//hold the data to be executed.
cmd.Connection = con;
cmd.CommandText = query;
//initialize new Sql data adapter
da = new SqlDataAdapter();
//fetching query in the database.
da.SelectCommand = cmd;
//initialize new datatable
dt = new DataTable();
//refreshes the rows in specified range in the datasource.
da.Fill(dt);
//Get and set the data source of a Datagridview
dataGridView1.DataSource = dt;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
da.Dispose();
}
}- Go back to the design view, double-click a button and do the following codes for deleting the records in the SQL database.
private void button1_Click(object sender, EventArgs e)
{
try
{
//opening connection
con.Open();
//create a delete query;
query = "DELETE FROM tbltest WHERE ID=" + dataGridView1.CurrentRow .Cells[0].FormattedValue ;
//it holds the data to be executed.
cmd.Connection = con;
cmd.CommandText = query;
//execute the data.
int result = cmd.ExecuteNonQuery();
//validate the result of the executed query.
if (result > 0)
{
MessageBox.Show("Data has been deleted in the SQL database");
//calling a retrieve method
retrievedtg();
}
else
{
MessageBox.Show("SQL QUERY ERROR");
}
//closing connection
con.Close();
}
catch (Exception ex)//catch exeption
{
//displaying error message.
MessageBox.Show(ex.Message);
}
}Output:
For all students who need a programmer for your thesis system or anyone who needs a source code in any programming languages. You can contact me @ :
Email – jannopalacios@gmail.com
Mobile No. – 09305235027 – tnt
| ABOUT PROJECT | PROJECT DETAILS |
|---|---|
| Project Name : | How to Delete and Retrieve Data in C# and SQL Server 2005 |
| Project Platform : | C# |
| Programming Language Used: | C# Programming Language |
| Developer Name : | itsourcecode.com |
| IDE Tool (Recommended): | Visual Studio 2019 |
| Project Type : | Desktop Application |
| Database: | MySQL Database |
| Upload Date and Time: | June 13, 2016- 6:59 am |
Frequently Asked Questions
How does this C# project work?
Built with C# WinForms (.NET Framework or .NET 6/7/8) and SQL Server backend. Standard structure: Form designer → code-behind event handlers → ADO.NET data access layer → SQL Server. Login form for auth. Ready to extend for BSIT capstone scope.
What .NET and SQL Server versions does this project require?
Most projects in this batch use C# WinForms on .NET Framework 4.5+ (the dominant stack for tutorial sites) with SQL Server 2012 Express or higher. A few newer projects use .NET 6/7/8. To run: install Visual Studio 2019 / 2022 (Community edition is free), install SQL Server Express + SSMS, open the .sln file, build, run.
How do I set up the database for this C# project?
Open SQL Server Management Studio (SSMS) and connect to your SQL Server instance (e.g. localhost\SQLEXPRESS). Right-click Databases > Restore Database OR > New Database then import the included .sql script. Update the connection string in App.config (or in code-behind) with your server name + credentials. Rebuild and run.
Can I use this C# project for a BSIT capstone or thesis?
Yes, but extend it. A bare CRUD form is too narrow for full capstone scope. Add: role-based access (admin/staff/customer login redirect), Crystal Reports or RDLC reports, dashboard with Chart controls, audit log, multi-branch support. Pair with Chapter 1-5 documentation matching your panel’s rubric.
Why am I getting ‘connection error’ or ‘object reference not set’?
Three common C# issues: (1) Connection error: SQL Server isn’t running OR connection string in App.config has wrong server name. Open SQL Server Configuration Manager + verify SQL Server (SQLEXPRESS) service is running. (2) NullReferenceException: a control reference or DB column returned NULL, add a check or use ?? operator. (3) Build error ‘The type or namespace could not be found’: missing assembly reference, add via Project > Add Reference.
Where can I find more C# projects with source code?
Browse the C# Projects hub for the full library. For other .NET stacks see VB.NET Projects (300+ Windows Forms systems). For ASP.NET WebForms see ASP.NET Projects. For BSIT capstone idea lists see 150 Best Capstone Project Ideas.


