Sometimes, when developing Web applications with ASP.NET, you may require to use a small amount of data repeatedly throughout the life of the application and further, such data is shared among users accessing your application. Let's say a dataset created in designer points to the DataSetCustomers schema. C# //Defining object for the existing dataset private static Namespace.DataSetCustomers dataSet11 = null; // Initializing a static datasource based on the datasource created in the designer. public static Namespace.DataSetCustomers GetDataSet(System.Data.OleDb.OleDbDataAdapter adapter, Namespace.DataSetCustomers defaultDataSet) { if(dataSet11 == null) { dataSet11 = new Namespace.DataSetCustomers(); ((System.ComponentModel.ISupportInitialize)(dataSet11)).BeginInit(); dataSet11.DataSetName = defaultDataSet.DataSetName; dataSet11.EnforceConstraints = defaultDataSet.EnforceConstraints; dataSet11.Locale = defaultDataSet.Locale; ((System.ComponentModel.ISupportInitialize)(dataSet11)).EndInit(); adapter.Fill(dataSet11); } return dataSet11; } #endregion //Filling a DataAdapter using static datasource. Instead of filling a DataAdapter with the dataset created in the designer, you can use the static data source. //this.oleDbDataAdapter1.Fill(this.dataSetCustomers1); //Using a static datasource, changes made to the dataset will be preserved across postback. this.dataSetCustomers1 = GetDataSet(this.oleDbDataAdapter1, this.dataSetCustomers1); VB 'Defining object for the existing dataset Private Shared dataSet11 As Namespace.DataSetCustomers = Nothing ' Initializing a static datasource based on the datasource created in the designer. Public Shared Function GetDataSet(ByVal adapter As System.Data.OleDb.OleDbDataAdapter, ByVal defaultDataSet As Namespace.DataSetCustomers) As Namespace.DataSetCustomers If dataSet11 Is Nothing Then dataSet11 = New Namespace.DataSetCustomers() CType(dataSet11, System.ComponentModel.ISupportInitialize).BeginInit() dataSet11.DataSetName = defaultDataSet.DataSetName dataSet11.EnforceConstraints = defaultDataSet.EnforceConstraints dataSet11.Locale = defaultDataSet.Locale CType(dataSet11, System.ComponentModel.ISupportInitialize).EndInit() adapter.Fill(dataSet11) End If Return dataSet11 End Function #End Region 'Filling a DataAdapter using static datasource. Instead of filling a DataAdapter with the dataset created in the designer, you can use the static data source. 'this.oleDbDataAdapter1.Fill(this.dataSetCustomers1); 'Using a static datasource, changes made to the dataset will be preserved across postback. Private Me.dataSetCustomers1 = GetDataSet(Me.oleDbDataAdapter1, Me.dataSetCustomers1)
|
This page will automatically be redirected to the sign-in page in 10 seconds.