private void button1_Click(object sender, EventArgs e)
        {
            DataRowView drow, drow2;
            DataRow row;
            DataView view;
            DataTable dtNormRecIsu = new System.Data.DataTable("NormRecIsu");
            SqlDataAdapter daNormRecIsu = new SqlDataAdapter("select ID, PARTY, MATERIALR3, ID_NORM from NormRecIsu", FLogin.conn);
            SqlCommandBuilder cb = new SqlCommandBuilder(daNormRecIsu);            
            
            drow = (DataRowView)gridView1.GetFocusedRow();
            drow2 = (DataRowView)gridView3.GetFocusedRow();
          //  MessageBox.Show(dtNormRecIsu.Columns[1].ColumnName);
            view = new DataView(dtNormRecIsu);

            daNormRecIsu.Fill(dtNormRecIsu);
           
            row  = dtNormRecIsu.NewRow();

            row["PARTY"] = drow2["Party"];
            row["MATERIALR3"] = drow2["MaterialR3"];
            row["ID_NORM"] = drow["ID_norm"];
            dtNormRecIsu.Rows.Add(row);
    
            dgRecode.DataSource = view;
  
            dgRecode.Refresh();
          
            daNormRecIsu.Update(dtNormRecIsu);

        }