public void SpecifyNonExistentTable() { DataViewManager m = new DataViewManager(null); // NullReferenceException is thrown. m.DataViewSettingCollectionString = "<DataViewSettingCollectionString><table1-1 RowFilter='a=b' /></DataViewSettingCollectionString>"; }
private void LlenarGridConsulta() { DgvMaterias.Columns.Clear(); DgvMaterias.OptionsView.ColumnAutoWidth = false; DataViewManager dvm = new DataViewManager(dsConsulta); DataView dvMain = dvm.CreateDataView(dsConsulta.Tables[0]); DgvMaterias.OptionsBehavior.AutoPopulateColumns = false; GctrlMaterias.DataSource = dvMain; string[] captions = new[] { "CodigoProfesor", "Area", "CodMateria", "Materia" }; GridColumn[] col = new GridColumn[dsConsulta.Tables[0].Columns.Count]; for (int i = 0; i < dsConsulta.Tables[0].Columns.Count; i++) { col[i] = DgvMaterias.Columns.AddField(dsConsulta.Tables[0].Columns[i].Caption.Trim()); col[i].VisibleIndex = i; col[i].Caption = captions[i]; col[i].AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center; if (i == 0 || i == 2) { col[i].Visible = false; } } DgvMaterias.Columns[1].Width = 300; DgvMaterias.Columns[3].Width = 255; Funciones.getInstancia().Configurar_Grid(DgvMaterias); DgvMaterias.OptionsCustomization.AllowSort = true; //DgvMaterias.OptionsFind.AlwaysVisible = true; DgvMaterias.OptionsView.ColumnAutoWidth = false; }
private void DATA_LOAD() { string SQL = @" select * from TIME_TABLE "; //DateTime dtOne = Convert.ToDateTime(dtTmPckrBasTar.EditValue); Date_One = dtOne.ToString("yyyy-MM-dd 00:00:00", DateTimeFormatInfo.InvariantInfo); //DateTime dtTwo = Convert.ToDateTime(dtTmPckrBitTar.EditValue); Date_Two = dtTwo.ToString("yyyy-MM-dd 00:00:00", DateTimeFormatInfo.InvariantInfo); using (SqlConnection Conn = new SqlConnection(_GLOBAL_PARAMETERS._CONNECTIONSTRING_MDB.ToString())) // and (dbo.TODO_TIME_SHEET.MAIL_ADRESI=@MAIL_ADRESI) { using (SqlDataAdapter da = new SqlDataAdapter(SQL, Conn)) { //da.SelectCommand.Parameters.AddWithValue("@SIRKET_KODU", _GLOBAL_PARAMETERS._SIRKET_KODU); //da.SelectCommand.Parameters.AddWithValue("@MAIL_ADRESI", _GLOBAL_PARAMETERS._KULLANICI_MAIL); //da.SelectCommand.Parameters.AddWithValue("@StartDate", Date_One); //da.SelectCommand.Parameters.AddWithValue("@EndDate", Date_Two); using (DataSet dtSet = new DataSet()) { da.Fill(dtSet, "ADM_MUSTERI"); using (DataViewManager dvManager = new DataViewManager(dtSet)) { DataView dv = dvManager.CreateDataView(dtSet.Tables[0]); TIME_SHEET_PIVOT.DataSource = dv; } } } } }
public void DataViewManager() { DataView dv = null; DataViewManager dvm = null; DataSet ds = new DataSet(); DataTable dt = new DataTable("myTable"); ds.Tables.Add(dt); dv = dt.DefaultView; // public DataViewManager DataViewManager {get;} - The DataViewManager that created this view. // If this is the default DataView for a DataTable, the DataViewManager property returns the default DataViewManager for the DataSet. // Otherwise, if the DataView was created without a DataViewManager, this property is a null reference (Nothing in Visual Basic). dvm = dv.DataViewManager; Assert.AreSame(ds.DefaultViewManager, dvm, "DV114"); dv = new DataView(dt); dvm = dv.DataViewManager; Assert.IsNull(dvm, "DV115"); dv = ds.DefaultViewManager.CreateDataView(dt); Assert.AreSame(ds.DefaultViewManager, dv.DataViewManager, "DV116"); }
/// <summary> /// Método para llenar la cuadricula donde se visualizan los registros /// </summary> public void LlenarGrilla() { GvGeneral.Columns.Clear(); GvGeneral.OptionsView.ColumnAutoWidth = false; DataViewManager dvm = new DataViewManager(dsGeneral); DataView dvMain = dvm.CreateDataView(dsGeneral.Tables[0]); GridColumn[] col = new GridColumn[PerfilShow.Visibles.Length]; int index = 0; for (int i = 0; i < PerfilShow.Visibles.Length; i++) { index = Convert.ToInt32(PerfilShow.Indices[i]); col[index] = GvGeneral.Columns.AddField(dsGeneral.Tables[0].Columns[PerfilShow.CamposId[i]].Caption); col[index].VisibleIndex = index; //col[index].BestFit(); col[index].Width = PerfilShow.Tamaños[i].ToInt(); col[index].Caption = PerfilShow.Cabeceras[i]; col[index].AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center; } GctrlGeneral.DataSource = dvMain; if (GvGeneral.RowCount > 0) { GvGeneral.Focus(); GvGeneral.SelectRow(0); } }
public void LlenarGridConsulta2() { DgvAlumnos.Columns.Clear(); DgvAlumnos.OptionsView.ColumnAutoWidth = false; DataViewManager dvm = new DataViewManager(dsConsulta2); DataView dvMain = dvm.CreateDataView(dsConsulta2.Tables[0]); DgvAlumnos.OptionsBehavior.AutoPopulateColumns = false; GctrlAlumnos.DataSource = dvMain; string[] captions = new[] { "CodCurso", "CodigoAlum", "Alumno", "Carnet", "AñoElectivo" }; GridColumn[] col = new GridColumn[dsConsulta2.Tables[0].Columns.Count]; for (int i = 0; i < dsConsulta2.Tables[0].Columns.Count; i++) { col[i] = DgvAlumnos.Columns.AddField(dsConsulta2.Tables[0].Columns[i].Caption.Trim()); col[i].VisibleIndex = i; col[i].Caption = captions[i]; col[i].AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center; if (i == 0 || i == 1 || i == 4) { col[i].Visible = false; } } DgvAlumnos.Columns[2].Width = 250; DgvAlumnos.Columns[3].Width = 100; Funciones.getInstancia().Configurar_Grid(DgvAlumnos); DgvAlumnos.OptionsCustomization.AllowSort = true; //DgvMaterias.OptionsFind.AlwaysVisible = true; DgvAlumnos.OptionsView.ColumnAutoWidth = false; }
private void RAPOR_LIST_READ() { //string SQL = " SELECT dbo.ADM_GRUP_DAHIL_KULLANICILAR.FIRMA, dbo.ADM_GRUP_DAHIL_KULLANICILAR.EMAIL, dbo.ADM_GRUP_HAKLARI.RAPOR_KODU, dbo.ADM_RAPOR_DESIGNE.ACIKLAMA,dbo.ADM_RAPOR_DESIGNE.MECRA_TURLERI, dbo.ADM_RAPOR_DESIGNE.DURUMU " + //" FROM dbo.ADM_GRUP_DAHIL_KULLANICILAR INNER JOIN dbo.ADM_GRUP_HAKLARI ON dbo.ADM_GRUP_DAHIL_KULLANICILAR.GRUPLAR = dbo.ADM_GRUP_HAKLARI.GRUPLAR INNER JOIN " + //" dbo.ADM_RAPOR_DESIGNE ON dbo.ADM_GRUP_HAKLARI.RAPOR_KODU = dbo.ADM_RAPOR_DESIGNE.RAPOR_KODU " + //" GROUP BY dbo.ADM_GRUP_DAHIL_KULLANICILAR.FIRMA, dbo.ADM_GRUP_DAHIL_KULLANICILAR.EMAIL, dbo.ADM_GRUP_HAKLARI.RAPOR_KODU, dbo.ADM_GRUP_HAKLARI.FIRMA, " + //" dbo.ADM_RAPOR_DESIGNE.ACIKLAMA, dbo.ADM_RAPOR_DESIGNE.SIRKET_KODU,dbo.ADM_GRUP_HAKLARI.PAYLASIM_TURU,dbo.ADM_RAPOR_DESIGNE.MECRA_TURLERI, dbo.ADM_RAPOR_DESIGNE.DURUMU" + //" HAVING (dbo.ADM_GRUP_DAHIL_KULLANICILAR.EMAIL = N'" + _GLOBAL_PARAMETRELER._KULLANICI_MAIL + "') AND (dbo.ADM_GRUP_DAHIL_KULLANICILAR.FIRMA = N'" + _GLOBAL_PARAMETRELER._KULLANICI_FIRMA + "') AND (dbo.ADM_GRUP_HAKLARI.FIRMA = N'" + _GLOBAL_PARAMETRELER._KULLANICI_FIRMA + "') " + //" AND (dbo.ADM_RAPOR_DESIGNE.SIRKET_KODU = N'" + _GLOBAL_PARAMETRELER._KULLANICI_FIRMA + "') AND (dbo.ADM_GRUP_HAKLARI.PAYLASIM_TURU = N'RAPOR') " + //" UNION " + //" SELECT dbo.ADM_KULLANICI_HAKLARI.FIRMA, dbo.ADM_KULLANICI_HAKLARI.EMAIL, dbo.ADM_RAPOR_DESIGNE.RAPOR_KODU, dbo.ADM_RAPOR_DESIGNE.ACIKLAMA,dbo.ADM_RAPOR_DESIGNE.DURUMU ,dbo.ADM_RAPOR_DESIGNE.MECRA_TURLERI " + //" FROM dbo.ADM_RAPOR_DESIGNE INNER JOIN " + //" dbo.ADM_KULLANICI_HAKLARI ON dbo.ADM_RAPOR_DESIGNE.RAPOR_KODU = dbo.ADM_KULLANICI_HAKLARI.RAPOR_KODU " + //" GROUP BY dbo.ADM_RAPOR_DESIGNE.ACIKLAMA, dbo.ADM_RAPOR_DESIGNE.SIRKET_KODU, dbo.ADM_KULLANICI_HAKLARI.FIRMA, dbo.ADM_KULLANICI_HAKLARI.EMAIL, dbo.ADM_RAPOR_DESIGNE.RAPOR_KODU,dbo.ADM_KULLANICI_HAKLARI.PAYLASIM_TURU,dbo.ADM_RAPOR_DESIGNE.DURUMU,dbo.ADM_RAPOR_DESIGNE.MECRA_TURLERI " + //" HAVING (dbo.ADM_RAPOR_DESIGNE.SIRKET_KODU = N'" + _GLOBAL_PARAMETRELER._KULLANICI_FIRMA + "') AND (dbo.ADM_KULLANICI_HAKLARI.FIRMA = N'" + _GLOBAL_PARAMETRELER._KULLANICI_FIRMA + "') AND (dbo.ADM_KULLANICI_HAKLARI.EMAIL = N'" + _GLOBAL_PARAMETRELER._KULLANICI_MAIL + "') AND (dbo.ADM_KULLANICI_HAKLARI.PAYLASIM_TURU = N'RAPOR') " + //" UNION " + string SQL = " SELECT SIRKET_KODU, OWNER_MAIL, RAPOR_KODU, ACIKLAMA,MECRA_TURLERI,DURUMU FROM dbo.ADM_RAPOR_DESIGNE WHERE (SIRKET_KODU = N'" + _GLOBAL_PARAMETRELER._KULLANICI_FIRMA + "') AND (OWNER_MAIL = N'" + _GLOBAL_PARAMETRELER._KULLANICI_MAIL + "') order by RAPOR_KODU "; SqlConnection myConnection = new SqlConnection(_GLOBAL_PARAMETRELER._CONNECTION_STRING.ToString()); SqlDataAdapter da = new SqlDataAdapter(SQL, myConnection); DataSet ds = new DataSet(); da.Fill(ds, "stock"); DataViewManager dvManager = new DataViewManager(ds); DataView dv = dvManager.CreateDataView(ds.Tables[0]); gridControl_LISTE.DataSource = dv; }
private void SABIT_LISTE() { using (SqlConnection conn = new SqlConnection(_GLOBAL_PARAMETRELER._CONNECTION_STRING.ToString())) { DataSet ds = new DataSet(); string query = ""; if (rdBtn_MIX.Checked) { query = " SELECT MNM, ANA_YAYIN, CAST('02:00' AS nvarchar) AS BASLANGIC_SAATI, CAST(N'18:29' AS nvarchar) AS BITIS_SAATI, CAST('-' AS nvarchar) AS OPT_PT " + " FROM dbo._ADEX_INDEX_DATA " + " WHERE (YAYIN_SINIFI = N'TELEVIZYON') " + " GROUP BY MNM, ANA_YAYIN " + " UNION " + " SELECT MNM, ANA_YAYIN, CAST('18:30' AS nvarchar) AS BASLANGIC_SAATI, CAST(N'25:59' AS nvarchar) AS BITIS_SAATI, CAST('+' AS nvarchar) AS OPT_PT " + " FROM dbo._ADEX_INDEX_DATA " + " WHERE (YAYIN_SINIFI = N'TELEVIZYON') " + " GROUP BY MNM, ANA_YAYIN " + " ORDER BY ANA_YAYIN "; } if (rdBtn_OPT.Checked) { query = " SELECT MNM, ANA_YAYIN, CAST('02:00' AS nvarchar) AS BASLANGIC_SAATI, CAST(N'18:29' AS nvarchar) AS BITIS_SAATI, CAST('-' AS nvarchar) AS OPT_PT " + " FROM dbo._ADEX_INDEX_DATA " + " WHERE (YAYIN_SINIFI = N'TELEVIZYON') " + " GROUP BY MNM, ANA_YAYIN " + " ORDER BY ANA_YAYIN "; } if (rdBtn_PT.Checked) { query = " SELECT MNM, ANA_YAYIN, CAST('18:30' AS nvarchar) AS BASLANGIC_SAATI, CAST(N'25:59' AS nvarchar) AS BITIS_SAATI, CAST('+' AS nvarchar) AS OPT_PT " + " FROM dbo._ADEX_INDEX_DATA " + " WHERE (YAYIN_SINIFI = N'TELEVIZYON') " + " GROUP BY MNM, ANA_YAYIN " + " ORDER BY ANA_YAYIN "; } SqlDataAdapter adapter = new SqlDataAdapter(); adapter.SelectCommand = new SqlCommand(query, conn); adapter.Fill(ds, "dbo_ANA_YAYIN"); DataViewManager dvManager = new DataViewManager(ds); DataView dvLIST = dvManager.CreateDataView(ds.Tables[0]); gridControl_SABITLER.DataSource = dvLIST; } gridView_SABITLER.ShowFindPanel(); using (SqlConnection myConnections = new SqlConnection(_GLOBAL_PARAMETRELER._CONNECTION_STRING.ToString())) { string SQL = " SELECT top 0 * FROM dbo.TRF_TELEVIZYON_NONE_MEASURED "; SqlDataAdapter MySqlDataAdapter = new SqlDataAdapter(SQL, myConnections); DataSet ds = new DataSet(); MySqlDataAdapter.Fill(ds, "dbo_SELECTANA_YAYIN"); DataViewManager dvManager = new DataViewManager(ds); dv = dvManager.CreateDataView(ds.Tables[0]); gridControl_SECENEKLER.DataSource = dv; } }
private void setupGrip() { dsMain = new DataSet(); dsMain = VM.GetVoucherStructure(VoucherMasterId); dsMain.Tables[0].TableName = "VoucherMaster"; dsMain.Tables[1].TableName = "VoucherDetail"; dsMain.Tables[2].TableName = "FlagDC"; dsMain.Tables[3].TableName = "ChartOfAccounts"; dsMain.Tables[4].TableName = "BankVoucherDetail"; dsMain.Tables["VoucherMaster"].Columns["VoucherMasterId"].AutoIncrement = true; dsMain.Tables["VoucherMaster"].Columns["VoucherMasterId"].AutoIncrementSeed = -1; dsMain.Tables["VoucherMaster"].Columns["VoucherMasterId"].AutoIncrementStep = -1; dsMain.Tables["VoucherDetail"].Columns["VoucherDetailId"].AutoIncrement = true; dsMain.Tables["VoucherDetail"].Columns["VoucherDetailId"].AutoIncrementSeed = -1; dsMain.Tables["VoucherDetail"].Columns["VoucherDetailId"].AutoIncrementStep = -1; dsMain.Relations.Add("MasterRelation", dsMain.Tables["VoucherMaster"].Columns["VoucherMasterId"], dsMain.Tables["VoucherDetail"].Columns["VoucherMasterId"]); drMaster = dsMain.Tables["VoucherMaster"].NewRow(); dsMain.Tables["VoucherMaster"].Rows.Add(drMaster); dvm = new DataViewManager(dsMain); dvCOA = dvm.CreateDataView(dsMain.Tables["ChartOfAccounts"]); GCDetail.DataSource = dsMain.Tables["VoucherDetail"]; GridSetting(); }
private void SABIT_LISTE() { using (SqlConnection conn = new SqlConnection(_GLOBAL_PARAMETRELER._CONNECTION_STRING.ToString())) { DataSet ds = new DataSet(); string query = " SELECT MEDYA,ILI,UNITE,ADRES,GENISLIK,YUKSEKLIK,TOPLAM_ALAN,FREKANS,GUN_SAYISI FROM dbo.DATA_OUTDOOR_ADEX GROUP BY YAYIN_SINIFI, MEDYA,ILI,UNITE,ADRES,GENISLIK,YUKSEKLIK,TOPLAM_ALAN,FREKANS,GUN_SAYISI ORDER BY MEDYA "; SqlDataAdapter adapter = new SqlDataAdapter(); adapter.SelectCommand = new SqlCommand(query, conn); adapter.Fill(ds, "dbo_ANA_YAYIN"); DataViewManager dvManager = new DataViewManager(ds); DataView dvLIST = dvManager.CreateDataView(ds.Tables[0]); gridControl_SABITLER.DataSource = dvLIST; } gridView_SABITLER.ShowFindPanel(); using (SqlConnection myConnections = new SqlConnection(_GLOBAL_PARAMETRELER._CONNECTION_STRING.ToString())) { string SQL = " SELECT top 0 * FROM dbo.TRF_OUTDOOR "; SqlDataAdapter MySqlDataAdapter = new SqlDataAdapter(SQL, myConnections); DataSet ds = new DataSet(); MySqlDataAdapter.Fill(ds, "dbo_SELECTANA_YAYIN"); DataViewManager dvManager = new DataViewManager(ds); dv = dvManager.CreateDataView(ds.Tables[0]); gridControl_SECENEKLER.DataSource = dv; } }
public void LlenarGridConsulta2() { DgvGeneral.Columns.Clear(); DgvGeneral.OptionsView.ColumnAutoWidth = false; DataViewManager dvm = new DataViewManager(dsConsulta2); DataView dvMain = dvm.CreateDataView(dsConsulta2.Tables[0]); DgvGeneral.OptionsBehavior.AutoPopulateColumns = true; GctrlGeneral.DataSource = dvMain; DgvGeneral.Columns[0].Visible = false; DgvGeneral.Columns[1].BestFit(); DevExpress.XtraEditors.Repository.RepositoryItemTextEdit numerico2 = new DevExpress.XtraEditors.Repository.RepositoryItemTextEdit(); numerico2.Mask.EditMask = "n"; numerico2.Mask.UseMaskAsDisplayFormat = true; numerico2.Mask.MaskType = DevExpress.XtraEditors.Mask.MaskType.Numeric; for (int i = 2; i < DgvGeneral.Columns.Count - 1; i++) { DgvGeneral.Columns[i].ColumnEdit = numerico2; DgvGeneral.Columns[i].BestFit(); } Font fuenteNegrita = new Font("Tahoma", 8.25F, FontStyle.Bold); DgvGeneral.Columns[1].AppearanceCell.Font = fuenteNegrita; Funciones.getInstancia().Configurar_Grid(DgvGeneral); DgvGeneral.OptionsBehavior.Editable = false; DgvGeneral.OptionsCustomization.AllowSort = false; DgvGeneral.OptionsView.ColumnAutoWidth = false; DgvGeneral.OptionsCustomization.AllowGroup = true; DgvGeneral.OptionsView.ShowGroupPanel = false; }
private void DATA_LOAD() { string SQL = @" SELECT SIRKET_KODU, KULLANICI, ACIKLAMA, AY, SURE FROM dbo.TODO_TIME_SHEET_FKUL WHERE (SIRKET_KODU=@SIRKET_KODU) AND (ACIKLAMA=@ACIKLAMA) AND (YIL >=@StartDate) AND (YIL <=@EndDate ) "; using (SqlConnection Conn = new SqlConnection(_GLOBAL_PARAMETERS._CONNECTIONSTRING_MDB.ToString())) // and (dbo.TODO_TIME_SHEET.MAIL_ADRESI=@MAIL_ADRESI) { using (SqlDataAdapter da = new SqlDataAdapter(SQL, Conn)) { da.SelectCommand.Parameters.AddWithValue("@SIRKET_KODU", _GLOBAL_PARAMETERS._SIRKET_KODU); da.SelectCommand.Parameters.AddWithValue("@ACIKLAMA", dtMusteri.EditValue.ToString()); da.SelectCommand.Parameters.AddWithValue("@StartDate", BR_YIL.EditValue.ToString()); da.SelectCommand.Parameters.AddWithValue("@EndDate", BR_YIL.EditValue.ToString()); using (DataSet dtSet = new DataSet()) { da.Fill(dtSet, "ADM_MUSTERI"); using (DataViewManager dvManager = new DataViewManager(dtSet)) { DataView dv = dvManager.CreateDataView(dtSet.Tables[0]); TIME_SHEET_PIVOT.DataSource = dv; } } } } }
static DataViewManager Read(string connStr, string queryExpression, out string message) { message = ""; DataViewManager dataView = DataContext.DbExecuteReader(connStr, queryExpression, out message); return(dataView); }
public void LlenarGridConsulta() { DgvGeneral.Columns.Clear(); DataViewManager dvm = new DataViewManager(dsConsulta); DataView dvMain = dvm.CreateDataView(dsConsulta.Tables[0]); DgvGeneral.OptionsBehavior.AutoPopulateColumns = false; GctrlGeneral.DataSource = dvMain; string[] captions = new[] { "Id", "IdPersona", "Código", "Nombre Usuario", "Contraseña", "CodTipoUsuario", "Tipo Usuario" }; GridColumn[] col = new GridColumn[dsConsulta.Tables[0].Columns.Count]; for (int i = 0; i < dsConsulta.Tables[0].Columns.Count; i++) { col[i] = DgvGeneral.Columns.AddField(dsConsulta.Tables[0].Columns[i].Caption.Trim()); col[i].VisibleIndex = i; col[i].Caption = captions[i]; col[i].AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center; if (i == 0 || i == 1 || i == 4 || i == 5 || i == 2) { col[i].Visible = false; } } DgvGeneral.Columns[3].Width = 335; DgvGeneral.Columns[6].Width = 135; Funciones.getInstancia().Configurar_Grid(DgvGeneral); DgvGeneral.OptionsCustomization.AllowSort = true; DgvGeneral.OptionsView.ColumnAutoWidth = false; DgvGeneral.OptionsFind.AlwaysVisible = true; }
private void DATA_LOAD_AKTARILDI() { BR_BUG.Caption = ""; BR_INFO.Caption = ""; BR_SELECT_ROW_FATURA_GUID.Caption = ""; BR_SELECT_ROW_FATURA_NO.Caption = ""; using (SqlConnection myConnection = new SqlConnection(_GLOBAL_PARAMETERS._CONNECTIONSTRING_MDB.ToString())) { string SlctQu = ""; if (BTN_YIL.EditValue.ToString() == "TÜMÜ") { SlctQu = " SELECT CASE WHEN EINVOICE = 1 THEN 'e-fatura' else 'e-arşiv' END AS FATURANIN_TURU , CASE WHEN TYPE = 8 THEN 'SATIŞ' WHEN TYPE = 3 THEN 'SATIŞ İADE' END AS TIPI ,* FROM dbo.FTR_LG_INVOICE where (SIRKET_KODU=@SIRKET_KODU) AND (TYPE = 8 or TYPE = 3) AND (AKTARIM_DURUMU ='AKTARILDI' or AKTARIM_DURUMU ='ARŞİVEATILDI')"; } else { SlctQu = " SELECT CASE WHEN EINVOICE = 1 THEN 'e-fatura' else 'e-arşiv' END AS FATURANIN_TURU , CASE WHEN TYPE = 8 THEN 'SATIŞ' WHEN TYPE = 3 THEN 'SATIŞ İADE' END AS TIPI ,* FROM dbo.FTR_LG_INVOICE where (SIRKET_KODU=@SIRKET_KODU) AND (TYPE = 8 or TYPE = 3) AND (AKTARIM_DURUMU ='AKTARILDI' or AKTARIM_DURUMU ='ARŞİVEATILDI') AND (YEAR(DATE) = '" + BTN_YIL.EditValue.ToString() + "') "; } SqlDataAdapter da = new SqlDataAdapter(SlctQu, myConnection); da.SelectCommand.Parameters.AddWithValue("@SIRKET_KODU", _GLOBAL_PARAMETERS._SIRKET_KODU); da.SelectCommand.CommandTimeout = 0; dataSet = new DataSet(); da.Fill(dataSet, "FTR_LG_INVOICE"); DataViewManager dvManager = new DataViewManager(dataSet); DataView dv = dvManager.CreateDataView(dataSet.Tables[0]); gridCntrl_LIST.DataSource = dv; myConnection.Close(); } }
private void LlenarGrid() { dsPerfiles = new DataSet(); dtPerfiles = new DataTable(); DataColumn DtColumn1 = new DataColumn(); DataColumn DtColumn2 = new DataColumn(); DtColumn1.ColumnName = "Id"; DtColumn2.ColumnName = "Titulo"; dtPerfiles.Columns.Add(DtColumn1); dtPerfiles.Columns.Add(DtColumn2); foreach (var item in Perfilador.getInstancia().ListarPerfiles()) { dtPerfiles.Rows.Add(item); } dsPerfiles.Tables.Add(dtPerfiles); DataViewManager dvm = new DataViewManager(dsPerfiles); DataView dvMain = dvm.CreateDataView(dsPerfiles.Tables[0]); GctrlGeneral.DataSource = dvMain; }
private void BTN_LISTE_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) { TARIFELER._TARIFE_LISTESI TF = new TARIFELER._TARIFE_LISTESI("TARIFE", "SINEMA"); TF.ShowDialog(); lbFILE_NAME.Caption = TF._TARIFE_KODU; lbID.Caption = TF._TARIFE_ID; dv = null; DataSet ds = new DataSet(); using (SqlConnection conn = new SqlConnection(_GLOBAL_PARAMETRELER._CONNECTION_STRING.ToString())) { string query = string.Format(" SELECT * FROM dbo.TRF_SINEMA where KULLANICI_KODU='{0}' and SIRKET_KODU='{1}' and TARIFE_KODU='{2}' ", _GLOBAL_PARAMETRELER._KULLANICI_MAIL, _GLOBAL_PARAMETRELER._KULLANICI_FIRMA, lbFILE_NAME.Caption); SqlDataAdapter adapter = new SqlDataAdapter() { SelectCommand = new SqlCommand(query, conn) }; adapter.Fill(ds, "TRF_SINEMA"); DataViewManager dvManager = new DataViewManager(ds); dv = dvManager.CreateDataView(ds.Tables[0]); } gridControl_SECENEKLER.DataSource = dv; }
private void getData_Click(object sender, EventArgs e) { string orders = "SELECT * FROM Orders"; string customers = "SELECT * FROM Customers"; using (SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["northwind"].ConnectionString)) { SqlDataAdapter da = new SqlDataAdapter(orders, con); DataSet ds = new DataSet(); da.Fill(ds, "Orders"); da = new SqlDataAdapter(customers, con); da.Fill(ds, "Customers"); ds.Relations.Add("CustomerOrders", ds.Tables["Customers"].Columns["CustomerID"], ds.Tables["Orders"].Columns["CustomerID"]); DataViewManager dvm = new DataViewManager(ds); dvm.DataViewSettings["Customers"].RowFilter = "Country='UK'"; dataGrid1.SetDataBinding(dvm, "Customers"); } }
private void BindImg() { var homesTable = new DataTable("Homes"); homesTable.Columns.Add("Index", typeof(int)); homesTable.Columns.Add("Image", typeof(Image)); homesTable.Columns.Add("IsSelect", typeof(bool)); gridControl1.DataMember = null; gridControl1.DataSource = null; if (currentHistory.imgInfos != null) { currentHistory.imgInfos.ForEach(f => { //if (f.InfoType == 0) //{ var row = homesTable.NewRow(); row["Index"] = f.ID; row["Image"] = new Bitmap(f.Img, new Size(351, 234)); row["IsSelect"] = 0; homesTable.Rows.Add(row); //} }); DataSet ds = new DataSet(); ds.Tables.Add(homesTable); DataViewManager dvManager = new DataViewManager(ds); DataView dv = dvManager.CreateDataView(homesTable); gridControl1.DataSource = dv; } }
private void SABIT_LISTE() { using (SqlConnection conn = new SqlConnection(_GLOBAL_PARAMETRELER._CONNECTION_STRING.ToString())) { DataSet ds = new DataSet(); string query = " SELECT MEDYA,ILI,BOLGE FROM dbo._ADEX_INDEX_DATA GROUP BY YAYIN_SINIFI, MEDYA,ILI,BOLGE HAVING (YAYIN_SINIFI = N'SINEMA') ORDER BY MEDYA "; SqlDataAdapter adapter = new SqlDataAdapter(); adapter.SelectCommand = new SqlCommand(query, conn); adapter.Fill(ds, "dbo_ANA_YAYIN"); DataViewManager dvManager = new DataViewManager(ds); DataView dvLIST = dvManager.CreateDataView(ds.Tables[0]); gridControl_SABITLER.DataSource = dvLIST; } gridView_SABITLER.ShowFindPanel(); using (SqlConnection myConnections = new SqlConnection(_GLOBAL_PARAMETRELER._CONNECTION_STRING.ToString())) { string SQL = " SELECT top 0 * FROM dbo.TRF_SINEMA "; SqlDataAdapter MySqlDataAdapter = new SqlDataAdapter(SQL, myConnections); DataSet ds = new DataSet(); MySqlDataAdapter.Fill(ds, "dbo_SELECTANA_YAYIN"); DataViewManager dvManager = new DataViewManager(ds); dv = dvManager.CreateDataView(ds.Tables[0]); gridControl_SECENEKLER.DataSource = dv; } }
private void DATA_LOAD_PIVOT() { using (SqlConnection connection = new SqlConnection(GLOBAL_PARAMETRELER._CONNECTION_STRING.ToString())) { SqlCommand command; SqlDataAdapter adapter = new SqlDataAdapter(); DataSet dsPLAN_ROW = new DataSet(); connection.Open(); string SQLS = @"SELECT REPORT_ITEM FROM dbo.ScoreCard GROUP BY REPORT_ITEM ORDER BY REPORT_ITEM "; command = new SqlCommand(SQLS, connection); command.CommandTimeout = 0; adapter.SelectCommand = command; adapter.Fill(dsPLAN_ROW, "LIST_TABLE"); string sql = ""; for (int i = 0; i <= dsPLAN_ROW.Tables["LIST_TABLE"].Rows.Count - 1; i++) { sql += " MIN( CASE SCD.REPORT_ITEM WHEN '" + dsPLAN_ROW.Tables["LIST_TABLE"].Rows[i]["REPORT_ITEM"].ToString() + "' THEN SC.SCORE END ) AS [" + dsPLAN_ROW.Tables["LIST_TABLE"].Rows[i]["REPORT_ITEM"].ToString().Replace(" ", "").Replace("&", "") + "], "; } sql = sql.ToString().Substring(0, sql.Length - 2).ToString(); string SQL = " SELECT dbo.SCORE_CARD_URUNLER.URUNLER, SC.COLUM_NAME, " + sql + " FROM dbo.ScoreCard AS SCD INNER JOIN dbo.SCORE_CARD_SCORE AS SC ON SCD.SETID = SC.SETID AND SCD.GUID = SC.GUID INNER JOIN dbo.SCORE_CARD_URUNLER ON SC.SETID = dbo.SCORE_CARD_URUNLER.ID GROUP BY SC.COLUM_NAME, dbo.SCORE_CARD_URUNLER.URUNLER ORDER BY dbo.SCORE_CARD_URUNLER.URUNLER"; adapter.SelectCommand.CommandText = SQL; adapter.SelectCommand.CommandTimeout = 0; adapter.Fill(dsPLAN_ROW, "CHART_TABLE"); DataViewManager dvManager = new DataViewManager(dsPLAN_ROW); DataView DW_CHART = dvManager.CreateDataView(dsPLAN_ROW.Tables["CHART_TABLE"]); GRD_RAPOR.DataSource = DW_CHART; } }
public MUSTERI_DOKUMANLARI() { InitializeComponent(); this.Tag = "MDIFORM"; ControlBox = false; FormBorderStyle = System.Windows.Forms.FormBorderStyle.FixedToolWindow; StartPosition = System.Windows.Forms.FormStartPosition.CenterParent; using (SqlConnection Conn = new SqlConnection(_GLOBAL_PARAMETERS._CONNECTIONSTRING_MDB.ToString())) { string Sql = " SELECT * FROM dbo.ADM_MUSTERI WHERE (SIRKET_KODU=@SIRKET_KODU) ORDER BY SIRKET_KODU,MUSTERI_KODU"; using (SqlDataAdapter da = new SqlDataAdapter(Sql, Conn)) { da.SelectCommand.Parameters.AddWithValue("@SIRKET_KODU", _GLOBAL_PARAMETERS._SIRKET_KODU); using (DataSet dtSet = new DataSet()) { da.Fill(dtSet, "ADM_MUSTERI"); using (DataViewManager dvManager = new DataViewManager(dtSet)) { DataView dv = dvManager.CreateDataView(dtSet.Tables[0]); GRD_LISTE.DataSource = dv; } } } } }
public MASTER_FREE_VERSIYON(string YAYIN_SINFI, string VER_QUERY) { InitializeComponent(); ControlBox = false; FormBorderStyle = System.Windows.Forms.FormBorderStyle.FixedToolWindow; StartPosition = System.Windows.Forms.FormStartPosition.CenterParent; string SQL = string.Empty; if (YAYIN_SINFI == "TELEVIZYON" || YAYIN_SINFI == "RADYO") { SQL = string.Format("select VERSIYON from [dbo].[_ADEX_INDEX_DATA] WHERE {0} group by VERSIYON ", VER_QUERY); } else { SQL = string.Format("select REKLAM_SLOGANI from [dbo].[_ADEX_INDEX_DATA] WHERE {0} group by REKLAM_SLOGANI ", VER_QUERY); } SqlConnection myConnection = new SqlConnection(_GLOBAL_PARAMETRELER._CONNECTION_STRING.ToString()); SqlDataAdapter da = new SqlDataAdapter(SQL, myConnection); DataSet ds = new DataSet(); da.Fill(ds, "stock"); DataViewManager dvManager = new DataViewManager(ds); DW_LIST = dvManager.CreateDataView(ds.Tables[0]); gridControl_FREE_TABLE.DataSource = DW_LIST; }
/// <summary> /// Retrieve the data /// </summary> /// <param name="sender"> </param> /// <param name="e"> </param> protected void retrieveButton_Click(object sender, System.EventArgs e) { retrieveButton.Enabled = false; string orders = "SELECT * FROM Orders"; string customers = "SELECT * FROM Customers"; SqlConnection con = new SqlConnection(Login.Connection); SqlDataAdapter da = new SqlDataAdapter(orders, con); DataSet ds = new DataSet( ); da.Fill(ds, "Orders"); da = new SqlDataAdapter(customers, con); da.Fill(ds, "Customers"); ds.Relations.Add("CustomerOrders", ds.Tables["Customers"].Columns["CustomerID"], ds.Tables["Orders"].Columns["CustomerID"]); DataViewManager dvm = new DataViewManager(ds); dvm.DataViewSettings["Customers"].RowFilter = "Country='UK'"; dataGrid.SetDataBinding(dvm, "Customers"); }
private void BindingDataSource(DataTable tblParent, DataTable tblChild, string colParent, string colChild) { m_dsADO.Tables.Add(tblParent); m_dsADO.Tables.Add(tblChild); #if 관계객체없이제약조건직접걸기 ForeignKeyConstraint fk = new ForeignKeyConstraint(RELATION_BUY , m_dsADO.Tables["tblPeople"].Columns["Name"] , m_dsADO.Tables["tblSale"].Columns["Customer"]); //fk.DeleteRule = Rule.Cascade; //fk.UpdateRule = Rule.Cascade; //fk.AcceptRejectRule = AcceptRejectRule.None; m_dsADO.Tables["tblSale"].Constraints.Add(fk);//자식테입블의 키에 ForeignKey제약조건 걸어 자식 키가 유효한 부모키를 가리킬 것을 강제. m_dsADO.EnforceConstraints = true; #else m_relationBuy = new DataRelation(RELATION_BUY , m_dsADO.Tables[tblParent.TableName].Columns[colParent] , m_dsADO.Tables[tblChild.TableName].Columns[colChild]); m_dsADO.Relations.Add(m_relationBuy); //관계의 룰 기본값을 변경할 경우, 아래 코드 실행하면 변경 가능 //ForeignKeyConstraint fk = (ForeignKeyConstraint)m_dsADO.Tables["tblSale"].Constraints[RELATION_BUY]; //fk.DeleteRule = Rule.None; #endif #if VIEWMANAGER //DataViewManager : 다수의 뷰를 중앙에서 관리. 개별 뷰의 설정 상태인 DataViewSetting 을 보유. // + 여러 테이블의 보기 상태 일괄 수정 가능 // + 컨트롤에 바인딩시 매니저를 통해 가능 // + 일부 열만 가지는 수직뷰 생성 불가 // + 테이블에 대한 동적뷰만 제공 : 조인결과 가질 수 없음 // + 레코드의 상태에 따라 필터 구성 가능 DataViewManager dvmManager = new DataViewManager(m_dsADO); dvmManager.DataViewSettings["tblPeople"].Sort = "Name"; dvmManager.DataViewSettings["tblSale"].RowFilter = "OrderNo > 1"; DataView dvPeople = dvmManager.CreateDataView(m_tblPeople); dvPeople.RowFilter = "Male = true"; dvPeople.Sort = "Age DESC"; foreach (DataViewSetting dvs in dvmManager.DataViewSettings) { lbxSale.Items.Add(String.Format("테이블: {0}, 필터: {1}, 정렬: {2}, 상태: {3}", dvs.Table, dvs.RowFilter, dvs.Sort, dvs.RowStateFilter)); } //그리드 출력: (1)매니저 바인딩 ==> (2)뷰의 DataMember 지정 dgvPeople.DataSource = dvmManager; dgvPeople.DataMember = "tblPeople"; dgvSale.DataSource = dvmManager; dgvSale.DataMember = "tblSale"; #else dgvPeople.DataSource = m_dsADO.Tables[tblParent.TableName]; dgvSale.DataSource = m_dsADO.Tables[tblChild.TableName]; #endif }
private void ViewSelectedInfo(DataGrid dg) { if (dg.DataMember == "") { return; } dvm = new DataViewManager(_allocDiff.ds); dvm_caller = new DataViewManager(_allocDiff.ds); dvm_callee = new DataViewManager(_allocDiff.ds); int roeNumber = dg.CurrentCell.RowNumber; string name = (string)dg[roeNumber, 0]; int id = (int)_allocDiff.basedataId[name]; DataRow[] caller = _allocDiff.callertbl.Select("id =" + id); DataRow[] callee = _allocDiff.calleetbl.Select("id =" + id); //======== caller table============ if (name != "<root>") { dgCaller.CaptionText = CallerCaption; // FIXME // ReSharper disable once PossibleNullReferenceException dvm_caller.DataViewSettings[_allocDiff.ContriTocallertbl.TableName].RowFilter = "id = " + id; dgCaller.SetDataBinding(dvm_caller, _allocDiff.ContriTocallertbl.TableName); } else { dgCaller.SetDataBinding(null, null); } dgCaller.Visible = true; //========= selected table ========== dgSelected.CaptionText = SelectedCaption; // FIXME // ReSharper disable once PossibleNullReferenceException dvm.DataViewSettings[_allocDiff.basedatatable.TableName].RowFilter = "id=" + id; dgSelected.SetDataBinding(dvm, _allocDiff.basedatatable.TableName); dgSelected.Visible = true; //========= callee Table =============== if (name != "<bottom>") { dgCallee.CaptionText = CalleeCaption; // FIXME // ReSharper disable once PossibleNullReferenceException dvm_callee.DataViewSettings[_allocDiff.ContriTocalleetbl.TableName].RowFilter = "id = " + id; dgCallee.SetDataBinding(dvm_callee, _allocDiff.ContriTocalleetbl.TableName); } else { dgCallee.SetDataBinding(null, null); } dgCallee.Visible = true; this.Invalidate(); }
public DB() { if (DS == null) { DS = new DataSet(); DVM = DS.DefaultViewManager; } }
public void SpecifyNonExistentTable() { DataViewManager m = new DataViewManager(null); Assert.Throws<NullReferenceException>(() => { m.DataViewSettingCollectionString = "<DataViewSettingCollectionString><table1-1 RowFilter='a=b' /></DataViewSettingCollectionString>"; }); }
/// <summary> LlenarGrid(DataSet d) /// Permite llenar la grilla con un Dataset /// </summary> /// <param name="d">En este parametro se recibe el Dataset con que se va a llenar la grilla DgvCampos </param> public void LlenarGridCampos(DataSet d) { if (d != null) { DgvCampos.Columns.Clear(); DataViewManager dvm = new DataViewManager(d); DataView dvMain = dvm.CreateDataView(d.Tables[0]); DgvCampos.OptionsBehavior.AutoPopulateColumns = false; GcrtlCampos.DataSource = dvMain; GridColumn[] col = new GridColumn[d.Tables[0].Columns.Count]; string[] captions = new[] { "Campo", "Agregar", "Visible" }; for (int i = 0; i < d.Tables[0].Columns.Count; i++) { col[i] = DgvCampos.Columns.AddField(d.Tables[0].Columns[i].Caption.Trim()); col[i].VisibleIndex = i; col[i].Caption = captions[i]; col[i].FieldName = captions[i]; } DgvCampos.Columns["Campo"].Width = 504; DgvCampos.Columns["Agregar"].Width = 48; DgvCampos.Columns["Visible"].Width = 47; DevExpress.XtraEditors.Repository.RepositoryItemTextEdit memo = new DevExpress.XtraEditors.Repository.RepositoryItemTextEdit(); memo.ReadOnly = true; DgvCampos.Columns[0].ColumnEdit = memo; DevExpress.XtraEditors.Repository.RepositoryItemCheckEdit memo1 = new DevExpress.XtraEditors.Repository.RepositoryItemCheckEdit(); memo1.CheckStyle = DevExpress.XtraEditors.Controls.CheckStyles.Standard; DgvCampos.Columns[1].ColumnEdit = memo1; DevExpress.XtraEditors.Repository.RepositoryItemCheckEdit memo2 = new DevExpress.XtraEditors.Repository.RepositoryItemCheckEdit(); DgvCampos.Columns[2].ColumnEdit = memo2; } DgvCampos.OptionsBehavior.AutoPopulateColumns = false; DgvCampos.OptionsBehavior.AllowDeleteRows = DevExpress.Utils.DefaultBoolean.False; DgvCampos.OptionsBehavior.AllowAddRows = DevExpress.Utils.DefaultBoolean.False; DgvCampos.OptionsView.ColumnAutoWidth = false; DgvCampos.OptionsFilter.AllowFilterEditor = false; DgvCampos.OptionsFilter.AllowColumnMRUFilterList = false; DgvCampos.OptionsFilter.AllowMRUFilterList = false; DgvCampos.OptionsFilter.MRUFilterListPopupCount = 0; DgvCampos.OptionsFilter.MRUFilterListCount = 0; DgvCampos.OptionsFilter.MRUColumnFilterListCount = 0; DgvCampos.OptionsView.EnableAppearanceOddRow = true; DgvCampos.OptionsView.ShowAutoFilterRow = false; DgvCampos.OptionsView.ShowGroupPanel = false; DgvCampos.OptionsHint.ShowColumnHeaderHints = false; DgvCampos.OptionsView.ShowIndicator = true; DgvCampos.OptionsView.ShowFilterPanelMode = DevExpress.XtraGrid.Views.Base.ShowFilterPanelMode.Default; DgvCampos.OptionsCustomization.AllowQuickHideColumns = false; DgvCampos.OptionsCustomization.AllowFilter = false; DgvCampos.OptionsMenu.EnableColumnMenu = false; DgvCampos.ScrollStyle = DevExpress.XtraGrid.Views.Grid.ScrollStyleFlags.LiveHorzScroll; DgvCampos.HorzScrollVisibility = DevExpress.XtraGrid.Views.Base.ScrollVisibility.Always; }
/// <summary> /// 加载字典文件到数据视图(DataView) /// </summary> /// <param name="path">目录</param> /// <param name="filename">字典文件名</param> /// <returns></returns> public static DataView getViewByFile(string path, string filename) { DataSet ds = new DataSet(); ds.ReadXml(path + "\\" + filename); DataViewManager dvm = new DataViewManager(ds); return(dvm.CreateDataView(ds.Tables["row"])); }
public void SpecifyNonExistentTable() { DataViewManager m = new DataViewManager(null); Assert.Throws <NullReferenceException>(() => { m.DataViewSettingCollectionString = "<DataViewSettingCollectionString><table1-1 RowFilter='a=b' /></DataViewSettingCollectionString>"; }); }
public void Ctor() { string defaultString = "<DataViewSettingCollectionString></DataViewSettingCollectionString>"; string current = @"<DataViewSettingCollectionString><table2-1 Sort="""" RowFilter="""" RowStateFilter=""CurrentRows""/></DataViewSettingCollectionString>"; string deleted = @"<DataViewSettingCollectionString><table2-1 Sort="""" RowFilter="""" RowStateFilter=""Deleted""/></DataViewSettingCollectionString>"; DataViewManager m = new DataViewManager(null); Assert.Null(m.DataSet); Assert.Equal("", m.DataViewSettingCollectionString); Assert.NotNull(m.DataViewSettings); DataSet ds = new DataSet("ds"); m.DataSet = ds; Assert.Equal(defaultString, m.DataViewSettingCollectionString); DataSet ds2 = new DataSet("ds2"); Assert.Equal(defaultString, ds.DefaultViewManager.DataViewSettingCollectionString); DataTable dt2_1 = new DataTable("table2-1"); dt2_1.Namespace = "urn:foo"; // It is ignored though. ds2.Tables.Add(dt2_1); m.DataSet = ds2; Assert.Equal(current, m.DataViewSettingCollectionString); // Note that " Deleted " is trimmed. m.DataViewSettingCollectionString = @"<DataViewSettingCollectionString><table2-1 Sort='' RowFilter='' RowStateFilter=' Deleted '/></DataViewSettingCollectionString>"; Assert.Equal(deleted, m.DataViewSettingCollectionString); m.DataSet = ds2; //resets modified string. Assert.Equal(current, m.DataViewSettingCollectionString); m.DataViewSettingCollectionString = @"<DataViewSettingCollectionString><table2-1 Sort='' RowFilter='' RowStateFilter='Deleted'/></DataViewSettingCollectionString>"; // it does not clear anything. m.DataViewSettingCollectionString = "<DataViewSettingCollectionString/>"; Assert.Equal(deleted, m.DataViewSettingCollectionString); // text node is not rejected (ignored). // RowFilter is not examined. m.DataViewSettingCollectionString = "<DataViewSettingCollectionString>blah<table2-1 RowFilter='a=b' ApplyDefaultSort='true' /></DataViewSettingCollectionString>"; // LAMESPEC: MS.NET ignores ApplyDefaultSort. // Assert.Equal (@"<DataViewSettingCollectionString><table2-1 Sort="""" RowFilter=""a=b"" RowStateFilter=""Deleted""/></DataViewSettingCollectionString>", m.DataViewSettingCollectionString); }
public void SetNullDataSet() { DataViewManager m = new DataViewManager(null); Assert.Throws<DataException>(() => m.DataSet = null); }
public void SetIncorrectRootElement() { DataViewManager m = new DataViewManager(null); Assert.Throws<DataException>(() => m.DataViewSettingCollectionString = "<foo/>"); }