This article is based on the original article that was previously written using an older version of Visual Studio. You can find the original article on the below link:
Step 1: Make a database with a table in SQL Server.
1
Figure 1
Step 2: Create a Windows Application and add DataGridView on the Form. Now add a DataGridView control to the form by selecting it from Toolbox and set properties according to your needs.
2
Figure 2
Adding Source Code for GridView
Now you can add these few lines of code anywhere you want to load the data from the database. It may be a mouse button click or the Form load event handler.
  1. private void Form1_Load(object sender, EventArgs e) {
  2. SqlDataAdapter da = new SqlDataAdapter("SELECT * FROM Student", "server = MCNDESKTOP33; database = Avinash; UID = sa; password = *******");
  3. DataSet ds = new DataSet();
  4. da.Fill(ds, "Student");
  5. dataGridView1.DataSource = ds.Tables["Student"].DefaultView;
  6. }
Step 3: Code for the Save and Reset button
  1. using System;
  2. using System.Collections.Generic;
  3. using System.ComponentModel;
  4. using System.Data;
  5. using System.Drawing;
  6. using System.Linq;
  7. using System.Text;
  8. using System.Threading.Tasks;
  9. using System.Windows.Forms;
  10. using System.Data.SqlClient;
  12. namespace WindowsFormsDataGrid {
  14. public partial class Form1: Form {
  16. public Form1() {
  17. InitializeComponent();
  18. }
  20. private void Form1_Load(object sender, EventArgs e) {
  21. SqlDataAdapter da = new SqlDataAdapter("SELECT * FROM Student", "server = MCNDESKTOP33; database = Avinash; UID = sa; password = *******");
  22. DataSet ds = new DataSet();
  23. da.Fill(ds, "Student");
  24. dataGridView1.DataSource = ds.Tables["Student"].DefaultView;
  25. }
  27. private void button1_Click(object sender, EventArgs e) {
  28. SqlConnection con = new SqlConnection("server = MCNDESKTOP33; database = Avinash; UID = sa; password = *******");
  29. con.Open();
  30. string qur = "INSERT INTO Student VALUES ('" + textBox1.Text + "','" + textBox2.Text + "','" + textBox3.Text + "','" + textBox4.Text + "')";
  32. SqlCommand cmd = new SqlCommand(qur, con);
  33. cmd.ExecuteNonQuery();
  34. con.Close();
  35. MessageBox.Show("Inserted sucessfully");
  36. textBox1.Text = "";
  37. textBox2.Text = "";
  38. textBox3.Text = "";
  39. textBox4.Text = "";
  40. }
  42. private void button2_Click(object sender, EventArgs e) {
  43. textBox1.Text = "";
  44. textBox2.Text = "";
  45. textBox3.Text = "";
  46. textBox4.Text = "";
  48. }
  49. }
  50. }
Output: The contents of DataGridView look as in the below figure.
Figure 3
3
How to Run
Add using System.Data.SqlClient; namespace in your project.
Change the database path in this string. "server = MCNDESKTOP33; database = Avinash; UID = sa; password = *******"
Run the application.
To read other articles based on the same DataGridView application functionality, please click on the below references link: