or
RadPageView temp = new RadPageView() { Dock = DockStyle.Fill }; temp.ViewMode = PageViewMode.ExplorerBar;RadPageView temp = new RadPageView() { Dock = DockStyle.Fill }; temp.ViewMode = PageViewMode.Stack;Hello,
I'm looking for the Entity Framework equivalent of dataset's tableAdapter.Fill/tableAdapter.FillByBy.
Because they were reusable to refill a GridView (Windforms), possibly using a different 'where clause'.
The only way I know to fill/refill the GridView from DB now using EF with different parameters:
this.myBindingSource.DataSource = myNewSelectQueryObject;
the 'first fill' with this works fine, but the second one will cause the DataSource et the GirdView to be impossible to edit. (Although the BindingSource the GridView are NOT 'readonly'.) a,d EF.Refresh() doesn't seem to update records that could be in the DB but are not present in the 'EF'.
Thank you for your help.
Imports System.ComponentModel Imports Telerik.WinControls.UI Public Class Form1 Private Sub Form1_Load(sender As System.Object, e As System.EventArgs) Handles MyBase.Load TimeCardGrid.MasterTemplate.AutoSizeColumnsMode = Telerik.WinControls.UI.GridViewAutoSizeColumnsMode.Fill TimeCardBindingSource.DataSource = TimeCards.Retrieve() End Sub End Class Public Class TimeCard Public Property StartTime As DateTimeOffset? Public Property endTime As DateTimeOffset? End Class Public Class TimeCards Inherits BindingList(Of TimeCard) Public Shared Function Retrieve() As TimeCards Dim timeCardList As New TimeCards From {New TimeCard With {.StartTime = New DateTimeOffset(2011, 12, 8, 9, 45, 30, New TimeSpan(-8, 0, 0)), .endTime = New DateTimeOffset(2011, 12, 9, 11, 45, 30, New TimeSpan(-8, 0, 0))}, New TimeCard With {.StartTime = New DateTimeOffset(2011, 12, 11, 9, 45, 30, New TimeSpan(-8, 0, 0)), .endTime = New DateTimeOffset(2011, 12, 12, 11, 45, 30, New TimeSpan(-8, 0, 0))}} Return timeCardList End Function End Class <Global.Microsoft.VisualBasic.CompilerServices.DesignerGenerated()> _ Partial Class Form1 Inherits System.Windows.Forms.Form 'Form overrides dispose to clean up the component list. <System.Diagnostics.DebuggerNonUserCode()> _ Protected Overrides Sub Dispose(ByVal disposing As Boolean) Try If disposing AndAlso components IsNot Nothing Then components.Dispose() End If Finally MyBase.Dispose(disposing) End Try End Sub 'Required by the Windows Form Designer Private components As System.ComponentModel.IContainer 'NOTE: The following procedure is required by the Windows Form Designer 'It can be modified using the Windows Form Designer. 'Do not modify it using the code editor. <System.Diagnostics.DebuggerStepThrough()> _ Private Sub InitializeComponent() Me.components = New System.ComponentModel.Container() Dim GridViewDateTimeColumn1 As Telerik.WinControls.UI.GridViewDateTimeColumn = New Telerik.WinControls.UI.GridViewDateTimeColumn() Dim GridViewDateTimeColumn2 As Telerik.WinControls.UI.GridViewDateTimeColumn = New Telerik.WinControls.UI.GridViewDateTimeColumn() Me.TimeCardBindingSource = New System.Windows.Forms.BindingSource(Me.components) Me.TimeCardGrid = New Telerik.WinControls.UI.RadGridView() CType(Me.TimeCardBindingSource, System.ComponentModel.ISupportInitialize).BeginInit() CType(Me.TimeCardGrid, System.ComponentModel.ISupportInitialize).BeginInit() Me.SuspendLayout() ' 'TimeCardBindingSource ' Me.TimeCardBindingSource.DataSource = GetType(WindowsApplication9.TimeCard) ' 'TimeCardGrid ' Me.TimeCardGrid.Location = New System.Drawing.Point(12, 12) ' 'TimeCardGrid ' Me.TimeCardGrid.MasterTemplate.AllowAddNewRow = False Me.TimeCardGrid.MasterTemplate.AllowColumnChooser = False Me.TimeCardGrid.MasterTemplate.AllowColumnReorder = False Me.TimeCardGrid.MasterTemplate.AllowDeleteRow = False Me.TimeCardGrid.MasterTemplate.AllowDragToGroup = False Me.TimeCardGrid.MasterTemplate.AutoGenerateColumns = False GridViewDateTimeColumn1.DataType = GetType(System.Nullable(Of System.DateTimeOffset)) GridViewDateTimeColumn1.FieldName = "StartTime" GridViewDateTimeColumn1.Format = System.Windows.Forms.DateTimePickerFormat.[Short] GridViewDateTimeColumn1.FormatString = "{0:d}" GridViewDateTimeColumn1.HeaderText = "StartTime" GridViewDateTimeColumn1.Name = "StartTime" GridViewDateTimeColumn2.DataType = GetType(System.Nullable(Of System.DateTimeOffset)) GridViewDateTimeColumn2.FieldName = "EndTime" GridViewDateTimeColumn2.Format = System.Windows.Forms.DateTimePickerFormat.[Short] GridViewDateTimeColumn2.FormatString = "{0:d}" GridViewDateTimeColumn2.HeaderText = "EndTime" GridViewDateTimeColumn2.Name = "EndTime" Me.TimeCardGrid.MasterTemplate.Columns.AddRange(New Telerik.WinControls.UI.GridViewDataColumn() {GridViewDateTimeColumn1, GridViewDateTimeColumn2}) Me.TimeCardGrid.MasterTemplate.DataSource = Me.TimeCardBindingSource Me.TimeCardGrid.MasterTemplate.ShowFilteringRow = False Me.TimeCardGrid.MasterTemplate.ShowRowHeaderColumn = False Me.TimeCardGrid.Name = "TimeCardGrid" Me.TimeCardGrid.ShowGroupPanel = False Me.TimeCardGrid.Size = New System.Drawing.Size(315, 235) Me.TimeCardGrid.TabIndex = 2 Me.TimeCardGrid.Text = "RadGridView1" ' 'Form1 ' Me.AutoScaleDimensions = New System.Drawing.SizeF(6.0!, 13.0!) Me.AutoScaleMode = System.Windows.Forms.AutoScaleMode.Font Me.ClientSize = New System.Drawing.Size(347, 263) Me.Controls.Add(Me.TimeCardGrid) Me.Name = "Form1" Me.Text = "Form1" CType(Me.TimeCardBindingSource, System.ComponentModel.ISupportInitialize).EndInit() CType(Me.TimeCardGrid, System.ComponentModel.ISupportInitialize).EndInit() Me.ResumeLayout(False) End Sub Friend WithEvents TimeCardBindingSource As System.Windows.Forms.BindingSource Friend WithEvents TimeCardGrid As Telerik.WinControls.UI.RadGridView End Class 