2 // System.Web.UI.WebControls.AccessDataSource.cs
5 // Sanjay Gupta (gsanjay@novell.com)
7 // Copyright (C) 2004-2005 Novell, Inc (http://www.novell.com)
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:
17 // The above copyright notice and this permission notice shall be
18 // included in all copies or substantial portions of the Software.
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.
32 using System.ComponentModel;
33 using System.Data.Common;
35 using System.Security.Permissions;
37 namespace System.Web.UI.WebControls {
40 [AspNetHostingPermissionAttribute (SecurityAction.LinkDemand, Level = AspNetHostingPermissionLevel.Minimal)]
41 [AspNetHostingPermissionAttribute (SecurityAction.InheritanceDemand, Level = AspNetHostingPermissionLevel.Minimal)]
43 [DesignerAttribute ("System.Web.UI.Design.WebControls.AccessDataSourceDesigner, " + Consts.AssemblySystem_Design, "System.ComponentModel.Design.IDesigner")]
45 public class AccessDataSource : SqlDataSource {
47 const string PROVIDER_NAME = "System.Data.OleDb";
48 const string PROVIDER_STRING = "Microsoft.Jet.OLEDB.4.0";
51 string connectionString;
53 public AccessDataSource () : base ()
55 base.ProviderName = PROVIDER_NAME;
58 public AccessDataSource (string dataFile, string selectCommand) :
59 base (String.Empty, selectCommand)
61 this.dataFile = dataFile;
62 this.ProviderName = PROVIDER_NAME;
65 protected override SqlDataSourceView CreateDataSourceView (string viewName)
67 AccessDataSourceView view = new AccessDataSourceView (this, viewName, this.Context);
68 view.DataSourceViewChanged += new EventHandler (ViewChanged);
69 if (IsTrackingViewState)
70 ((IStateManager) view).TrackViewState ();
74 void ViewChanged (object source, EventArgs e)
76 RaiseDataSourceChangedEvent (e);
79 [DesignerSerializationVisibility (DesignerSerializationVisibility.Hidden)]
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."); }
87 [MonoTODO ("why override? maybe it doesn't call DbProviderFactories.GetFactory?")]
88 protected override DbProviderFactory GetDbProviderFactory ()
90 return DbProviderFactories.GetFactory (PROVIDER_NAME);
93 string GetPhysicalDataFilePath ()
95 if (DataFile == null || DataFile == "")
98 // more here? how do we handle |DataDirectory|?
99 return HttpContext.Current.Request.MapPath (DataFile);
102 [BrowsableAttribute (false),
103 DesignerSerializationVisibilityAttribute (DesignerSerializationVisibility.Hidden)]
104 public override string ConnectionString {
106 if (connectionString == null) {
107 connectionString = String.Format ("Provider={0}; Data Source={1}",
108 PROVIDER_STRING, GetPhysicalDataFilePath ());
111 return connectionString;
114 throw new InvalidOperationException
115 ("The ConnectionString is automatically generated for AccessDataSource and hence cannot be set.");
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", ""); }
127 ViewState ["DataFile"] = value;
128 connectionString = null;
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");