private void saveToolStripButton_Click(object sender, EventArgs e) { int index = xtraTabControl_WORD_MNG_DETAY.SelectedTabPageIndex; if (index != -1) { var rtb = xtraTabControl_WORD_MNG_DETAY.TabPages[index].Controls[0]; DevExpress.XtraGrid.GridControl grd_ = (DevExpress.XtraGrid.GridControl)rtb; System.Data.DataView RW = (System.Data.DataView)grd_.DataSource; SqlConnection con = new SqlConnection(_GLOBAL_PARAMETRELER._CONNECTION_STRING.ToString()); con.Open(); if (RW != null) { TARIFELER._GLOBAL_TARIFELER WORD = new TARIFELER._GLOBAL_TARIFELER(); // SATIR SİL RW.RowStateFilter = DataViewRowState.Deleted; if (RW.Count != 0) { for (int i = 0; i <= RW.Count - 1; i++) { DataRow DR = RW[i].Row; WORD.KEYWORD_ROW_DELETE(con, DR, xtraTabControl_WORD_MNG_DETAY.SelectedTabPage.Name, xtraTabControl_WORD_MNG_DETAY.SelectedTabPage.Tag.ToString()); } } // Yeni eklenmiş Satırları kaydet RW.RowStateFilter = DataViewRowState.Added; if (RW.Count != 0) { for (int i = 0; i <= RW.Count - 1; i++) { DataRow DR = RW[i].Row; WORD.KEYWORD_ROW_ADD(con, DR, xtraTabControl_WORD_MNG_DETAY.SelectedTabPage.Name, xtraTabControl_WORD_MNG_DETAY.SelectedTabPage.Tag.ToString()); } } // SATIR GUNCELLE RW.RowStateFilter = DataViewRowState.ModifiedOriginal; if (RW.Count != 0) { for (int i = 0; i <= RW.Count - 1; i++) { DataRow DR = RW[i].Row; if (DR["ID"].ToString() == "") { WORD.KEYWORD_ROW_ADD(con, DR, xtraTabControl_WORD_MNG_DETAY.SelectedTabPage.Name, xtraTabControl_WORD_MNG_DETAY.SelectedTabPage.Tag.ToString()); } else { WORD.KEYWORD_ROW_UPDATE(con, DR, xtraTabControl_WORD_MNG_DETAY.SelectedTabPage.Name, xtraTabControl_WORD_MNG_DETAY.SelectedTabPage.Tag.ToString()); } } } RW.Table.AcceptChanges(); RW.RowStateFilter = DataViewRowState.CurrentRows; } } }