public static global::System.Xml.Schema.XmlSchemaComplexType GetTypedTableSchema(global::System.Xml.Schema.XmlSchemaSet xs) {
global::System.Xml.Schema.XmlSchemaComplexType type = new global::System.Xml.Schema.XmlSchemaComplexType();
global::System.Xml.Schema.XmlSchemaSequence sequence = new global::System.Xml.Schema.XmlSchemaSequence();
nwindDataSet ds = new nwindDataSet();
global::System.Xml.Schema.XmlSchemaAny any1 = new global::System.Xml.Schema.XmlSchemaAny();
any1.Namespace = "http://www.w3.org/2001/XMLSchema";
any1.MinOccurs = new decimal(0);
any1.MaxOccurs = decimal.MaxValue;
any1.ProcessContents = global::System.Xml.Schema.XmlSchemaContentProcessing.Lax;
sequence.Items.Add(any1);
global::System.Xml.Schema.XmlSchemaAny any2 = new global::System.Xml.Schema.XmlSchemaAny();
any2.Namespace = "urn:schemas-microsoft-com:xml-diffgram-v1";
any2.MinOccurs = new decimal(1);
any2.ProcessContents = global::System.Xml.Schema.XmlSchemaContentProcessing.Lax;
sequence.Items.Add(any2);
global::System.Xml.Schema.XmlSchemaAttribute attribute1 = new global::System.Xml.Schema.XmlSchemaAttribute();
attribute1.Name = "namespace";
attribute1.FixedValue = ds.Namespace;
type.Attributes.Add(attribute1);
global::System.Xml.Schema.XmlSchemaAttribute attribute2 = new global::System.Xml.Schema.XmlSchemaAttribute();
attribute2.Name = "tableTypeName";
attribute2.FixedValue = "Order_DetailsDataTable";
type.Attributes.Add(attribute2);
type.Particle = sequence;
global::System.Xml.Schema.XmlSchema dsSchema = ds.GetSchemaSerializable();
if (xs.Contains(dsSchema.TargetNamespace)) {
global::System.IO.MemoryStream s1 = new global::System.IO.MemoryStream();
global::System.IO.MemoryStream s2 = new global::System.IO.MemoryStream();
try {
global::System.Xml.Schema.XmlSchema schema = null;
dsSchema.Write(s1);
for (global::System.Collections.IEnumerator schemas = xs.Schemas(dsSchema.TargetNamespace).GetEnumerator(); schemas.MoveNext(); ) {
schema = ((global::System.Xml.Schema.XmlSchema)(schemas.Current));
s2.SetLength(0);
schema.Write(s2);
if ((s1.Length == s2.Length)) {
s1.Position = 0;
s2.Position = 0;
for (; ((s1.Position != s1.Length)
&& (s1.ReadByte() == s2.ReadByte())); ) {
;
}
if ((s1.Position == s1.Length)) {
return type;
}
}
}
}
finally {
if ((s1 != null)) {
s1.Close();
}
if ((s2 != null)) {
s2.Close();
}
}
}
xs.Add(dsSchema);
return type;
}
public Form1()
{
InitializeComponent();
dataSet = new nwindDataSet();
adapter = new nwindDataSetTableAdapters.InvoicesTableAdapter();
adapter.Fill(dataSet.Invoices);
}
public override global::System.Data.DataSet Clone()
{
nwindDataSet cln = ((nwindDataSet)(base.Clone()));
cln.InitVars();
cln.SchemaSerializationMode = this.SchemaSerializationMode;
return(cln);
}
protected override void FillDataSource(OleDbConnection connection, nwindDataSet dataSource) {
var customerOrdersTableAdapter = new CustomerOrdersTableAdapter();
customerOrdersTableAdapter.Connection = connection;
customerOrdersTableAdapter.Fill(dataSource.CustomerOrders);
var orderReportsTableAdapter = new OrderReportsTableAdapter();
orderReportsTableAdapter.Connection = connection;
orderReportsTableAdapter.Fill(dataSource.OrderReports);
}
public XtraReport CreateDataGroupingReport()
{
// Create a report, and bind it to a data source.
XtraReport report = new XtraReport();
nwindDataSet ds = new nwindDataSet();
new nwindDataSetTableAdapters.OrdersTableAdapter().Fill(ds.Orders);
report.DataSource = ds;
report.DataMember = "Orders";
// Create a detail band and add it to the report.
DetailBand detailBand = new DetailBand();
detailBand.Height = 20;
report.Bands.Add(detailBand);
// Create a group header band and add it to the report.
GroupHeaderBand ghBand = new GroupHeaderBand();
ghBand.Height = 20;
report.Bands.Add(ghBand);
// Create a calculated field, and add it to the report's collection
CalculatedField calcField = new CalculatedField(report.DataSource, report.DataMember);
report.CalculatedFields.Add(calcField);
// Define its name, field type and expression.
// Note that numerous built-in date-time functions are supported.
calcField.Name = "dayOfWeek";
calcField.FieldType = FieldType.None;
calcField.Expression = "GetDayOfWeek([OrderDate])";
// Define the calculated field as
// a grouping criteria for the group header band.
GroupField groupField = new GroupField();
groupField.FieldName = "dayOfWeek";
ghBand.GroupFields.Add(groupField);
// Create two data-bound labels, and add them to
// the corresponding bands.
XRLabel ghLabel = new XRLabel();
ghLabel.DataBindings.Add("Text", report.DataSource, "OrderDate", "{0:dddd}");
ghLabel.BackColor = Color.Red;
ghBand.Controls.Add(ghLabel);
XRLabel detailLabel = new XRLabel();
detailLabel.DataBindings.Add("Text", report.DataSource, "OrderDate", "{0:MM/dd/yyyy}");
detailLabel.ProcessDuplicatesTarget = ProcessDuplicatesTarget.Value;
detailLabel.ProcessDuplicatesMode = ProcessDuplicatesMode.Suppress;
detailBand.Controls.Add(detailLabel);
return(report);
}
static NWindData()
{
ds = new nwindDataSet();
nwindDataSetTableAdapters.CategoriesTableAdapter categoriesAdapter =
new nwindDataSetTableAdapters.CategoriesTableAdapter();
nwindDataSetTableAdapters.ProductsTableAdapter productsAdapter =
new nwindDataSetTableAdapters.ProductsTableAdapter();
categoriesAdapter.Fill(ds.Categories);
productsAdapter.Fill(ds.Products);
}
public Form1()
{
InitializeComponent();
dataSet = new nwindDataSet();
adapter = new nwindDataSetTableAdapters.CategoriesTableAdapter();
adapter.Fill(dataSet.Categories);
nwindDataSetTableAdapters.ProductsTableAdapter productsTableAdapter = new nwindDataSetTableAdapters.ProductsTableAdapter();
productsTableAdapter.Fill(dataSet.Products);
}
protected override void FillDataSource(OleDbConnection connection, nwindDataSet dataSource)
{
var customerOrdersTableAdapter = new CustomerOrdersTableAdapter();
customerOrdersTableAdapter.Connection = connection;
customerOrdersTableAdapter.Fill(dataSource.CustomerOrders);
var orderReportsTableAdapter = new OrderReportsTableAdapter();
orderReportsTableAdapter.Connection = connection;
orderReportsTableAdapter.Fill(dataSource.OrderReports);
}
public static global::System.Xml.Schema.XmlSchemaComplexType GetTypedDataSetSchema(global::System.Xml.Schema.XmlSchemaSet xs)
{
nwindDataSet ds = new nwindDataSet();
global::System.Xml.Schema.XmlSchemaComplexType type = new global::System.Xml.Schema.XmlSchemaComplexType();
global::System.Xml.Schema.XmlSchemaSequence sequence = new global::System.Xml.Schema.XmlSchemaSequence();
global::System.Xml.Schema.XmlSchemaAny any = new global::System.Xml.Schema.XmlSchemaAny();
any.Namespace = ds.Namespace;
sequence.Items.Add(any);
type.Particle = sequence;
global::System.Xml.Schema.XmlSchema dsSchema = ds.GetSchemaSerializable();
if (xs.Contains(dsSchema.TargetNamespace))
{
global::System.IO.MemoryStream s1 = new global::System.IO.MemoryStream();
global::System.IO.MemoryStream s2 = new global::System.IO.MemoryStream();
try {
global::System.Xml.Schema.XmlSchema schema = null;
dsSchema.Write(s1);
for (global::System.Collections.IEnumerator schemas = xs.Schemas(dsSchema.TargetNamespace).GetEnumerator(); schemas.MoveNext();)
{
schema = ((global::System.Xml.Schema.XmlSchema)(schemas.Current));
s2.SetLength(0);
schema.Write(s2);
if ((s1.Length == s2.Length))
{
s1.Position = 0;
s2.Position = 0;
for (; ((s1.Position != s1.Length) &&
(s1.ReadByte() == s2.ReadByte()));)
{
;
}
if ((s1.Position == s1.Length))
{
return(type);
}
}
}
}
finally {
if ((s1 != null))
{
s1.Close();
}
if ((s2 != null))
{
s2.Close();
}
}
}
xs.Add(dsSchema);
return(type);
}
public MainWindowViewModel()
{
if (IsInDesignMode)
{
return;
}
report = new XtraReport1()
{
RequestParameters = false
};
DataSet = new nwindDataSet();
report.categoriesTableAdapter.Fill(DataSet.Categories);
}
public object GetDataSource() {
string path = FilesHelper.FindingFileName(AppDomain.CurrentDomain.BaseDirectory, @"Data\nwind.mdb", false);
var dataSource = new nwindDataSet();
var connection = new OleDbConnection();
connection.ConnectionString = string.Format(@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source={0}", path);
FillDataSource(connection, dataSource);
var bindingSource = new BindingSource();
bindingSource.DataSource = dataSource;
bindingSource.DataMember = DataMember;
return bindingSource;
}
void DesignMdiController_DesignPanelLoaded(object sender, DevExpress.XtraReports.UserDesigner.DesignerLoadedEventArgs e)
{
// Get access to an instanse of the IToolboxService interface
IToolboxService ts = (IToolboxService)e.DesignerHost.GetService(typeof(IToolboxService));
// Get access to the collection of the toolbox items
ToolboxItemCollection collection = ts.GetToolboxItems();
foreach (ToolboxItem item in collection)
{
if (item.DisplayName == "Label")
{
// Change name of the report control
collection[0].DisplayName = "Report Label";
}
}
IDesignerHost host = e.DesignerHost;
nwindDataSet ds = new nwindDataSet();
// Search DataSet component
foreach (IComponent comp in host.Container.Components)
{
ds = comp as nwindDataSet;
if (!Object.Equals(ds, null))
{
// Delete data source from designer host
host.Container.Remove(ds);
break;
}
}
// In this place you can define your own report data source
host.Container.Add(ds, "ReportDataSource");
CategoriesTableAdapter adapter = new CategoriesTableAdapter();
// Search TableAdapter component
foreach (IComponent comp in host.Container.Components)
{
adapter = comp as CategoriesTableAdapter;
if (!Object.Equals(adapter, null))
{
// Delete table adapter from designer host
host.Container.Remove(adapter);
break;
}
}
// In this place you can define your own report table adapter
host.Container.Add(adapter, "ReportTableAdapter");
}
public object GetDataSource()
{
string path = FilesHelper.FindingFileName(AppDomain.CurrentDomain.BaseDirectory, @"Data\nwind.mdb", false);
var dataSource = new nwindDataSet();
var connection = new OleDbConnection();
connection.ConnectionString = string.Format(@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source={0}", path);
FillDataSource(connection, dataSource);
var bindingSource = new BindingSource();
bindingSource.DataSource = dataSource;
bindingSource.DataMember = DataMember;
return(bindingSource);
}
private DataSet FillDatasetFromGrid()
{
nwindDataSet ds = new nwindDataSet();
int rowHandle;
DataRow gridRow;
for (int i = 0; i < gridView1.RowCount; i++)
{
rowHandle = gridView1.GetVisibleRowHandle(i);
if (!gridView1.IsGroupRow(rowHandle))
{
gridRow = gridView1.GetDataRow(rowHandle);
ds.Tables[0].Rows.Add(gridRow.ItemArray);
}
}
return(ds);
}
static object CreateDataSource()
{
var dataSource = new nwindDataSet();
var connection = new OleDbConnection();
connection.ConnectionString = Properties.Settings.Default.nwindConnectionString;
CategoriesTableAdapter categories = new CategoriesTableAdapter();
categories.Connection = connection;
categories.Fill(dataSource.Categories);
ProductsTableAdapter products = new ProductsTableAdapter();
products.Connection = connection;
products.Fill(dataSource.Products);
return(dataSource);
}
private BindingSource GetDataSource()
{
nwindDataSet dataSource = new nwindDataSet();
OleDbConnection connection = new OleDbConnection();
connection.ConnectionString = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=|DataDirectory|\nwind.mdb";
ProductsTableAdapter products = new ProductsTableAdapter();
products.Connection = connection;
products.Fill(dataSource.Products);
BindingSource bindingSource = new BindingSource();
bindingSource.DataSource = dataSource;
bindingSource.DataMember = "Products";
return(bindingSource);
}
private static object CreateDataSource()
{
var dataSource = new nwindDataSet();
var connection = new OleDbConnection();
connection.ConnectionString = Properties.Settings.Default.nwindConnectionString;
CustomersTableAdapter customers = new CustomersTableAdapter();
customers.Connection = connection;
customers.Fill(dataSource.Customers);
OrdersTableAdapter orders = new OrdersTableAdapter();
orders.Connection = connection;
orders.Fill(dataSource.Orders);
var bindingSource = new BindingSource();
bindingSource.DataSource = dataSource;
bindingSource.DataMember = "Customers";
return(bindingSource);
}
public virtual int Update(nwindDataSet dataSet)
{
return(this.Adapter.Update(dataSet, "Products"));
}
/// <summary>
/// Required method for Designer support - do not modify
/// the contents of this method with the code editor.
/// </summary>
private void InitializeComponent()
{
this.components = new System.ComponentModel.Container();
this.multiEditorRowProperties1 = new DevExpress.XtraVerticalGrid.Rows.MultiEditorRowProperties();
this.multiEditorRowProperties2 = new DevExpress.XtraVerticalGrid.Rows.MultiEditorRowProperties();
this.vGridControl1 = new DevExpress.XtraVerticalGrid.VGridControl();
this.customersBindingSource = new System.Windows.Forms.BindingSource(this.components);
this.nwindDataSet = new WindowsApplication409.nwindDataSet();
this.rowAddress = new DevExpress.XtraVerticalGrid.Rows.EditorRow();
this.rowCity = new DevExpress.XtraVerticalGrid.Rows.EditorRow();
this.rowCompanyName = new DevExpress.XtraVerticalGrid.Rows.EditorRow();
this.rowContactTitle = new DevExpress.XtraVerticalGrid.Rows.EditorRow();
this.rowContactName = new DevExpress.XtraVerticalGrid.Rows.EditorRow();
this.rowCountry = new DevExpress.XtraVerticalGrid.Rows.EditorRow();
this.rowFax = new DevExpress.XtraVerticalGrid.Rows.EditorRow();
this.multiEditorRow1 = new DevExpress.XtraVerticalGrid.Rows.MultiEditorRow();
this.rowCustomerID = new DevExpress.XtraVerticalGrid.Rows.EditorRow();
this.rowPostalCode = new DevExpress.XtraVerticalGrid.Rows.EditorRow();
this.rowRegion = new DevExpress.XtraVerticalGrid.Rows.EditorRow();
this.simpleButton1 = new DevExpress.XtraEditors.SimpleButton();
this.customersTableAdapter = new WindowsApplication409.nwindDataSetTableAdapters.CustomersTableAdapter();
((System.ComponentModel.ISupportInitialize)(this.vGridControl1)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.customersBindingSource)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.nwindDataSet)).BeginInit();
this.SuspendLayout();
//
// multiEditorRowProperties1
//
this.multiEditorRowProperties1.Caption = "Company";
this.multiEditorRowProperties1.FieldName = "CompanyName";
//
// multiEditorRowProperties2
//
this.multiEditorRowProperties2.Caption = "Phone";
this.multiEditorRowProperties2.FieldName = "Phone";
//
// vGridControl1
//
this.vGridControl1.DataSource = this.customersBindingSource;
this.vGridControl1.LayoutStyle = DevExpress.XtraVerticalGrid.LayoutViewStyle.SingleRecordView;
this.vGridControl1.Location = new System.Drawing.Point(2, 12);
this.vGridControl1.Name = "vGridControl1";
this.vGridControl1.RecordWidth = 127;
this.vGridControl1.RowHeaderWidth = 73;
this.vGridControl1.Rows.AddRange(new DevExpress.XtraVerticalGrid.Rows.BaseRow[] {
this.rowAddress,
this.rowContactTitle,
this.rowPostalCode
});
this.vGridControl1.ShowButtonMode = DevExpress.XtraVerticalGrid.ShowButtonModeEnum.ShowAlways;
this.vGridControl1.Size = new System.Drawing.Size(448, 400);
this.vGridControl1.TabIndex = 0;
//
// customersBindingSource
//
this.customersBindingSource.DataMember = "Customers";
this.customersBindingSource.DataSource = this.nwindDataSet;
//
// nwindDataSet
//
this.nwindDataSet.DataSetName = "nwindDataSet";
this.nwindDataSet.SchemaSerializationMode = System.Data.SchemaSerializationMode.IncludeSchema;
//
// rowAddress
//
this.rowAddress.ChildRows.AddRange(new DevExpress.XtraVerticalGrid.Rows.BaseRow[] {
this.rowCity
});
this.rowAddress.Height = 16;
this.rowAddress.Name = "rowAddress";
this.rowAddress.Properties.Caption = "Address";
this.rowAddress.Properties.FieldName = "Address";
//
// rowCity
//
this.rowCity.ChildRows.AddRange(new DevExpress.XtraVerticalGrid.Rows.BaseRow[] {
this.rowCompanyName
});
this.rowCity.Name = "rowCity";
this.rowCity.Properties.Caption = "City";
this.rowCity.Properties.FieldName = "City";
//
// rowCompanyName
//
this.rowCompanyName.Name = "rowCompanyName";
this.rowCompanyName.Properties.Caption = "CompanyName";
this.rowCompanyName.Properties.FieldName = "CompanyName";
//
// rowContactTitle
//
this.rowContactTitle.ChildRows.AddRange(new DevExpress.XtraVerticalGrid.Rows.BaseRow[] {
this.rowContactName,
this.rowCountry,
this.rowCustomerID
});
this.rowContactTitle.Name = "rowContactTitle";
this.rowContactTitle.Properties.Caption = "ContactTitle";
this.rowContactTitle.Properties.FieldName = "ContactTitle";
//
// rowContactName
//
this.rowContactName.Name = "rowContactName";
this.rowContactName.Properties.Caption = "ContactName";
this.rowContactName.Properties.FieldName = "ContactName";
//
// rowCountry
//
this.rowCountry.ChildRows.AddRange(new DevExpress.XtraVerticalGrid.Rows.BaseRow[] {
this.rowFax
});
this.rowCountry.Name = "rowCountry";
this.rowCountry.Properties.Caption = "Country";
this.rowCountry.Properties.FieldName = "Country";
//
// rowFax
//
this.rowFax.ChildRows.AddRange(new DevExpress.XtraVerticalGrid.Rows.BaseRow[] {
this.multiEditorRow1
});
this.rowFax.Name = "rowFax";
this.rowFax.Properties.Caption = "Fax";
this.rowFax.Properties.FieldName = "Fax";
//
// multiEditorRow1
//
this.multiEditorRow1.Name = "multiEditorRow1";
this.multiEditorRow1.PropertiesCollection.AddRange(new DevExpress.XtraVerticalGrid.Rows.MultiEditorRowProperties[] {
this.multiEditorRowProperties1,
this.multiEditorRowProperties2
});
//
// rowCustomerID
//
this.rowCustomerID.Name = "rowCustomerID";
this.rowCustomerID.Properties.Caption = "CustomerID";
this.rowCustomerID.Properties.FieldName = "CustomerID";
//
// rowPostalCode
//
this.rowPostalCode.ChildRows.AddRange(new DevExpress.XtraVerticalGrid.Rows.BaseRow[] {
this.rowRegion
});
this.rowPostalCode.Name = "rowPostalCode";
this.rowPostalCode.Properties.Caption = "PostalCode";
this.rowPostalCode.Properties.FieldName = "PostalCode";
//
// rowRegion
//
this.rowRegion.Name = "rowRegion";
this.rowRegion.Properties.Caption = "Region";
this.rowRegion.Properties.FieldName = "Region";
//
// simpleButton1
//
this.simpleButton1.Location = new System.Drawing.Point(160, 424);
this.simpleButton1.Name = "simpleButton1";
this.simpleButton1.Size = new System.Drawing.Size(75, 23);
this.simpleButton1.TabIndex = 1;
this.simpleButton1.Text = "FindRow";
this.simpleButton1.Click += new System.EventHandler(this.simpleButton1_Click);
//
// customersTableAdapter
//
this.customersTableAdapter.ClearBeforeFill = true;
//
// Form1
//
this.AutoScaleBaseSize = new System.Drawing.Size(5, 13);
this.ClientSize = new System.Drawing.Size(515, 462);
this.Controls.Add(this.simpleButton1);
this.Controls.Add(this.vGridControl1);
this.Name = "Form1";
this.Text = "How to obtain a row object by FieldName in the XtraVerticalGrid";
this.Load += new System.EventHandler(this.Form1_Load);
((System.ComponentModel.ISupportInitialize)(this.vGridControl1)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.customersBindingSource)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.nwindDataSet)).EndInit();
this.ResumeLayout(false);
}
/// <summary>
/// Required method for Designer support - do not modify
/// the contents of this method with the code editor.
/// </summary>
private void InitializeComponent()
{
this.components = new System.ComponentModel.Container();
this.gridControl1 = new DevExpress.XtraGrid.GridControl();
this.categoriesBindingSource = new System.Windows.Forms.BindingSource(this.components);
this.nwindDataSet = new HotTrack.nwindDataSet();
this.cardView1 = new DevExpress.XtraGrid.Views.Card.CardView();
this.colCategoryID = new DevExpress.XtraGrid.Columns.GridColumn();
this.colCategoryName = new DevExpress.XtraGrid.Columns.GridColumn();
this.colDescription = new DevExpress.XtraGrid.Columns.GridColumn();
this.colPicture = new DevExpress.XtraGrid.Columns.GridColumn();
this.repositoryItemPictureEdit1 = new DevExpress.XtraEditors.Repository.RepositoryItemPictureEdit();
this.categoriesTableAdapter = new HotTrack.nwindDataSetTableAdapters.CategoriesTableAdapter();
((System.ComponentModel.ISupportInitialize)(this.gridControl1)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.categoriesBindingSource)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.nwindDataSet)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.cardView1)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.repositoryItemPictureEdit1)).BeginInit();
this.SuspendLayout();
//
// gridControl1
//
this.gridControl1.DataSource = this.categoriesBindingSource;
this.gridControl1.Dock = System.Windows.Forms.DockStyle.Fill;
this.gridControl1.EmbeddedNavigator.Name = "";
this.gridControl1.Location = new System.Drawing.Point(0, 0);
this.gridControl1.MainView = this.cardView1;
this.gridControl1.Name = "gridControl1";
this.gridControl1.RepositoryItems.AddRange(new DevExpress.XtraEditors.Repository.RepositoryItem[] {
this.repositoryItemPictureEdit1
});
this.gridControl1.Size = new System.Drawing.Size(627, 434);
this.gridControl1.TabIndex = 0;
this.gridControl1.ViewCollection.AddRange(new DevExpress.XtraGrid.Views.Base.BaseView[] {
this.cardView1
});
this.gridControl1.MouseLeave += new System.EventHandler(this.gridControl1_MouseLeave);
//
// categoriesBindingSource
//
this.categoriesBindingSource.DataMember = "Categories";
this.categoriesBindingSource.DataSource = this.nwindDataSet;
//
// nwindDataSet
//
this.nwindDataSet.DataSetName = "nwindDataSet";
this.nwindDataSet.SchemaSerializationMode = System.Data.SchemaSerializationMode.IncludeSchema;
//
// cardView1
//
this.cardView1.Columns.AddRange(new DevExpress.XtraGrid.Columns.GridColumn[] {
this.colCategoryID,
this.colCategoryName,
this.colDescription,
this.colPicture
});
this.cardView1.FocusedCardTopFieldIndex = 0;
this.cardView1.GridControl = this.gridControl1;
this.cardView1.Name = "cardView1";
this.cardView1.OptionsBehavior.FieldAutoHeight = true;
this.cardView1.VertScrollVisibility = DevExpress.XtraGrid.Views.Base.ScrollVisibility.Auto;
this.cardView1.CustomDrawCardFieldValue += new DevExpress.XtraGrid.Views.Base.RowCellCustomDrawEventHandler(this.cardView1_CustomDrawCardFieldValue);
this.cardView1.MouseMove += new System.Windows.Forms.MouseEventHandler(this.gridView1_MouseMove);
//
// colCategoryID
//
this.colCategoryID.Caption = "CategoryID";
this.colCategoryID.FieldName = "CategoryID";
this.colCategoryID.Name = "colCategoryID";
this.colCategoryID.Visible = true;
this.colCategoryID.VisibleIndex = 0;
//
// colCategoryName
//
this.colCategoryName.Caption = "CategoryName";
this.colCategoryName.FieldName = "CategoryName";
this.colCategoryName.Name = "colCategoryName";
this.colCategoryName.Visible = true;
this.colCategoryName.VisibleIndex = 1;
//
// colDescription
//
this.colDescription.Caption = "Description";
this.colDescription.FieldName = "Description";
this.colDescription.Name = "colDescription";
this.colDescription.Visible = true;
this.colDescription.VisibleIndex = 2;
//
// colPicture
//
this.colPicture.Caption = "Picture";
this.colPicture.ColumnEdit = this.repositoryItemPictureEdit1;
this.colPicture.FieldName = "Picture";
this.colPicture.Name = "colPicture";
this.colPicture.Visible = true;
this.colPicture.VisibleIndex = 3;
//
// repositoryItemPictureEdit1
//
this.repositoryItemPictureEdit1.Name = "repositoryItemPictureEdit1";
//
// categoriesTableAdapter
//
this.categoriesTableAdapter.ClearBeforeFill = true;
//
// Form1
//
this.AutoScaleBaseSize = new System.Drawing.Size(5, 13);
this.ClientSize = new System.Drawing.Size(627, 434);
this.Controls.Add(this.gridControl1);
this.Name = "Form1";
this.Text = "Form1";
this.Load += new System.EventHandler(this.Form1_Load);
((System.ComponentModel.ISupportInitialize)(this.gridControl1)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.categoriesBindingSource)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.nwindDataSet)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.cardView1)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.repositoryItemPictureEdit1)).EndInit();
this.ResumeLayout(false);
}
protected abstract void FillDataSource(OleDbConnection connection, nwindDataSet dataSource);
private void button1_Click(object sender, EventArgs e)
{
// Create a report, and specify its data source.
XtraReport report = new XtraReport();
nwindDataSet ds = new nwindDataSet();
new nwindDataSetTableAdapters.CategoryProductsTableAdapter().Fill(ds.CategoryProducts);
report.DataSource = ds;
report.DataMember = "CategoryProducts";
// Add a detail band and define its contents.
DetailBand detailBand = new DetailBand();
detailBand.Height = 100;
report.Bands.Add(detailBand);
XRLabel detailLabel = new XRLabel();
detailLabel.DataBindings.Add("Text", report.DataSource, "ProductName");
detailLabel.Width = 200;
detailBand.Controls.Add(detailLabel);
// Add a group header band and define its contents.
GroupHeaderBand ghBand = new GroupHeaderBand();
ghBand.Height = 20;
report.Bands.Add(ghBand);
XRLabel ghLabel = new XRLabel();
ghLabel.DataBindings.Add("Text", report.DataSource, "CategoryName");
ghLabel.Width = 200;
ghLabel.BackColor = Color.LightBlue;
ghBand.Controls.Add(ghLabel);
// Define a grouping criteria for the group header band.
GroupField groupField = new GroupField();
groupField.FieldName = "CategoryName";
ghBand.GroupFields.Add(groupField);
// Create a group footer band.
GroupFooterBand gfBand = new GroupFooterBand();
gfBand.Height = 20;
// You can force the group header to be repeated on each page.
gfBand.RepeatEveryPage = true;
// It's important to set its Band.PageBreak property to AfterBand,
// because the page numbers are displayed for the last group on a page.
// So, if there are two distinct groups appearing on the same page,
// this will result in improper page numbering.
gfBand.PageBreak = PageBreak.AfterBand;
report.Bands.Add(gfBand);
// Create an instance of the XRPageInfo control.
XRPageInfo pageInfo = new XRPageInfo();
// Set the group header band as the running band for this control.
pageInfo.RunningBand = ghBand;
// Adjust other properties of XRPageInfo.
pageInfo.Width = 200;
pageInfo.BackColor = Color.LightBlue;
pageInfo.PageInfo = PageInfo.NumberOfTotal;
pageInfo.Format = "Pages in this Group: {0} of {1}";
gfBand.Controls.Add(pageInfo);
// Show the report's print preview.
report.ShowPreview();
}
protected abstract void FillDataSource(OleDbConnection connection, nwindDataSet dataSource);
private void InitializeComponent()
{
this.Detail = new DevExpress.XtraReports.UI.DetailBand();
this.xrLabel1 = new DevExpress.XtraReports.UI.XRLabel();
this.xrLabel2 = new DevExpress.XtraReports.UI.XRLabel();
this.topMarginBand1 = new DevExpress.XtraReports.UI.TopMarginBand();
this.bottomMarginBand1 = new DevExpress.XtraReports.UI.BottomMarginBand();
this.nwindDataSet1 = new MinimalisticReportPreviewDemo.nwindDataSet();
this.productsTableAdapter = new MinimalisticReportPreviewDemo.nwindDataSetTableAdapters.ProductsTableAdapter();
this.ReportHeader = new DevExpress.XtraReports.UI.ReportHeaderBand();
((System.ComponentModel.ISupportInitialize)(this.nwindDataSet1)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this)).BeginInit();
//
// Detail
//
this.Detail.Controls.AddRange(new DevExpress.XtraReports.UI.XRControl[] {
this.xrLabel1
});
this.Detail.HeightF = 33.00001F;
this.Detail.Name = "Detail";
this.Detail.Padding = new DevExpress.XtraPrinting.PaddingInfo(0, 0, 0, 0, 100F);
this.Detail.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopLeft;
//
// xrLabel1
//
this.xrLabel1.BookmarkParent = this.xrLabel2;
this.xrLabel1.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] {
new DevExpress.XtraReports.UI.XRBinding("Text", null, "Products.ProductName"),
new DevExpress.XtraReports.UI.XRBinding("Bookmark", null, "Products.ProductName")
});
this.xrLabel1.Font = new System.Drawing.Font("Arial", 9.75F);
this.xrLabel1.LocationFloat = new DevExpress.Utils.PointFloat(10.00001F, 10.00001F);
this.xrLabel1.Name = "xrLabel1";
this.xrLabel1.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F);
this.xrLabel1.SizeF = new System.Drawing.SizeF(408.3333F, 23F);
this.xrLabel1.StylePriority.UseFont = false;
this.xrLabel1.StylePriority.UseTextAlignment = false;
this.xrLabel1.Text = "xrLabel1";
this.xrLabel1.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleLeft;
//
// xrLabel2
//
this.xrLabel2.Bookmark = "Home";
this.xrLabel2.Font = new System.Drawing.Font("Arial", 9.75F, System.Drawing.FontStyle.Bold);
this.xrLabel2.LocationFloat = new DevExpress.Utils.PointFloat(10.00001F, 10.00001F);
this.xrLabel2.Name = "xrLabel2";
this.xrLabel2.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F);
this.xrLabel2.SizeF = new System.Drawing.SizeF(222.9167F, 23F);
this.xrLabel2.StylePriority.UseFont = false;
this.xrLabel2.Text = "A sample report";
//
// topMarginBand1
//
this.topMarginBand1.HeightF = 48F;
this.topMarginBand1.Name = "topMarginBand1";
//
// bottomMarginBand1
//
this.bottomMarginBand1.HeightF = 48F;
this.bottomMarginBand1.Name = "bottomMarginBand1";
//
// nwindDataSet1
//
this.nwindDataSet1.DataSetName = "nwindDataSet";
this.nwindDataSet1.SchemaSerializationMode = System.Data.SchemaSerializationMode.IncludeSchema;
//
// productsTableAdapter
//
this.productsTableAdapter.ClearBeforeFill = true;
//
// ReportHeader
//
this.ReportHeader.Controls.AddRange(new DevExpress.XtraReports.UI.XRControl[] {
this.xrLabel2
});
this.ReportHeader.HeightF = 47F;
this.ReportHeader.Name = "ReportHeader";
//
// Report
//
this.Bands.AddRange(new DevExpress.XtraReports.UI.Band[] {
this.Detail,
this.topMarginBand1,
this.bottomMarginBand1,
this.ReportHeader
});
this.Bookmark = "Table of Contents";
this.DataAdapter = this.productsTableAdapter;
this.DataMember = "Products";
this.DataSource = this.nwindDataSet1;
this.FilterString = "[CategoryID] < 4";
this.Margins = new System.Drawing.Printing.Margins(49, 51, 48, 48);
this.Version = "12.2";
((System.ComponentModel.ISupportInitialize)(this.nwindDataSet1)).EndInit();
((System.ComponentModel.ISupportInitialize)(this)).EndInit();
}
