mcs/class/System.Web/System.Web.UI.WebControls/AccessDataSource.cs

   1 //
   2 // System.Web.UI.WebControls.AccessDataSource.cs
   3 //
   4 // Authors:
   5 //   Sanjay Gupta (gsanjay@novell.com)
   6 //
   7 // Copyright (C) 2004-2005 Novell, Inc (http://www.novell.com)
   8 //
   9 // Permission is hereby granted, free of charge, to any person obtaining
  10 // a copy of this software and associated documentation files (the
  11 // "Software"), to deal in the Software without restriction, including
  12 // without limitation the rights to use, copy, modify, merge, publish,
  13 // distribute, sublicense, and/or sell copies of the Software, and to
  14 // permit persons to whom the Software is furnished to do so, subject to
  15 // the following conditions:
  16 //
  17 // The above copyright notice and this permission notice shall be
  18 // included in all copies or substantial portions of the Software.
  19 //
  20 // THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND,
  21 // EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF
  22 // MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND
  23 // NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE
  24 // LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION
  25 // OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION
  26 // WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE.
  27 //
  28
  29 #if NET_2_0
  30
  31 using System.IO;
  32 using System.ComponentModel;
  33 using System.Data.Common;
  34 using System.Drawing;
  35 using System.Security.Permissions;
  36
  37 namespace System.Web.UI.WebControls {
  38
  39         // CAS
  40         [AspNetHostingPermissionAttribute (SecurityAction.LinkDemand, Level = AspNetHostingPermissionLevel.Minimal)]
  41         [AspNetHostingPermissionAttribute (SecurityAction.InheritanceDemand, Level = AspNetHostingPermissionLevel.Minimal)]
  42         // attributes
  43         [DesignerAttribute ("System.Web.UI.Design.WebControls.AccessDataSourceDesigner, " + Consts.AssemblySystem_Design, "System.ComponentModel.Design.IDesigner")]
  44         [ToolboxBitmap ("")]
  45         public class AccessDataSource : SqlDataSource {
  46
  47                 const string PROVIDER_NAME = "System.Data.OleDb";
  48                 const string PROVIDER_STRING = "Microsoft.Jet.OLEDB.4.0";
  49
  50                 string dataFile;
  51                 string connectionString;
  52
  53                 public AccessDataSource () : base ()
  54                 {
  55                         base.ProviderName = PROVIDER_NAME;
  56                 }
  57
  58                 public AccessDataSource (string dataFile, string selectCommand) :
  59                         base (String.Empty, selectCommand)
  60                 {
  61                         this.dataFile = dataFile;
  62                         this.ProviderName = PROVIDER_NAME;
  63                 }
  64
  65                 protected override SqlDataSourceView CreateDataSourceView (string viewName)
  66                 {
  67                         AccessDataSourceView view = new AccessDataSourceView (this, viewName, this.Context);
  68                         view.DataSourceViewChanged += new EventHandler (ViewChanged);
  69                         if (IsTrackingViewState)
  70                                 ((IStateManager) view).TrackViewState ();
  71                         return view;
  72                 }
  73
  74                 void ViewChanged (object source, EventArgs e)
  75                 {
  76                         RaiseDataSourceChangedEvent (e);
  77                 }
  78
  79                 [DesignerSerializationVisibility (DesignerSerializationVisibility.Hidden)]
  80                 [Browsable (false)]
  81                 [MonoTODO]
  82                 public override string SqlCacheDependency {
  83                         get { throw new NotSupportedException ("AccessDataSource does not supports SQL Cache Dependencies."); }
  84                         set { throw new NotSupportedException ("AccessDataSource does not supports SQL Cache Dependencies."); }
  85                 }
  86
  87                 [MonoTODO ("why override?  maybe it doesn't call DbProviderFactories.GetFactory?")]
  88                 protected override DbProviderFactory GetDbProviderFactory ()
  89                 {
  90                         return DbProviderFactories.GetFactory (PROVIDER_NAME);
  91                 }
  92
  93                 string GetPhysicalDataFilePath ()
  94                 {
  95                         if (DataFile == null || DataFile == "")
  96                                 return "";
  97
  98                         // more here?  how do we handle |DataDirectory|?
  99                         return HttpContext.Current.Request.MapPath (DataFile);
 100                 }
 101
 102                 [BrowsableAttribute (false),
 103                 DesignerSerializationVisibilityAttribute (DesignerSerializationVisibility.Hidden)]
 104                 public override string ConnectionString {
 105                         get {
 106                                 if (connectionString == null) {
 107                                         connectionString = String.Format ("Provider={0}; Data Source={1}",
 108                                                                           PROVIDER_STRING, GetPhysicalDataFilePath ());
 109                                 }
 110
 111                                 return connectionString;
 112                         }
 113                         set {
 114                                 throw new InvalidOperationException
 115                                         ("The ConnectionString is automatically generated for AccessDataSource and hence cannot be set.");
 116                         }
 117                 }
 118
 119                 [UrlPropertyAttribute]
 120                 [DefaultValueAttribute ("")]
 121                 [WebCategoryAttribute ("Data")]
 122                 [WebSysDescriptionAttribute ("MS Office Access database file name")]
 123                 [EditorAttribute ("System.Web.UI.Design.MdbDataFileEditor, " + Consts.AssemblySystem_Design, "System.Drawing.Design.UITypeEditor, " + Consts.AssemblySystem_Drawing)]
 124                 public string DataFile {
 125                         get { return ViewState.GetString ("DataFile", ""); }
 126                         set {
 127                                 ViewState ["DataFile"] = value;
 128                                 connectionString = null;
 129                         }
 130                 }
 131
 132                 [BrowsableAttribute (false),
 133                 DesignerSerializationVisibilityAttribute (DesignerSerializationVisibility.Hidden)]
 134                 public override string ProviderName {
 135                         get { return base.ProviderName; }
 136                         set { throw new InvalidOperationException
 137                                 ("Setting ProviderName on an AccessDataSource is not allowed");
 138                         }
 139                 }
 140         }
 141 }
 142 #endif