Database and datagrid

[rody9]

private void btnSaveinDB_Click_1(object sender, EventArgs e)
        {
            if (conn.State == ConnectionState.Open)
            {
                conn.Close();
            }
 
            try
            {
             int i = 0;
             if (dgvfareaudit.Rows[i].Cells[2].Value == DBNull.Value)
                {
                  MessageBox.Show("Datagrid is empty!");
                }
 
                dap.InsertCommand = new SqlCommand("INSERT INTO dbo.fare_table(fromsector,sectorto,farebasis) VALUES('" +
                dgvfareaudit.Rows[i].Cells["fromsector"].Value.ToString() + "','" +
                dgvfareaudit.Rows[i].Cells["sectorto"].Value.ToString() + "','" +
                dgvfareaudit.Rows[i].Cells["farebasis"].Value.ToString() + "','" +
                dgvfareaudit.Rows[i].Cells["owrt"].Value.ToString() + "','" +
                dgvfareaudit.Rows[i].Cells["currencycode"].Value.ToString() + "','" +
                dgvfareaudit.Rows[i].Cells["lcf"].Value.ToString() + "','" +
                dgvfareaudit.Rows[i].Cells["nuc"].Value.ToString() + "','" +
                dgvfareaudit.Rows[i].Cells["carriercode"].Value.ToString() + "','" +
                dgvfareaudit.Rows[i].Cells["rule"].Value.ToString() + "','" +
                dgvfareaudit.Rows[i].Cells["mpm"].Value.ToString() + "','" +
                dgvfareaudit.Rows[i].Cells["gi"].Value.ToString() + "','" +
                dgvfareaudit.Rows[i].Cells["frbd"].Value.ToString() + "','" +
                dgvfareaudit.Rows[i].Cells["svf"].Value.ToString() + "','" +
                dgvfareaudit.Rows[i].Cells["svt"].Value.ToString() + "','" +
                dgvfareaudit.Rows[i].Cells["fvf"].Value.ToString() + "','" +
                dgvfareaudit.Rows[i].Cells["fvt"].Value.ToString() + "','" +
                dgvfareaudit.Rows[i].Cells["primecode"].Value.ToString() + "','" +
                dgvfareaudit.Rows[i].Cells["seasonalcode"].Value.ToString() + "','" +
                dgvfareaudit.Rows[i].Cells["pow"].Value.ToString() + "','" +
                dgvfareaudit.Rows[i].Cells["pod"].Value.ToString() + "','" +
                dgvfareaudit.Rows[i].Cells["fptc"].Value.ToString() + "','" +
                dgvfareaudit.Rows[i].Cells["fli"].Value.ToString() + "')",conn);
                //}
                conn.Open();
                //dap.InsertCommand.Connection = conn;
                ////dap.InsertCommand.CommandText = SqlSelect;
                //dap.InsertCommand.CommandTimeout = 0;
                //dap.InsertCommand = new SqlCommand(SqlSelect, conn);
                dap.InsertCommand.ExecuteNonQuery();
                MessageBox.Show("Record Successfully Saved", "Symphony", MessageBoxButtons.OK, MessageBoxIcon.Information);
 
 
                conn.Close();
 
 
 
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
            finally
            {
                conn.Close();
            }
        }

[rody9]

In fact I want to know how to save data from datagrid to database