private void metroButton2_Click(object sender, EventArgs e) { try { if (metroTextBox1.Text == "" || metroGrid1.Rows[0].Cells["Tag Name"].Value.ToString() == "" || metroGrid1.Rows[0].Cells["Tag Value"].Value.ToString() == "") { CheckEmpty(); } else { DialogResult f = MetroMessageBox.Show(this, "Are you sure to save?", "WSH notify", MessageBoxButtons.OKCancel, MessageBoxIcon.Information); if (f == DialogResult.OK) { access_data d = new access_data(); site s = new site(); s.url = metroTextBox1.Text; s.description = textBox1.Text; int site_id = d.InsertNweUrlData(s); int i = metroGrid1.Rows.Count; SqlDbDataAccess dr = new SqlDbDataAccess(); for (int j = 0; j < i; j++) { using (SqlCommand cmd = dr.GetCommand("insert into dbo.site_details (site_id,tag_name,tag_value) values(@site_id,@tag_name,@tag_value);")) { SqlParameter p = new SqlParameter("@site_id", SqlDbType.Int); p.Value = site_id; SqlParameter p1 = new SqlParameter("@tag_name", SqlDbType.VarChar, 200); p1.Value = metroGrid1.Rows[j].Cells["Tag Name"].Value.ToString(); SqlParameter p2 = new SqlParameter("@tag_value", SqlDbType.VarChar, 500); p2.Value = metroGrid1.Rows[j].Cells["Tag Value"].Value.ToString(); cmd.Parameters.Add(p); cmd.Parameters.Add(p1); cmd.Parameters.Add(p2); cmd.Connection.Open(); cmd.ExecuteNonQuery(); cmd.Connection.Close(); } } MetroMessageBox.Show(this, "Data successfully Saved", "", MessageBoxButtons.OK, MessageBoxIcon.Information); metroTextBox1.Text = ""; metroTextBox2.Text = ""; textBox1.Text = ""; textBox2.Text = ""; metroGrid1.DataSource = null; } } } catch (System.ArgumentOutOfRangeException) { CheckEmpty(); } }