How to Save And Retrieve Data with SQL Server and C#

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 Save And Retrieve Data with SQL Server and C#

saveandretrievePIIn this tutorial, I will teach you how to save and retrieve data with SQL Server Management Studio Express 2005 database and C#.net. With this, you can save and retrieve data in the database to the datagridview. I will use here Microsoft Visual Studio 2008 for creating this application.

Let’s begin:

  • Create a database and name it “userdb”.
  • Open Microsoft Visual Studio 2008 and create new Windows Form Application.
  • Do the Form as follows.

saveandretrievePIfig.1

  • Double click the Form and do the following codes for connecting SQL server to C#.

Note: Put using System.Data.SqlClient; above the namespace to access sql server library.

//initialize all classes
 SqlConnection conn = new SqlConnection();
 SqlCommand cmd = new SqlCommand();
 SqlDataAdapter da = new SqlDataAdapter();
 DataTable dt = new DataTable();

private void Form1_Load(object sender, EventArgs e)
 {
 //connection between sql server to c#
 con.ConnectionString = "Data Source=.\\SQLEXPRESS;Database=cruddb;trusted_connection=true;";
 }

  • Go back to the design view and double click the “Save” button. After that, do the following codes for saving data in the database.
private void btnsave_Click(object sender, EventArgs e)
 {
 try
 {
 //opening connection
 con.Open();
 //create an insert query;
 string query = "INSERT INTO tbluser (NAME,UNAME,PASS,UROLE) VALUES('" + txtname.Text + "','" + txtuname.Text + "','" + txtpass.Text + "','" + cboRole.Text + "')";
 //it holds the data to be executed.
 cmd.Connection = con;
 cmd.CommandText = query;
 //execute the data.
 int result = cmd.ExecuteNonQuery();
 //validate if the result of the executed query.
 if (result > 0)
 {

MessageBox.Show("Data has been saved in the SQL database");

}
 else
 {
 MessageBox.Show("SQL QUERY ERROR");
 }
 //closing connection
 con.Close();

}
 catch (Exception ex)//catch exeption
 {
 //displaying error message.
 MessageBox.Show(ex.Message);
 }
 }
  • Go back to the design view an double click the “Load” button. After that, do the following codes for retrieving data in the database to the datagridview.
private void btnLoad_Click(object sender, EventArgs e)
 {
 try
 {
 con.Open();
 //create a query for retrieving data in the database.
 string query = "SELECT ID as 'Id',NAME as 'Name',UNAME as 'Username', UROLE as 'Role' FROM tbluser";
 //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);
 //set the data that to be display in the datagridview
 dataGridView1.DataSource = dt;

}
 catch (Exception ex)
 {
 MessageBox.Show(ex.Message);
 }
 finally
 {
 da.Dispose();
 con.Close();
 }
 }
  • Finally, press F5 on the keyboard to run your project in the computer.

Output:

saveandretrievePI

For all students who need programmer for your thesis system or anyone who needs a sourcecode in any programming languages. You can contact me @ :

Email – jannopalacios@gmail.com
Mobile No. – 09305235027 – tnt

Download retired

Frequently Asked Questions

What does this C# code snippet demonstrate?

Focused C# WinForms code pattern: how to add, insert, save, search, display, print, or connect to SQL Server with minimum code. Drop-in pattern you can adapt for your own capstone module.

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.

Leave a Comment