Save (Insert) DataGridView Rows to Database in Windows Forms Application Example

I have added a DataGridView and a Button to save in Form.

C# code:

public Form1()
        {
            InitializeComponent();
            this.PopulateDataGridview();
        }

        private void btnSave_Click(object sender, EventArgs e)
        {
            string branchName = string.Empty;
            string subBranchName = string.Empty;            
            foreach (DataGridViewRow row in this.dataGridView1.Rows)
            {
                branchName = row.Cells[0].Value.ToString();
                subBranchName = row.Cells[1].Value.ToString();
                this.Save(branchName, subBranchName);
            }
            MessageBox.Show("Data Added");
        }

        private void Save(string branchName, string subBranchName)
        {
            string conString = ConfigurationSettings.AppSettings["conString"];      
            string sqlStatment = "INSERT INTO Branches(BrachName,SubBranchName) VALUES(@BrachName,@SubBranchName)";
            using (SqlConnection con = new SqlConnection(conString))
            {
                using (SqlCommand cmd = new SqlCommand(sqlStatment, con))
                {                    
                    cmd.Parameters.AddWithValue("@BrachName", branchName);
                    cmd.Parameters.AddWithValue("@SubBranchName", subBranchName);
                    con.Open();
                    cmd.ExecuteNonQuery();
                    con.Close();
                }
            }
        }

        private void PopulateDataGridview()
        {
            DataTable dt = new DataTable();
            dt.Columns.AddRange(new DataColumn[2]{  
                            new DataColumn("BranchName", typeof(string)),  
                            new DataColumn("SubBranchName", typeof(string))  });
            dt.Rows.Add("Computers", "IT");
            dt.Rows.Add("Computers", "CS");
            dt.Rows.Add("Computers", "BSCIT");
            dt.Rows.Add("Mechanical", "Marine");
            dt.Rows.Add("Mechanical", "Aironotical");
            dt.Rows.Add("Mechanical", "Railways");
            this.dataGridView1.ColumnCount = 2;
            this.dataGridView1.Columns[0].Name = "Branch Name";
            this.dataGridView1.Columns[0].HeaderText = "BranchName";
            this.dataGridView1.Columns[0].DataPropertyName = "BranchName";
            this.dataGridView1.Columns[1].Name = "Sub Branch Name";
            this.dataGridView1.Columns[1].HeaderText = "SubBranchName";
            this.dataGridView1.Columns[1].DataPropertyName = "SubBranchName";
            this.dataGridView1.DataSource = dt;
            this.dataGridView1.AllowUserToAddRows = false;
        }

App.config:

<?xml version="1.0" encoding="utf-8" ?>
<configuration>
  <appSettings>
    <add key="conString" value="your Sql details" />
  </appSettings>  
</configuration>

Sql table:

CREATE TABLE [dbo].[Branches](
	[BrachName] [varchar](50) NULL,
	[SubBranchName] [varchar](50) NULL
) ON [PRIMARY]

GO

Image

Thank You.