public override Android.Views.View GetSampleContent(Android.Content.Context context)
{
sfGrid = new SfDataGrid(context);
GridTextColumn product = new GridTextColumn();
product.MappingName = "Product";
product.HeaderTextMargin = new Thickness(8, 0, 0, 0);
product.TextMargin = new Thickness(8, 0, 0, 0);
sfGrid.Columns.Add(product);
GridTextColumn stockColumn = new GridTextColumn();
stockColumn.UserCellType = typeof(StockCell);
stockColumn.LoadUIView = true;
stockColumn.MappingName = "StockChange";
stockColumn.HeaderText = "Stock";
stockColumn.AllowSorting = false;
stockColumn.HeaderTextMargin = new Thickness(8, 0, 0, 0);
stockColumn.TextMargin = new Thickness(8, 0, 0, 0);
sfGrid.SelectionMode = SelectionMode.Single;
sfGrid.Columns.Add(stockColumn);
sfGrid.GridStyle.AlternatingRowColor = Color.Rgb(206, 206, 206);
sfGrid.AutoGeneratingColumn += GridAutoGenerateColumns;
sfGrid.ItemsSource = new RenderingDynamicDataViewModel().Stocks;
sfGrid.VerticalOverScrollMode = VerticalOverScrollMode.None;
return(sfGrid);
}
public Formatting()
{
SfGrid = new SfDataGrid();
GridImageColumn customerImageColumn = new GridImageColumn();
customerImageColumn.MappingName = "CustomerImage";
customerImageColumn.HeaderText = "Image";
GridSwitchColumn isOpenColumn = new GridSwitchColumn();
isOpenColumn.MappingName = "IsOpen";
isOpenColumn.HeaderText = "Is Open";
isOpenColumn.AllowEditing = true;
isOpenColumn.TextAlignment = UITextAlignment.Left;
isOpenColumn.TextMargin = new Thickness(30, 16, 5, 6);
GridTextColumn customerIdColumn = new GridTextColumn();
customerIdColumn.MappingName = "CustomerID";
customerIdColumn.HeaderText = "Customer ID";
customerIdColumn.TextAlignment = UITextAlignment.Center;
GridTextColumn currentColumn = new GridTextColumn();
currentColumn.MappingName = "Current";
currentColumn.Format = "C";
currentColumn.CultureInfo = new CultureInfo("en-US");
currentColumn.TextAlignment = UITextAlignment.Center;
GridTextColumn customerNameColumn = new GridTextColumn();
customerNameColumn.MappingName = "CustomerName";
customerNameColumn.HeaderText = "Customer Name";
customerNameColumn.TextMargin = 10;
customerNameColumn.TextAlignment = UITextAlignment.Left;
GridTextColumn savingsColumn = new GridTextColumn();
savingsColumn.MappingName = "Savings";
savingsColumn.Format = "C";
savingsColumn.CultureInfo = new CultureInfo("en-US");
savingsColumn.TextAlignment = UITextAlignment.Center;
SfGrid.Columns.Add(customerImageColumn);
SfGrid.Columns.Add(customerIdColumn);
SfGrid.Columns.Add(currentColumn);
SfGrid.Columns.Add(customerNameColumn);
SfGrid.Columns.Add(isOpenColumn);
SfGrid.Columns.Add(savingsColumn);
SfGrid.AutoGenerateColumns = false;
this.SfGrid.SelectionMode = SelectionMode.Single;
SfGrid.ItemsSource = new FormattingViewModel().BankInfo;
SfGrid.GridStyle.AlternatingRowColor = UIColor.FromRGB(219, 219, 219);
SfGrid.SelectionMode = SelectionMode.Single;
SfGrid.HeaderRowHeight = 45;
SfGrid.RowHeight = 65;
this.AddSubview(SfGrid);
}
public override Android.Views.View GetSampleContent(Android.Content.Context context)
{
sfGrid = new SfDataGrid(context);
sfGrid.ColumnSizer = ColumnSizer.None;
sfGrid.SelectionMode = SelectionMode.Single;
sfGrid.QueryRowHeight += HandleQueryRowHeightEventHandler;
viewModel = new AutoRowHeightViewModel();
sfGrid.AutoGeneratingColumn += GridAutoGenerateColumns;
sfGrid.ItemsSource = (viewModel.ReleaseInformation);
sfGrid.VerticalOverScrollMode = VerticalOverScrollMode.None;
sfGrid.Alpha = 0.87f;
if (MainActivity.isTablet)
{
GridTextColumn sno = new GridTextColumn();
sno.MappingName = "SNo";
sno.HeaderText = "S.No";
sno.ColumnSizer = ColumnSizer.Auto;
sno.HeaderTextAlignment = GravityFlags.Center;
sno.TextAlignment = GravityFlags.Center;
this.sfGrid.Columns.Insert(0, sno);
this.sfGrid.ColumnSizer = ColumnSizer.Star;
}
return(sfGrid);
}
public void PopulateWithJobs()
{
reportsDataGrid.Columns.Clear();
reportsDataGrid.ItemsSource = jobReports;
GridTextColumn jobNameColumn = new GridTextColumn();
jobNameColumn.MappingName = "JobName";
jobNameColumn.HeaderText = "Job Name";
reportsDataGrid.Columns.Add(jobNameColumn);
GridTextColumn baseNameColumn = new GridTextColumn();
baseNameColumn.MappingName = "BaseIncome";
baseNameColumn.HeaderText = "Base Cost/HR";
reportsDataGrid.GroupColumnDescriptions.Add(new GroupColumnDescription()
{
ColumnName = "CustomerName"
});
reportsDataGrid.Columns.Add(baseNameColumn);
}
public void PopulateWithWorkers()
{
reportsDataGrid.Columns.Clear();
reportsDataGrid.ItemsSource = employeeReports;
GridTextColumn workerNameColumn = new GridTextColumn();
workerNameColumn.MappingName = "WorkerLastName";
workerNameColumn.HeaderText = "Worker";
reportsDataGrid.Columns.Add(workerNameColumn);
GridTextColumn daysOffColumn = new GridTextColumn();
daysOffColumn.MappingName = "DaysOff";
daysOffColumn.HeaderText = "Days Off";
reportsDataGrid.Columns.Add(daysOffColumn);
GridTextColumn daysWorkedColumn = new GridTextColumn();
daysWorkedColumn.MappingName = "DaysWorked";
daysWorkedColumn.HeaderText = "Days Scheduled";
reportsDataGrid.Columns.Add(daysWorkedColumn);
}
public void AddColumns(List <string> data)
{
for (int i = 0; i < data.Count - 1; i += 2)
{
GridTextColumn column = new GridTextColumn();
column.HeaderText = data[i];
ColNames.Add(data[i]);
switch (data[i + 1])
{
case "string":
column.MappingName = "Str" + i / 2;
ColTypes.Add(COL_TYPE.STRING);
break;
case "currency":
column.MappingName = "Num" + i / 2;
ColTypes.Add(COL_TYPE.CURRENCY);
column.Format = "C";
break;
case "number":
column.MappingName = "Num" + i / 2;
ColTypes.Add(COL_TYPE.DOUBLE);
break;
default:
column.MappingName = "Str" + i / 2;
ColTypes.Add(COL_TYPE.STRING);
break;
}
m_grid.Columns.Add(column);
}
}
private void selectedColumnComboBox_SelectedIndexChanged(object sender, EventArgs e)
{
string selectedValue = this.selectedColumnComboBox.GetItemText(this.selectedColumnComboBox.SelectedItem);
if (string.IsNullOrEmpty(selectedValue) || this.sfDataGrid1.Columns[selectedValue] == null)
{
return;
}
GridTextColumn textColumn = sfDataGrid1.Columns[selectedValue] as GridTextColumn;
if (textColumn != null)
{
this.colAllowEditingCheckBox.Checked = textColumn.AllowEditing;
this.allowMultilineCheckBox.Checked = textColumn.AllowMultiline;
this.wordWrapCheckBox.Checked = textColumn.AllowTextWrapping;
this.verticalScrollBarCheckBox.Checked = textColumn.AllowVerticalScrollbar;
}
else
{
this.colAllowEditingCheckBox.Checked =
this.wordWrapCheckBox.Checked = this.verticalScrollBarCheckBox.Checked = false;
this.allowEditingCheckBox.Checked = true;
}
}
public SampleViewController() : base("SampleViewController", null)
{
sfGrid = new SfDataGrid();
sfGrid.AutoGenerateColumns = false;
viewModel = new ViewModel();
sfGrid.ItemsSource = viewModel.ProductDetails;
productNameColumn = new GridTextColumn();
productNameColumn.MappingName = "ProductName";
productNameColumn.HeaderText = "Product Name Column Header";
productNameColumn.HeaderTextAlignment = UITextAlignment.Left;
productNameColumn.TextAlignment = UITextAlignment.Left;
productNameColumn.TextMargin = 10;
sfGrid.Columns.Add(productNameColumn);
priceColumn = new GridTextColumn();
priceColumn.MappingName = "Price";
priceColumn.HeaderText = "Price";
priceColumn.HeaderTextAlignment = UITextAlignment.Right;
priceColumn.TextAlignment = UITextAlignment.Right;
priceColumn.TextMargin = 10;
sfGrid.Columns.Add(priceColumn);
sfGrid.HeaderRowHeight = 60;
sfGrid.CellRenderers.Remove("HeaderView");
sfGrid.CellRenderers.Add("HeaderView", new CustomGridHeaderCellRenderer());
}
public AutoRowHeight()
{
this.SfGrid = new SfDataGrid();
this.SfGrid.AllowSorting = false;
this.SfGrid.SelectionMode = SelectionMode.Single;
this.SfGrid.AllowTriStateSorting = false;
this.SfGrid.AlternationCount = 2;
this.SfGrid.ColumnSizer = ColumnSizer.None;
this.SfGrid.AutoGeneratingColumn += GridAutoGenerateColumns;
this.SfGrid.ItemsSource = new AutoRowHeightViewModel().ReleaseInformation;
this.SfGrid.ShowRowHeader = false;
this.SfGrid.HeaderRowHeight = 45;
this.SfGrid.QueryRowHeight += GridQueryRowHeight;
if (!UserInterfaceIdiomIsPhone)
{
GridTextColumn sno = new GridTextColumn();
sno.MappingName = "SNo";
sno.HeaderText = "S.No";
sno.ColumnSizer = ColumnSizer.Auto;
sno.HeaderTextAlignment = UITextAlignment.Center;
sno.TextAlignment = UITextAlignment.Center;
this.SfGrid.Columns.Insert(0, sno);
this.SfGrid.ColumnSizer = ColumnSizer.Star;
}
this.AddSubview(SfGrid);
}
/// <summary>
/// Formats a Grid Column based on the Settings
/// </summary>
/// <param name = "setting"></param>
public static GridColumn FormatGridColumn(GridViewColumn setting)
{
GridColumn column;
switch (setting.Type.ToLower())
{
case "image":
column = new GridImageColumn();
//((GridImageColumn)column) = new Bitmap(1, 1); // Default empty Image
break;
case "process":
column = new GridPercentColumn();
break;
case "check":
column = new GridCheckBoxColumn();
break;
case "rating":
//column = new DataGridViewRatingColumn();
column = new GridTextColumn();
break;
default:
column = new GridTextColumn();
break;
}
column.HeaderText = setting.Title;
column.IsReadOnly = setting.Readonly;
column.IsHidden = !setting.Display;
column.Width = setting.Width;
//column.IsFrozen = setting.Frozen;
// For columns bound to a data Source set the property
//if (setting.Bound)
//{
column.MappingName = setting.Name;
//}
switch (setting.Type.ToLower())
{
case "text":
case "process":
// column.ValueType = typeof(string);
break;
case "number":
case "check":
case "rating":
// column.ValueType = typeof(int);
break;
}
return(column);
}
public CLRObjects()
{
label = new UILabel();
label1 = new UILabel();
button = new UIButton(UIButtonType.System);
button.TouchUpInside += OnButtonClicked;
btnInput = new UIButton(UIButtonType.System);
btnInput.TouchUpInside += OnButtonInputClicked;
btnImport = new UIButton(UIButtonType.System);
btnImport.TouchUpInside += OnButtonImportClicked;
sfGrid = new SfDataGrid();
viewmodel = new CLRObjectViewModel();
sfGrid.AutoGenerateColumns = false;
sfGrid.RowHeight = 50;
sfGrid.AllowEditing = true;
sfGrid.EditTapAction = TapAction.OnTap;
sfGrid.ColumnSizer = ColumnSizer.Star;
sfGrid.SelectionMode = SelectionMode.None;
sfGrid.HeaderRowHeight = 40;
sfGrid.ItemsSource = viewmodel.CustomersInfo;
GridTextColumn salesPerson = new GridTextColumn();
salesPerson.MappingName = "SalesPerson";
salesPerson.HeaderText = "Name";
salesPerson.HeaderTextAlignment = UIKit.UITextAlignment.Center;
GridTextColumn salesJanJune = new GridTextColumn();
salesJanJune.MappingName = "SalesJanJune";
salesJanJune.HeaderText = "Jan-June";
salesPerson.HeaderTextAlignment = UIKit.UITextAlignment.Center;
GridTextColumn salesJulyDec = new GridTextColumn();
salesJulyDec.MappingName = "SalesJulyDec";
salesJulyDec.HeaderText = "July-Dec";
salesPerson.HeaderTextAlignment = UIKit.UITextAlignment.Center;
GridTextColumn change = new GridTextColumn();
change.MappingName = "Change";
change.HeaderText = "Change";
salesPerson.HeaderTextAlignment = UIKit.UITextAlignment.Center;
sfGrid.Columns.Add(salesPerson);
sfGrid.Columns.Add(salesJanJune);
sfGrid.Columns.Add(salesJulyDec);
sfGrid.Columns.Add(change);
this.AddSubview(sfGrid);
}
public void GenerateColumns()
{
ComboGrid.Columns.Clear();
for (var i = 0; i < ComboTable.Columns.Count; i++)
{
GridColumn column = new GridTextColumn
{
MappingName = ComboTable.Columns[i].ColumnName,
HeaderText = ComboTable.Columns[i].ColumnName
};
ComboGrid.Columns.Add(column);
}
}
private void SetupDataGrid()
{
// For demonstration purposes, set the non-default values for the SFDataGrid
sfDataGridSample.AddNewRowPosition = RowPosition.Bottom;
sfDataGridSample.AllowDeleting = true;
sfDataGridSample.AllowDraggingColumns = true;
sfDataGridSample.AllowGrouping = false;
sfDataGridSample.AllowResizingColumns = true;
sfDataGridSample.AllowSelectionOnMouseDown = true;
sfDataGridSample.AutoGenerateColumns = false;
sfDataGridSample.EditMode = EditMode.SingleClick;
sfDataGridSample.EditorSelectionBehavior = EditorSelectionBehavior.SelectAll;
sfDataGridSample.SelectionUnit = SelectionUnit.Cell;
sfDataGridSample.ShowRowHeader = true;
sfDataGridSample.AutoSizeColumnsMode = AutoSizeColumnsMode.Fill;
sfDataGridSample.ValidationMode = GridValidationMode.InEdit;
// Setup our event handler
sfDataGridSample.SelectionChanged += sfDataGridUpdate_SelectionChanged;
// For demonstration purposes, set the non-default values for the columns
GridDateTimeColumn col1 = (GridDateTimeColumn)sfDataGridSample.Columns["DateValue"];
col1.CellStyle.HorizontalAlignment = HorizontalAlignment.Center;
col1.Pattern = DateTimePattern.ShortDate;
col1.ShowDropDownButton = false;
col1.AllowDragging = true;
col1.ValidationMode = GridValidationMode.InView;
col1.DateTimeEditingMode = DateTimeEditingMode.Default;
col1.AllowGrouping = false;
col1.AllowResizing = true;
GridDateTimeColumn col2 = (GridDateTimeColumn)sfDataGridSample.Columns["TimeValue"];
col2.CellStyle.HorizontalAlignment = HorizontalAlignment.Center;
col2.Pattern = DateTimePattern.ShortTime;
col2.ShowDropDownButton = false;
col2.AllowDragging = true;
col2.ValidationMode = GridValidationMode.InView;
col2.DateTimeEditingMode = DateTimeEditingMode.Default;
col2.AllowGrouping = false;
col2.AllowResizing = true;
GridTextColumn col3 = (GridTextColumn)sfDataGridSample.Columns["StringValue"];
col3.CellStyle.HorizontalAlignment = HorizontalAlignment.Left;
col3.AllowDragging = true;
col3.ValidationMode = GridValidationMode.InEdit;
col3.AllowGrouping = false;
col3.AllowResizing = true;
}
public override View GetSampleContent(Context context)
{
sfGrid = new SfDataGrid(context);
viewmodel = new EditingViewModel();
sfGrid.AutoGenerateColumns = false;
sfGrid.RowHeight = 50;
sfGrid.AllowEditing = true;
sfGrid.EditTapAction = TapAction.OnTap;
sfGrid.ColumnSizer = ColumnSizer.Star;
sfGrid.SelectionMode = SelectionMode.Single;
sfGrid.NavigationMode = NavigationMode.Cell;
sfGrid.HeaderRowHeight = 40;
sfGrid.ItemsSource = viewmodel.DealerInformation;
sfGrid.VerticalOverScrollMode = VerticalOverScrollMode.None;
GridNumericColumn productPrice = new GridNumericColumn();
productPrice.MappingName = "ProductPrice";
productPrice.HeaderText = "Product Price";
productPrice.HeaderTextAlignment = GravityFlags.Center;
GridDateTimeColumn shippedDate = new GridDateTimeColumn();
shippedDate.MappingName = "ShippedDate";
shippedDate.HeaderText = "Shipped Date";
shippedDate.HeaderTextAlignment = GravityFlags.Center;
shippedDate.Format = "d";
GridPickerColumn dealerName = new GridPickerColumn();
dealerName.MappingName = "DealerName";
dealerName.HeaderText = "Dealer Name";
dealerName.ItemsSource = viewmodel.CustomerNames;
dealerName.HeaderTextAlignment = GravityFlags.Center;
GridTextColumn productNo = new GridTextColumn();
productNo.MappingName = "ProductNo";
productNo.HeaderText = "Product No";
productNo.HeaderTextAlignment = GravityFlags.Center;
sfGrid.Columns.Add(productNo);
sfGrid.Columns.Add(dealerName);
sfGrid.Columns.Add(shippedDate);
sfGrid.Columns.Add(productPrice);
return(sfGrid);
}
public override Android.Views.View GetSampleContent (Android.Content.Context context)
{
sfGrid = new SfDataGrid (context);
GridTextColumn stockColumn = new GridTextColumn ();
stockColumn.UserCellType = typeof(StockCell);
stockColumn.LoadUIView = true;
stockColumn.MappingName = "StockChange";
stockColumn.HeaderText = "Stock Change";
stockColumn.AllowSorting = false;
sfGrid.Columns.Add (stockColumn);
sfGrid.AlternatingRowColor = Color.Rgb (206, 206, 206);
sfGrid.AutoGeneratingColumn += GridAutoGenerateColumns;
sfGrid.ItemsSource = new RenderingDynamicDataViewModel ().Stocks;
return sfGrid;
}
private void verticalScrollBarCheckBox_CheckedChanged(object sender, EventArgs e)
{
string selectedValue = this.selectedColumnComboBox.GetItemText(this.selectedColumnComboBox.SelectedItem);
if (string.IsNullOrEmpty(selectedValue) || this.sfDataGrid1.Columns[selectedValue] == null)
{
return;
}
GridTextColumn textColumn = sfDataGrid1.Columns[selectedValue] as GridTextColumn;
if (textColumn != null)
{
textColumn.AllowVerticalScrollbar = verticalScrollBarCheckBox.Checked;
}
}
public Form1()
{
InitializeComponent();
sfDataGrid.AutoGenerateColumns = false;
sfDataGrid.DataSource = new ViewModel().Orders;
sfDataGrid.LiveDataUpdateMode = LiveDataUpdateMode.AllowDataShaping;
sfDataGrid.AllowEditing = true;
sfDataGrid.AutoSizeColumnsMode = AutoSizeColumnsMode.AllCells;
sfDataGrid.AddNewRowPosition = RowPosition.Top;
GridNumericColumn gridTextColumn1 = new GridNumericColumn()
{
MappingName = "OrderID", HeaderText = "Order ID"
};
GridTextColumn gridTextColumn2 = new GridTextColumn()
{
MappingName = "CustomerID", HeaderText = "Customer ID", AllowEditing = true
};
GridTextColumn gridTextColumn3 = new GridTextColumn()
{
MappingName = "CustomerName", HeaderText = "Customer Name"
};
GridTextColumn gridTextColumn4 = new GridTextColumn()
{
MappingName = "Country", HeaderText = "Country"
};
GridTextColumn gridTextColumn5 = new GridTextColumn()
{
MappingName = "ShipCity", HeaderText = "Ship City"
};
GridCheckBoxColumn checkBoxColumn = new GridCheckBoxColumn()
{
MappingName = "IsShipped", HeaderText = "Is Shipped"
};
// enable the context menu for new records
sfDataGrid.RecordContextMenu = new ContextMenuStrip();
sfDataGrid.RecordContextMenu.Items.Add("Copy", null, OnBuscarMenuClicked);
sfDataGrid.Columns.Add(gridTextColumn1);
sfDataGrid.Columns.Add(gridTextColumn2);
sfDataGrid.Columns.Add(gridTextColumn3);
sfDataGrid.Columns.Add(gridTextColumn4);
sfDataGrid.Columns.Add(gridTextColumn5);
sfDataGrid.Columns.Add(checkBoxColumn);
sfDataGrid.TableControl.MouseUp += SfDataGrid_MouseUp;
}
public override Android.Views.View GetSampleContent(Android.Content.Context context)
{
sfGrid = new SfDataGrid(context);
GridTextColumn stockColumn = new GridTextColumn();
stockColumn.UserCellType = typeof(StockCell);
stockColumn.LoadUIView = true;
stockColumn.MappingName = "StockChange";
stockColumn.HeaderText = "Stock Change";
stockColumn.AllowSorting = false;
sfGrid.Columns.Add(stockColumn);
sfGrid.AlternatingRowColor = Color.Rgb(206, 206, 206);
sfGrid.AutoGeneratingColumn += GridAutoGenerateColumns;
sfGrid.ItemsSource = new RenderingDynamicDataViewModel().Stocks;
return(sfGrid);
}
public Editing()
{
sfGrid = new SfDataGrid();
viewmodel = new EditingViewModel();
sfGrid.AutoGenerateColumns = false;
sfGrid.RowHeight = 50;
sfGrid.AllowEditing = true;
sfGrid.SelectionMode = SelectionMode.Single;
sfGrid.NavigationMode = NavigationMode.Cell;
sfGrid.EditTapAction = TapAction.OnTap;
sfGrid.ColumnSizer = ColumnSizer.Star;
sfGrid.HeaderRowHeight = 40;
sfGrid.ItemsSource = viewmodel.DealerInformation;
GridNumericColumn productPrice = new GridNumericColumn();
productPrice.MappingName = "ProductPrice";
productPrice.HeaderText = "Product Price";
productPrice.HeaderTextAlignment = UIKit.UITextAlignment.Center;
GridDateTimeColumn shippedDate = new GridDateTimeColumn();
shippedDate.MappingName = "ShippedDate";
shippedDate.HeaderText = "Shipped Date";
shippedDate.Format = "d";
shippedDate.HeaderTextAlignment = UIKit.UITextAlignment.Center;
GridPickerColumn dealerName = new GridPickerColumn();
dealerName.MappingName = "DealerName";
dealerName.HeaderText = "Dealer Name";
dealerName.ItemsSource = viewmodel.CustomerNames;
dealerName.HeaderTextAlignment = UIKit.UITextAlignment.Center;
GridTextColumn productNo = new GridTextColumn();
productNo.MappingName = "ProductNo";
productNo.HeaderText = "Product No";
productNo.HeaderTextAlignment = UIKit.UITextAlignment.Center;
sfGrid.Columns.Add(productNo);
sfGrid.Columns.Add(dealerName);
sfGrid.Columns.Add(shippedDate);
sfGrid.Columns.Add(productPrice);
this.AddSubview(sfGrid);
}
private void CreateDataGrid()
{
datagrid = new SfDataGrid();
viewModel = new TicketBookingViewModel();
datagrid.AutoGenerateColumns = false;
datagrid.ColumnSizer = ColumnSizer.Star;
datagrid.RowHeight = 117;
GridTextColumn movieList = new GridTextColumn();
movieList.HeaderText = "Movies List";
movieList.HeaderTextAlignment = UIKit.UITextAlignment.Center;
movieList.UserCellType = typeof(MovieTile);
datagrid.Columns.Add(movieList);
datagrid.ItemsSource = viewModel.TheaterInformation;
}
public RenderingDynamicData ()
{
this.SfGrid = new SfDataGrid ();
GridTextColumn stockColumn = new GridTextColumn ();
stockColumn.UserCellType = typeof(StockCell);
stockColumn.MappingName = "StockChange";
stockColumn.HeaderText = "Stock Change";
stockColumn.AllowSorting = false;
this.SfGrid.Columns.Add (stockColumn);
this.SfGrid.AutoGeneratingColumn += GridAutoGenerateColumns;
this.SfGrid.ItemsSource = new StocksViewModel ().Stocks;
this.SfGrid.HeaderRowHeight = 45;
this.SfGrid.RowHeight = 45;
this.SfGrid.AlternatingRowColor = UIColor.FromRGB (219, 219, 219);
this.control = this;
this.AddSubview (SfGrid);
}
public EFGridViewandroid_metadatum()
{
InitializeComponent();
ctx = new moviesContext();
GridTextColumn collocale = new GridTextColumn();
collocale.MappingName = "locale";
dataGrid.Columns.Add(collocale);
GetQuery();
}
async void Book_TouchUpInside(object sender, EventArgs e)
{
dataGrid = this.DataColumn.Renderer.DataGrid;
AddBackgroundView();
dataGrid.Columns.RemoveAt(0);
dataGrid.HeaderRowHeight = 62;
GridTextColumn theaterList = new GridTextColumn();
theaterList.HeaderText = "Movies List";
theaterList.HeaderTemplate = CreateDateViewTemplate();
theaterList.HeaderTextAlignment = UIKit.UITextAlignment.Center;
theaterList.UserCellType = typeof(TheaterTile);
dataGrid.Columns.Add(theaterList);
await Task.Delay(100);
LoopView();
}
public CollectionObjects()
{
label = new UILabel();
label1 = new UILabel();
button = new UIButton(UIButtonType.System);
button.TouchUpInside += OnButtonClicked;
btnInput = new UIButton(UIButtonType.System);
btnInput.TouchUpInside += OnButtonInputClicked;
btnImport = new UIButton(UIButtonType.System);
btnImport.TouchUpInside += OnButtonImportClicked;
sfGrid = new SfDataGrid();
viewmodel = new CLRObjectViewModel();
sfGrid.AutoGenerateColumns = false;
sfGrid.RowHeight = 50;
sfGrid.AllowEditing = true;
sfGrid.EditTapAction = TapAction.OnTap;
sfGrid.ColumnSizer = ColumnSizer.Star;
sfGrid.SelectionMode = SelectionMode.None;
sfGrid.HeaderRowHeight = 40;
sfGrid.ItemsSource = viewmodel.CustomersInfo;
GridTextColumn brand = new GridTextColumn();
brand.MappingName = "BrandName";
brand.HeaderText = "Brand";
brand.HeaderTextAlignment = UIKit.UITextAlignment.Center;
GridTextColumn vehicleType = new GridTextColumn();
vehicleType.MappingName = "VehicleType.VehicleName";
vehicleType.HeaderText = "Vehicle Type";
vehicleType.HeaderTextAlignment = UIKit.UITextAlignment.Center;
GridTextColumn model = new GridTextColumn();
model.MappingName = "VehicleType.Model.ModelName";
model.HeaderText = "Model";
model.HeaderTextAlignment = UIKit.UITextAlignment.Center;
sfGrid.Columns.Add(brand);
sfGrid.Columns.Add(vehicleType);
sfGrid.Columns.Add(model);
this.AddSubview(sfGrid);
}
public RenderingDynamicData()
{
this.SfGrid = new SfDataGrid();
GridTextColumn stockColumn = new GridTextColumn();
stockColumn.UserCellType = typeof(StockCell);
stockColumn.MappingName = "StockChange";
stockColumn.HeaderText = "Stock Change";
stockColumn.AllowSorting = false;
this.SfGrid.Columns.Add(stockColumn);
this.SfGrid.AutoGeneratingColumn += GridAutoGenerateColumns;
this.SfGrid.ItemsSource = new StocksViewModel().Stocks;
this.SfGrid.HeaderRowHeight = 45;
this.SfGrid.RowHeight = 45;
this.SfGrid.AlternatingRowColor = UIColor.FromRGB(219, 219, 219);
this.control = this;
this.AddSubview(SfGrid);
}
public Form1()
{
InitializeComponent();
sfDataGrid.AutoGenerateColumns = false;
sfDataGrid.DataSource = new ViewModel().Orders;
sfDataGrid.ShowRowHeader = true;
sfDataGrid.LiveDataUpdateMode = LiveDataUpdateMode.AllowDataShaping;
sfDataGrid.ShowGroupDropArea = true;
GridTextColumn gridTextColumn1 = new GridTextColumn()
{
MappingName = "OrderID", HeaderText = "Order ID"
};
GridTextColumn gridTextColumn2 = new GridTextColumn()
{
MappingName = "CustomerID", HeaderText = "Customer ID"
};
GridTextColumn gridTextColumn3 = new GridTextColumn()
{
MappingName = "CustomerName", HeaderText = "Customer Name"
};
GridTextColumn gridTextColumn4 = new GridTextColumn()
{
MappingName = "Country", HeaderText = "Country"
};
GridTextColumn gridTextColumn5 = new GridTextColumn()
{
MappingName = "ShipCity", HeaderText = "Ship City"
};
GridCheckBoxColumn checkBoxColumn = new GridCheckBoxColumn()
{
MappingName = "IsShipped", HeaderText = "Is Shipped"
};
sfDataGrid.Columns.Add(gridTextColumn1);
sfDataGrid.Columns.Add(gridTextColumn2);
sfDataGrid.Columns.Add(gridTextColumn3);
sfDataGrid.Columns.Add(gridTextColumn4);
sfDataGrid.Columns.Add(gridTextColumn5);
sfDataGrid.Columns.Add(checkBoxColumn);
btnExportExcel.Click += BtnExportExcel_Click;
sfDataGrid.DrawCell += SfDataGrid_DrawCell;
}
/// <summary>
/// Fired when DataGrid view is created.
/// </summary>
/// <param name="sender">DataGrid_GridViewCreated sender</param>
/// <param name="e">GridViewCreatedEventArgs parameter e</param>
private void DataGrid_GridViewCreated(object sender, GridViewCreatedEventArgs e)
{
if (Device.Idiom != TargetIdiom.Phone)
{
GridTextColumn serialNumberColumn = new GridTextColumn();
serialNumberColumn.MappingName = "SNo";
serialNumberColumn.HeaderText = "S.No";
serialNumberColumn.ColumnSizer = ColumnSizer.Auto;
serialNumberColumn.HeaderFontAttribute = FontAttributes.Bold;
serialNumberColumn.HeaderTextAlignment = TextAlignment.Start;
serialNumberColumn.TextAlignment = TextAlignment.End;
GridTextColumn releaseDataColumn = new GridTextColumn();
releaseDataColumn.MappingName = "DateOfRelease";
releaseDataColumn.HeaderText = "Release Date";
releaseDataColumn.Padding = 5;
releaseDataColumn.ColumnSizer = ColumnSizer.Auto;
releaseDataColumn.HeaderFontAttribute = FontAttributes.Bold;
releaseDataColumn.HeaderTextAlignment = TextAlignment.Start;
releaseDataColumn.TextAlignment = TextAlignment.Start;
if (Device.RuntimePlatform == Device.Android || (Device.RuntimePlatform == Device.iOS))
{
serialNumberColumn.HeaderCellTextSize = 14;
serialNumberColumn.CellTextSize = 14;
serialNumberColumn.Padding = new Thickness(16, 12, 8, 12);
releaseDataColumn.HeaderCellTextSize = 14;
releaseDataColumn.CellTextSize = 14;
releaseDataColumn.Padding = new Thickness(8, 12, 8, 12);
}
else
{
serialNumberColumn.HeaderCellTextSize = 12;
serialNumberColumn.CellTextSize = 12;
serialNumberColumn.Padding = new Thickness(8, 12, 8, 16);
releaseDataColumn.HeaderCellTextSize = 12;
releaseDataColumn.CellTextSize = 12;
releaseDataColumn.Padding = new Thickness(8, 12, 8, 16);
}
this.dataGrid.Columns.Insert(0, serialNumberColumn);
this.dataGrid.Columns.Insert(4, releaseDataColumn);
}
}
public AutoRowHeight()
{
InitializeComponent();
this.dataGrid.ItemsSource = viewModel.ReleaseInformation;
this.dataGrid.QueryRowHeight += DataGrid_QueryRowHeight;
this.dataGrid.VerticalOverScrollMode = VerticalOverScrollMode.None;
if (Device.Idiom != TargetIdiom.Phone)
{
GridTextColumn sno = new GridTextColumn();
sno.MappingName = "SNo";
sno.HeaderText = "S.No";
sno.Padding = 5;
sno.ColumnSizer = ColumnSizer.Auto;
sno.HeaderFontAttribute = FontAttributes.Bold;
sno.HeaderTextAlignment = TextAlignment.Center;
sno.TextAlignment = TextAlignment.Center;
this.dataGrid.Columns.Insert(0, sno);
}
}
public Form1()
{
InitializeComponent();
//To add custom renderer into SfDataGrid.
this.sfDataGrid.CellRenderers.Add("TextButton", new GridTextButtonCellRenderer(this.sfDataGrid));
sfDataGrid.AutoGenerateColumns = false;
sfDataGrid.DataSource = new ViewModel().Orders;
sfDataGrid.LiveDataUpdateMode = LiveDataUpdateMode.AllowDataShaping;
GridTextColumn gridTextColumn1 = new GridTextColumn()
{
MappingName = "OrderID", HeaderText = "Order ID"
};
GridTextColumn gridTextColumn3 = new GridTextColumn()
{
MappingName = "CustomerName", HeaderText = "Customer Name"
};
GridTextColumn gridTextColumn4 = new GridTextColumn()
{
MappingName = "Country", HeaderText = "Country"
};
GridTextColumn gridTextColumn5 = new GridTextColumn()
{
MappingName = "ShipCity", HeaderText = "Ship City"
};
GridCheckBoxColumn checkBoxColumn = new GridCheckBoxColumn()
{
MappingName = "IsShipped", HeaderText = "Is Shipped"
};
//To add TextButtonColumn in grid
this.sfDataGrid.Columns.Add(new GridTextButtonColumn()
{
MappingName = "CustomerID", Width = 140
});
sfDataGrid.Columns.Add(gridTextColumn1);
sfDataGrid.Columns.Add(gridTextColumn3);
sfDataGrid.Columns.Add(gridTextColumn4);
sfDataGrid.Columns.Add(gridTextColumn5);
sfDataGrid.Columns.Add(checkBoxColumn);
}
public tablaPalabras(List <PalabraEncontrada> arregloTokens, string mensajeLexico)
{
InitializeComponent();
//dataGrid = new SfDataGrid();
this.mensajeLexico = mensajeLexico;
viewModel = new PalabraEncontradaRepositorio();
dataGrid.AutoGenerateColumns = false;
viewModel.GenerateOrders(arregloTokens);
dataGrid.ItemsSource = viewModel.OrderInfoCollection;
GridTextColumn palabra = new GridTextColumn();
palabra.MappingName = "palabra";
palabra.ColumnSizer = ColumnSizer.Star;
GridTextColumn tipo = new GridTextColumn();
tipo.MappingName = "tipo";
tipo.ColumnSizer = ColumnSizer.LastColumnFill;
GridTextColumn descripcion = new GridTextColumn();
descripcion.MappingName = "descripcion";
descripcion.ColumnSizer = ColumnSizer.Star;
GridTextColumn indice = new GridTextColumn();
indice.MappingName = "indice";
GridTextColumn linea = new GridTextColumn();
linea.MappingName = "nLinea";
dataGrid.Columns.Add(palabra);
dataGrid.Columns.Add(tipo);
dataGrid.Columns.Add(descripcion);
dataGrid.Columns.Add(indice);
dataGrid.Columns.Add(linea);
btnErrorLexico.Clicked += BtnErrorLexico_Clicked;
}
public override void ViewDidLoad()
{
base.ViewDidLoad();
this.View.BackgroundColor = UIColor.White;
grid.ItemsSource = viewmodel.Info;
grid.BackgroundColor = UIColor.White;
grid.AutoGenerateColumns = false;
grid.ColumnSizer = ColumnSizer.Star;
grid.SelectionChanged += Grid_SelectionChanged;
grid.SelectionMode = SelectionMode.Single;
var textcolumn = new GridTextColumn
{
MappingName = "ID",
HeaderText = "ID"
};
//Creation of a template column
var textcolumn1 = new GridTextColumn
{
MappingName = "Name",
UserCellType = typeof(CustomCell), //Adding a custom cell into the template column
HeaderText = "Name"
};
var textcolumn2 = new GridTextColumn
{
MappingName = "Percentage",
HeaderText = "Percentage"
};
var textcolumn3 = new GridTextColumn
{
MappingName = "Remarks",
HeaderText = "Remarks"
};
grid.Columns.Add(textcolumn);
grid.Columns.Add(textcolumn1);
grid.Columns.Add(textcolumn2);
grid.Columns.Add(textcolumn3);
View.AddSubview(grid);
}
private GridColumn CreateSfColumn(Field field, int i)
{
GridColumn result;
DataType t = field.SchemaType == SchemaType.Data
? ((DataField)field).DataType
: DataType.String;
if (t == DataType.Int32 ||
t == DataType.Float ||
t == DataType.Double ||
t == DataType.Decimal)
{
result = new GridNumericColumn();
}
else if (t == DataType.DateTimeOffset)
{
result = new GridDateTimeColumn();
}
else if (t == DataType.Boolean)
{
result = new GridCheckBoxColumn();
}
else
{
result = new GridTextColumn()
{
TextWrapping = TextWrapping.NoWrap
};
}
result.MappingName = $"[{i}]";
result.HeaderText = field.Name;
result.AllowFiltering = false;
result.AllowFocus = true;
result.AllowResizing = true;
result.AllowSorting = true;
result.FilterBehavior = FilterBehavior.StronglyTyped;
result.AllowEditing = true;
return(result);
}
public Formatting ()
{
SfGrid = new SfDataGrid ();
GridTextColumn customerImageColumn = new GridTextColumn ();
customerImageColumn.UserCellType = typeof(GridImageCell);
customerImageColumn.MappingName = "CustomerImage";
customerImageColumn.HeaderText = "Image";
GridTextColumn isOpenColumn = new GridTextColumn ();
isOpenColumn.UserCellType = typeof(BoolFormatCell);
isOpenColumn.MappingName = "IsOpen";
isOpenColumn.HeaderText = "Is Open";
GridTextColumn balanceScaleColumn = new GridTextColumn ();
balanceScaleColumn.UserCellType = typeof(LinearGuageCell);
balanceScaleColumn.MappingName = "BalanceScale";
balanceScaleColumn.HeaderText = "Balance Scale";
GridTextColumn chartcell = new GridTextColumn ();
chartcell.UserCellType = typeof(LineChartCell);
chartcell.MappingName = "Transactions";
chartcell.HeaderText = "Transactions";
GridTextColumn customerIdColumn = new GridTextColumn ();
customerIdColumn.MappingName = "CustomerID";
customerIdColumn.HeaderText = "Customer ID";
customerIdColumn.TextAlignment = UITextAlignment.Center;
GridTextColumn currentColumn = new GridTextColumn ();
currentColumn.MappingName = "Current";
currentColumn.Format = "C";
currentColumn.CultureInfo = new CultureInfo ("en-US");
currentColumn.TextAlignment = UITextAlignment.Center;
GridTextColumn customerNameColumn = new GridTextColumn ();
customerNameColumn.MappingName = "CustomerName";
customerNameColumn.HeaderText = "Customer Name";
customerNameColumn.TextMargin = 10;
customerNameColumn.TextAlignment = UITextAlignment.Left;
GridTextColumn savingsColumn = new GridTextColumn ();
savingsColumn.MappingName = "Savings";
savingsColumn.Format = "C";
savingsColumn.CultureInfo = new CultureInfo ("en-US");
savingsColumn.TextAlignment = UITextAlignment.Center;
SfGrid.Columns.Add (customerImageColumn);
SfGrid.Columns.Add (chartcell);
SfGrid.Columns.Add (customerIdColumn);
SfGrid.Columns.Add (currentColumn);
SfGrid.Columns.Add (customerNameColumn);
SfGrid.Columns.Add (savingsColumn);
SfGrid.Columns.Add (balanceScaleColumn);
SfGrid.Columns.Add (isOpenColumn);
SfGrid.AutoGenerateColumns = false;
SfGrid.ItemsSource = new FormattingViewModel ().BankInfo;
SfGrid.AlternatingRowColor = UIColor.FromRGB (219, 219, 219);
SfGrid.SelectionMode = SelectionMode.Multiple;
SfGrid.HeaderRowHeight = 45;
SfGrid.RowHeight = 65;
this.control = this;
this.AddSubview (SfGrid);
}
public override Android.Views.View GetSampleContent (Android.Content.Context context)
{
GridTextColumn customerImageColumn = new GridTextColumn ();
customerImageColumn.UserCellType = typeof(GridImageCell);
customerImageColumn.MappingName = "CustomerImage";
customerImageColumn.HeaderText = "Image";
GridTextColumn isOpenColumn = new GridTextColumn ();
isOpenColumn.UserCellType = typeof(BoolFormatCell);
isOpenColumn.MappingName = "IsOpen";
isOpenColumn.HeaderText = "Is Open";
GridTextColumn customerIdColumn = new GridTextColumn ();
customerIdColumn.MappingName = "CustomerID";
customerIdColumn.HeaderText = "Customer ID";
customerIdColumn.TextAlignment = GravityFlags.Center;
GridTextColumn branchNoColumn = new GridTextColumn ();
branchNoColumn.MappingName = "BranchNo";
branchNoColumn.HeaderText = "Branch No";
branchNoColumn.TextAlignment = GravityFlags.Center;
GridTextColumn currentColumn = new GridTextColumn ();
currentColumn.MappingName = "Current";
currentColumn.Format = "C";
currentColumn.CultureInfo = new CultureInfo ("en-US");
currentColumn.TextAlignment = GravityFlags.Center;
GridTextColumn customerNameColumn = new GridTextColumn ();
customerNameColumn.MappingName = "CustomerName";
customerNameColumn.HeaderText = "Customer Name";
customerNameColumn.TextAlignment = GravityFlags.CenterVertical;
GridTextColumn savingsColumn = new GridTextColumn ();
savingsColumn.MappingName = "Savings";
savingsColumn.Format = "C";
savingsColumn.CultureInfo = new CultureInfo ("en-US");
savingsColumn.TextAlignment = GravityFlags.Center;
sfGrid = new SfDataGrid (context);
sfGrid.AutoGenerateColumns = false;
sfGrid.RowHeight = 80;
sfGrid.Columns.Add (customerImageColumn);
sfGrid.Columns.Add (customerIdColumn);
sfGrid.Columns.Add (branchNoColumn);
sfGrid.Columns.Add (currentColumn);
sfGrid.Columns.Add (customerNameColumn);
sfGrid.Columns.Add (savingsColumn);
sfGrid.Columns.Add (isOpenColumn);
viewmodel = new FormattingViewModel ();
sfGrid.ItemsSource = viewmodel.BankInfo;
sfGrid.AlternatingRowColor = Color.Rgb (206, 206, 206);
return sfGrid;
}
