Note: Setting the DataSource or the DataMember property causes the UltraGrid to load the data. Therefore to avoid loading data twice it's recommended that you set the DataMember before setting the DataSource or as a convenience use the SetDataBinding(Object,String,Boolean,Boolean) method which lets you set the DataSource and the DataMember in a single call.
Setting the DataSource and then setting the DataMember will cause the UltraGrid to load data twice; once when the DataSource is set and again when the DataMember is set. Setting the DataMember while the DataSource is null (Nothing in Visual Basic) does not cause the UltraGrid to load the data since there is no data source to load the data from. Also note that there is no need to call DataBind method after setting the DataSource and DataMember.
See DataSource property for more information.
Imports Infragistics.Shared Imports Infragistics.Win Imports Infragistics.Win.UltraWinGrid Private Sub Form1_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles MyBase.Load Me.OleDbDataAdapter1.Fill(Me.DataSet11) Me.OleDbDataAdapter2.Fill(Me.DataSet11) Me.OleDbDataAdapter3.Fill(Me.DataSet11) ' Set the data source and data member to bind the grid. Me.UltraGrid1.DataSource = Me.DataSet11 Me.UltraGrid1.DataMember = "" ' Disable alpha-blending which may increase performance. Me.UltraGrid1.AlphaBlendEnabled = False ' Disable theme support in WinXP based systems. Me.UltraGrid1.SupportThemes = False ' Set the appearance of the UltraGrid. Me.UltraGrid1.DisplayLayout.Appearance.BackColor = Color.Gray ' Set the border style of the UltraGrid. Me.UltraGrid1.DisplayLayout.BorderStyle = UIElementBorderStyle.InsetSoft ' Set the text, appearance and border styles of the caption. Me.UltraGrid1.Text = "UltraGrid Caption" Me.UltraGrid1.DisplayLayout.CaptionAppearance.FontData.Bold = DefaultableBoolean.True Me.UltraGrid1.DisplayLayout.BorderStyleCaption = UIElementBorderStyle.RaisedSoft ' Set the update mode which dictates when the UltraGrid calls EndEdit ' on IEditableObject row objects. Me.UltraGrid1.UpdateMode = UpdateMode.OnRowChangeOrLostFocus ' Set the scroll style to Immediate so that the UltraGrid scrolls the rows as ' the vertical scroll bar thumb is dragged. Normally the UltraGrid defers the ' scrolling until the thumb is released and displays scroll tips instead. Me.UltraGrid1.DisplayLayout.ScrollStyle = ScrollStyle.Immediate End Sub
using Infragistics.Shared; using Infragistics.Win; using Infragistics.Win.UltraWinGrid; using System.Diagnostics; private void Form1_Load(object sender, System.EventArgs e) { this.oleDbDataAdapter1.Fill( this.dataSet11 ); this.oleDbDataAdapter2.Fill( this.dataSet11 ); this.oleDbDataAdapter3.Fill( this.dataSet11 ); // Set the data source and data member to bind the grid. this.ultraGrid1.DataSource = this.dataSet11; this.ultraGrid1.DataMember = ""; // Disable alpha-blending which may increase performance. this.ultraGrid1.AlphaBlendEnabled = false; // Disable theme support in WinXP based systems. this.ultraGrid1.SupportThemes = false; // Set the appearance of the UltraGrid. this.ultraGrid1.DisplayLayout.Appearance.BackColor = Color.Gray; // Set the border style of the UltraGrid. this.ultraGrid1.DisplayLayout.BorderStyle = UIElementBorderStyle.InsetSoft; // Set the text, appearance and border styles of the caption. this.ultraGrid1.Text = "UltraGrid Caption"; this.ultraGrid1.DisplayLayout.CaptionAppearance.FontData.Bold = DefaultableBoolean.True; this.ultraGrid1.DisplayLayout.BorderStyleCaption = UIElementBorderStyle.RaisedSoft; // Set the update mode which dictates when the UltraGrid calls EndEdit // on IEditableObject row objects. this.ultraGrid1.UpdateMode = UpdateMode.OnRowChangeOrLostFocus; // Set the scroll style to Immediate so that the UltraGrid scrolls the rows as // the vertical scroll bar thumb is dragged. Normally the UltraGrid defers the // scrolling until the thumb is released and displays scroll tips instead. this.ultraGrid1.DisplayLayout.ScrollStyle = ScrollStyle.Immediate; }
Target Platforms: Windows 10, Windows 8.1, Windows 8, Windows 7, Windows Server 2012, Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2