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/>");
}
