Code:
/ Dotnetfx_Vista_SP2 / Dotnetfx_Vista_SP2 / 8.0.50727.4016 / DEVDIV / depot / DevDiv / releases / whidbey / NetFxQFE / ndp / fx / src / xsp / System / Web / UI / WebControls / AccessDataSource.cs / 1 / AccessDataSource.cs
//------------------------------------------------------------------------------
//
// Copyright (c) Microsoft Corporation. All rights reserved.
//
//-----------------------------------------------------------------------------
namespace System.Web.UI.WebControls {
using System;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Data.Common;
using System.Data.OleDb;
using System.Diagnostics;
using System.Drawing;
using System.Drawing.Design;
using System.IO;
using System.Security.Permissions;
using System.Text;
using System.Web.Caching;
using System.Web.UI;
///
/// Allows a user to create a declarative connection to an Access database in a .aspx page.
///
[
Designer("System.Web.UI.Design.WebControls.AccessDataSourceDesigner, " + AssemblyRef.SystemDesign),
ToolboxBitmap(typeof(AccessDataSource)),
WebSysDescription(SR.AccessDataSource_Description),
WebSysDisplayName(SR.AccessDataSource_DisplayName)
]
[AspNetHostingPermission(SecurityAction.LinkDemand, Level=AspNetHostingPermissionLevel.Minimal)]
[AspNetHostingPermission(SecurityAction.InheritanceDemand, Level=AspNetHostingPermissionLevel.Minimal)]
public class AccessDataSource : SqlDataSource {
private const string OleDbProviderName = "System.Data.OleDb";
private FileDataSourceCache _cache;
private string _connectionString;
private string _dataFile;
private string _physicalDataFile;
///
/// Creates a new instance of AccessDataSource.
///
public AccessDataSource() : base() {
}
///
/// Creates a new instance of AccessDataSource with a specified connection string and select command.
///
public AccessDataSource(string dataFile, string selectCommand) : base() {
if (String.IsNullOrEmpty(dataFile)) {
throw new ArgumentNullException("dataFile");
}
DataFile = dataFile;
SelectCommand = selectCommand;
}
///
/// Specifies the cache settings for this data source. For the cache to
/// work, the DataSourceMode must be set to DataSet.
///
internal override DataSourceCache Cache {
get {
if (_cache == null) {
_cache = new FileDataSourceCache();
}
return _cache;
}
}
///
/// Gets the connection string for the AccessDataSource. This property is auto-generated and cannot be set.
///
[
Browsable(false),
DesignerSerializationVisibility(DesignerSerializationVisibility.Hidden),
]
public override string ConnectionString {
get {
if (_connectionString == null) {
_connectionString = CreateConnectionString();
}
return _connectionString;
}
set {
throw new InvalidOperationException(SR.GetString(SR.AccessDataSource_CannotSetConnectionString));
}
}
///
/// The name of an Access database file.
/// This property is not stored in ViewState.
///
[
DefaultValue(""),
Editor("System.Web.UI.Design.MdbDataFileEditor, " + AssemblyRef.SystemDesign, typeof(UITypeEditor)),
UrlProperty(),
WebCategory("Data"),
WebSysDescription(SR.AccessDataSource_DataFile),
]
public string DataFile {
get {
return (_dataFile == null) ? String.Empty : _dataFile;
}
set {
if (DataFile != value) {
_dataFile = value;
_connectionString = null;
_physicalDataFile = null;
RaiseDataSourceChangedEvent(EventArgs.Empty);
}
}
}
///
/// Gets the file data source cache object.
///
private FileDataSourceCache FileDataSourceCache {
get {
FileDataSourceCache fileCache = Cache as FileDataSourceCache;
Debug.Assert(fileCache != null, "Cache object should be a FileDataSourceCache");
return fileCache;
}
}
///
/// Gets the Physical path of the data file.
///
private string PhysicalDataFile {
get {
if (_physicalDataFile == null) {
_physicalDataFile = GetPhysicalDataFilePath();
}
return _physicalDataFile;
}
}
///
/// Gets/sets the ADO.net managed provider name. This property is restricted to the OLE DB provider and cannot be set.
///
[
Browsable(false),
DesignerSerializationVisibility(DesignerSerializationVisibility.Hidden),
]
public override string ProviderName {
get {
return OleDbProviderName;
}
set {
throw new InvalidOperationException(SR.GetString(SR.AccessDataSource_CannotSetProvider, ID));
}
}
///
/// A semi-colon delimited string indicating which databases to use for the dependency in the format "database1:table1;database2:table2".
///
[
Browsable(false),
DesignerSerializationVisibility(DesignerSerializationVisibility.Hidden),
]
public override string SqlCacheDependency {
get {
throw new NotSupportedException(SR.GetString(SR.AccessDataSource_SqlCacheDependencyNotSupported, ID));
}
set {
throw new NotSupportedException(SR.GetString(SR.AccessDataSource_SqlCacheDependencyNotSupported, ID));
}
}
private void AddCacheFileDependency() {
FileDataSourceCache.FileDependencies.Clear();
string filename = PhysicalDataFile;
if (filename.Length > 0) {
FileDataSourceCache.FileDependencies.Add(filename);
}
}
///
/// Creates a connection string for an Access database connection.
/// The JET provider is automatically used, and the filename, username, password, and
/// share mode are are set.
///
private string CreateConnectionString() {
return "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" + PhysicalDataFile;
}
///
/// Creates a new AccessDataSourceView.
///
protected override SqlDataSourceView CreateDataSourceView(string viewName) {
return new AccessDataSourceView(this, viewName, Context);
}
protected override DbProviderFactory GetDbProviderFactory() {
return OleDbFactory.Instance;
}
///
/// Gets the appropriate mapped path for the DataFile.
///
private string GetPhysicalDataFilePath() {
string filename = DataFile;
if (filename.Length == 0) {
return null;
}
if (!System.Web.Util.UrlPath.IsAbsolutePhysicalPath(filename)) {
// Root relative path
if (DesignMode) {
// This exception should never be thrown - the designer always maps paths
// before using the runtime control.
throw new NotSupportedException(SR.GetString(SR.AccessDataSource_DesignTimeRelativePathsNotSupported, ID));
}
filename = Context.Request.MapPath(filename, AppRelativeTemplateSourceDirectory, true);
}
HttpRuntime.CheckFilePermission(filename, true);
// We also need to check for path discovery permissions for the
// file since the page developer will be able to see the physical
// path in the ConnectionString property.
if (!HttpRuntime.HasPathDiscoveryPermission(filename)) {
throw new HttpException(SR.GetString(SR.AccessDataSource_NoPathDiscoveryPermission, HttpRuntime.GetSafePath(filename), ID));
}
return filename;
}
///
/// Saves data to the cache.
///
internal override void SaveDataToCache(int startRowIndex, int maximumRows, object data, CacheDependency dependency) {
AddCacheFileDependency();
base.SaveDataToCache(startRowIndex, maximumRows, data, dependency);
}
/*internal override void SaveTotalRowCountToCache(int totalRowCount) {
AddCacheFileDependency();
base.SaveTotalRowCountToCache(totalRowCount);
}*/
}
}
// File provided for Reference Use Only by Microsoft Corporation (c) 2007.
//------------------------------------------------------------------------------
//
// Copyright (c) Microsoft Corporation. All rights reserved.
//
//-----------------------------------------------------------------------------
namespace System.Web.UI.WebControls {
using System;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Data.Common;
using System.Data.OleDb;
using System.Diagnostics;
using System.Drawing;
using System.Drawing.Design;
using System.IO;
using System.Security.Permissions;
using System.Text;
using System.Web.Caching;
using System.Web.UI;
///
/// Allows a user to create a declarative connection to an Access database in a .aspx page.
///
[
Designer("System.Web.UI.Design.WebControls.AccessDataSourceDesigner, " + AssemblyRef.SystemDesign),
ToolboxBitmap(typeof(AccessDataSource)),
WebSysDescription(SR.AccessDataSource_Description),
WebSysDisplayName(SR.AccessDataSource_DisplayName)
]
[AspNetHostingPermission(SecurityAction.LinkDemand, Level=AspNetHostingPermissionLevel.Minimal)]
[AspNetHostingPermission(SecurityAction.InheritanceDemand, Level=AspNetHostingPermissionLevel.Minimal)]
public class AccessDataSource : SqlDataSource {
private const string OleDbProviderName = "System.Data.OleDb";
private FileDataSourceCache _cache;
private string _connectionString;
private string _dataFile;
private string _physicalDataFile;
///
/// Creates a new instance of AccessDataSource.
///
public AccessDataSource() : base() {
}
///
/// Creates a new instance of AccessDataSource with a specified connection string and select command.
///
public AccessDataSource(string dataFile, string selectCommand) : base() {
if (String.IsNullOrEmpty(dataFile)) {
throw new ArgumentNullException("dataFile");
}
DataFile = dataFile;
SelectCommand = selectCommand;
}
///
/// Specifies the cache settings for this data source. For the cache to
/// work, the DataSourceMode must be set to DataSet.
///
internal override DataSourceCache Cache {
get {
if (_cache == null) {
_cache = new FileDataSourceCache();
}
return _cache;
}
}
///
/// Gets the connection string for the AccessDataSource. This property is auto-generated and cannot be set.
///
[
Browsable(false),
DesignerSerializationVisibility(DesignerSerializationVisibility.Hidden),
]
public override string ConnectionString {
get {
if (_connectionString == null) {
_connectionString = CreateConnectionString();
}
return _connectionString;
}
set {
throw new InvalidOperationException(SR.GetString(SR.AccessDataSource_CannotSetConnectionString));
}
}
///
/// The name of an Access database file.
/// This property is not stored in ViewState.
///
[
DefaultValue(""),
Editor("System.Web.UI.Design.MdbDataFileEditor, " + AssemblyRef.SystemDesign, typeof(UITypeEditor)),
UrlProperty(),
WebCategory("Data"),
WebSysDescription(SR.AccessDataSource_DataFile),
]
public string DataFile {
get {
return (_dataFile == null) ? String.Empty : _dataFile;
}
set {
if (DataFile != value) {
_dataFile = value;
_connectionString = null;
_physicalDataFile = null;
RaiseDataSourceChangedEvent(EventArgs.Empty);
}
}
}
///
/// Gets the file data source cache object.
///
private FileDataSourceCache FileDataSourceCache {
get {
FileDataSourceCache fileCache = Cache as FileDataSourceCache;
Debug.Assert(fileCache != null, "Cache object should be a FileDataSourceCache");
return fileCache;
}
}
///
/// Gets the Physical path of the data file.
///
private string PhysicalDataFile {
get {
if (_physicalDataFile == null) {
_physicalDataFile = GetPhysicalDataFilePath();
}
return _physicalDataFile;
}
}
///
/// Gets/sets the ADO.net managed provider name. This property is restricted to the OLE DB provider and cannot be set.
///
[
Browsable(false),
DesignerSerializationVisibility(DesignerSerializationVisibility.Hidden),
]
public override string ProviderName {
get {
return OleDbProviderName;
}
set {
throw new InvalidOperationException(SR.GetString(SR.AccessDataSource_CannotSetProvider, ID));
}
}
///
/// A semi-colon delimited string indicating which databases to use for the dependency in the format "database1:table1;database2:table2".
///
[
Browsable(false),
DesignerSerializationVisibility(DesignerSerializationVisibility.Hidden),
]
public override string SqlCacheDependency {
get {
throw new NotSupportedException(SR.GetString(SR.AccessDataSource_SqlCacheDependencyNotSupported, ID));
}
set {
throw new NotSupportedException(SR.GetString(SR.AccessDataSource_SqlCacheDependencyNotSupported, ID));
}
}
private void AddCacheFileDependency() {
FileDataSourceCache.FileDependencies.Clear();
string filename = PhysicalDataFile;
if (filename.Length > 0) {
FileDataSourceCache.FileDependencies.Add(filename);
}
}
///
/// Creates a connection string for an Access database connection.
/// The JET provider is automatically used, and the filename, username, password, and
/// share mode are are set.
///
private string CreateConnectionString() {
return "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" + PhysicalDataFile;
}
///
/// Creates a new AccessDataSourceView.
///
protected override SqlDataSourceView CreateDataSourceView(string viewName) {
return new AccessDataSourceView(this, viewName, Context);
}
protected override DbProviderFactory GetDbProviderFactory() {
return OleDbFactory.Instance;
}
///
/// Gets the appropriate mapped path for the DataFile.
///
private string GetPhysicalDataFilePath() {
string filename = DataFile;
if (filename.Length == 0) {
return null;
}
if (!System.Web.Util.UrlPath.IsAbsolutePhysicalPath(filename)) {
// Root relative path
if (DesignMode) {
// This exception should never be thrown - the designer always maps paths
// before using the runtime control.
throw new NotSupportedException(SR.GetString(SR.AccessDataSource_DesignTimeRelativePathsNotSupported, ID));
}
filename = Context.Request.MapPath(filename, AppRelativeTemplateSourceDirectory, true);
}
HttpRuntime.CheckFilePermission(filename, true);
// We also need to check for path discovery permissions for the
// file since the page developer will be able to see the physical
// path in the ConnectionString property.
if (!HttpRuntime.HasPathDiscoveryPermission(filename)) {
throw new HttpException(SR.GetString(SR.AccessDataSource_NoPathDiscoveryPermission, HttpRuntime.GetSafePath(filename), ID));
}
return filename;
}
///
/// Saves data to the cache.
///
internal override void SaveDataToCache(int startRowIndex, int maximumRows, object data, CacheDependency dependency) {
AddCacheFileDependency();
base.SaveDataToCache(startRowIndex, maximumRows, data, dependency);
}
/*internal override void SaveTotalRowCountToCache(int totalRowCount) {
AddCacheFileDependency();
base.SaveTotalRowCountToCache(totalRowCount);
}*/
}
}
// File provided for Reference Use Only by Microsoft Corporation (c) 2007.
Link Menu
This book is available now!
Buy at Amazon US or
Buy at Amazon UK
- HwndSource.cs
- PageWrapper.cs
- PersianCalendar.cs
- CancelEventArgs.cs
- MethodExpr.cs
- Comparer.cs
- GAC.cs
- HtmlLink.cs
- DomainUpDown.cs
- SpellerHighlightLayer.cs
- XmlSigningNodeWriter.cs
- WizardPanelChangingEventArgs.cs
- ContextMenu.cs
- MeasureData.cs
- HandlerFactoryWrapper.cs
- RowsCopiedEventArgs.cs
- MsmqPoisonMessageException.cs
- HttpWriter.cs
- PropertyIdentifier.cs
- PointCollectionValueSerializer.cs
- File.cs
- XPathBuilder.cs
- Section.cs
- DbBuffer.cs
- CTreeGenerator.cs
- GridViewAutomationPeer.cs
- TextControl.cs
- AnimationLayer.cs
- GridViewDesigner.cs
- CompositeControl.cs
- HistoryEventArgs.cs
- IconBitmapDecoder.cs
- CompoundFileDeflateTransform.cs
- TraceContextEventArgs.cs
- QilLiteral.cs
- TextParagraphView.cs
- MultiDataTrigger.cs
- HttpDictionary.cs
- TraversalRequest.cs
- BindingMAnagerBase.cs
- VisualStyleRenderer.cs
- AsyncDataRequest.cs
- DelegatingMessage.cs
- ConditionalAttribute.cs
- Misc.cs
- AssemblyCollection.cs
- XmlCDATASection.cs
- MemberNameValidator.cs
- ManagementBaseObject.cs
- Emitter.cs
- State.cs
- InputEventArgs.cs
- DateTimeConverter2.cs
- ErrorFormatter.cs
- CompoundFileIOPermission.cs
- DocumentViewerBase.cs
- CachedFontFamily.cs
- _NegoStream.cs
- InkPresenter.cs
- SqlEnums.cs
- PermissionSet.cs
- LowerCaseStringConverter.cs
- HtmlInputControl.cs
- CapabilitiesSection.cs
- ToolBarButtonClickEvent.cs
- XsltSettings.cs
- ScriptComponentDescriptor.cs
- XamlSerializer.cs
- Label.cs
- HuffModule.cs
- OdbcConnectionHandle.cs
- EntityKeyElement.cs
- ApplyTemplatesAction.cs
- MemberCollection.cs
- StreamMarshaler.cs
- NegationPusher.cs
- DataGridViewSortCompareEventArgs.cs
- DataSourceView.cs
- cache.cs
- EventDescriptorCollection.cs
- SoapAttributes.cs
- BooleanProjectedSlot.cs
- _ScatterGatherBuffers.cs
- EntityContainerRelationshipSet.cs
- InvalidAsynchronousStateException.cs
- HtmlEncodedRawTextWriter.cs
- ScriptResourceAttribute.cs
- TransactionFlowOption.cs
- LocalizationParserHooks.cs
- SearchForVirtualItemEventArgs.cs
- HtmlInputReset.cs
- DataPagerFieldItem.cs
- BitmapMetadata.cs
- VirtualPathUtility.cs
- SearchForVirtualItemEventArgs.cs
- FileChangesMonitor.cs
- HTMLTextWriter.cs
- StateBag.cs
- DeriveBytes.cs
- SettingsSavedEventArgs.cs