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 if (IsTrackingViewState)
69 ((IStateManager) view).TrackViewState ();
73 [DesignerSerializationVisibility (DesignerSerializationVisibility.Hidden)]
75 [MonoTODO("AccessDataSource does not support SQL Cache Dependencies")]
76 public override string SqlCacheDependency {
77 get { throw new NotSupportedException ("AccessDataSource does not supports SQL Cache Dependencies."); }
78 set { throw new NotSupportedException ("AccessDataSource does not supports SQL Cache Dependencies."); }
81 [MonoTODO ("why override? maybe it doesn't call DbProviderFactories.GetFactory?")]
82 protected override DbProviderFactory GetDbProviderFactory ()
84 return DbProviderFactories.GetFactory (PROVIDER_NAME);
87 string GetPhysicalDataFilePath ()
89 if (DataFile == null || DataFile == "")
92 // more here? how do we handle |DataDirectory|?
93 return HttpContext.Current.Request.MapPath (DataFile);
96 [BrowsableAttribute (false),
97 DesignerSerializationVisibilityAttribute (DesignerSerializationVisibility.Hidden)]
98 public override string ConnectionString {
100 if (connectionString == null) {
101 connectionString = String.Concat ("Provider=", PROVIDER_STRING, "; Data Source=", GetPhysicalDataFilePath ());
104 return connectionString;
107 throw new InvalidOperationException
108 ("The ConnectionString is automatically generated for AccessDataSource and hence cannot be set.");
112 [UrlPropertyAttribute]
113 [DefaultValueAttribute ("")]
114 [WebCategoryAttribute ("Data")]
115 [WebSysDescriptionAttribute ("MS Office Access database file name")]
116 [EditorAttribute ("System.Web.UI.Design.MdbDataFileEditor, " + Consts.AssemblySystem_Design, "System.Drawing.Design.UITypeEditor, " + Consts.AssemblySystem_Drawing)]
117 public string DataFile {
118 get { return ViewState.GetString ("DataFile", ""); }
120 ViewState ["DataFile"] = value;
121 connectionString = null;
125 [BrowsableAttribute (false),
126 DesignerSerializationVisibilityAttribute (DesignerSerializationVisibility.Hidden)]
127 public override string ProviderName {
128 get { return base.ProviderName; }
129 set { throw new InvalidOperationException
130 ("Setting ProviderName on an AccessDataSource is not allowed");