/C#/How to save datagridview data to database in c# windows application

How to save datagridview data to database in c# windows application

private void btn_Save_Click(object sender, EventArgs e)
{
    string constring = @"Data Source=databasename;Initial Catalog=Rookies;Integrated Security=True";
    SqlConnection con = new SqlConnection(constring);
    SqlTransaction transaction = con.BeginTransaction();
    try
    {
        con.Open();
        foreach (DataGridViewRow row in dataGridView1.Rows)
        {
            using (SqlCommand cmd = new SqlCommand("INSERT INTO tbl_prospects ([prospectid], [firstname], [lastname], [height], [weight], [age], [college])VALUES(@prospectid, @firstname, @lastname, @height, @weight, @age, @college)", con))
            {
                cmd.Parameters.AddWithValue("@prospectid", row.Cells["prospectid"].Value);
                cmd.Parameters.AddWithValue("@firstname", row.Cells["firstname"].Value);
                cmd.Parameters.AddWithValue("@lastname", row.Cells["lastname"].Value);
                cmd.Parameters.AddWithValue("@height", row.Cells["height"].Value);
                cmd.Parameters.AddWithValue("@weight", row.Cells["weight"].Value);
                cmd.Parameters.AddWithValue("@age", row.Cells["age"].Value);
                cmd.Parameters.AddWithValue("@college", row.Cells["college"].Value);
                cmd.Transaction = transaction;
                cmd.ExecuteNonQuery();
            }
        }
        transaction.Commit();
        con.Close();
        MessageBox.Show("Successfully Saved!");
    }
    catch (Exception ex)
    {
        transaction.Rollback();
        con.Close();
        MessageBox.Show(ex.Message);
    }
}

Source: stackoverflow.com

Similar codes

1 vote187 views1 answer
Unity raycast all layers except one
C#
0 vote252 views1 answer
Request ID: XPBBR4XG1UWuX6fWF08_-jzYkrommVJjO7Os50CTYuZmiw7kMsFUkw==
C#
3 votes155 views1 answer
C# post get request
C#
0 vote238 views1 answer
How to add rigidbody in unity
C#Unity
0 vote194 views1 answer
Unity 2D how to make top-down look controller
C#Unity
0 vote213 views1 answer
Unity2d switch camera
C#Unity
2 votes181 views2 answers
Rotation unity script 2d
C#
28 votes177 views2 answers
Unity switch
C#Unity
1 vote153 views1 answer
C# read text file separated by comma
C#
0 vote187 views4 answers
C# code to check anagram
C#