2 // System.Web.UI.WebControls.AccessDataSourceView
5 // Sanjay Gupta (gsanjay@novell.com)
7 // (C) Novell, Inc. (http://www.novell.com)
11 // Permission is hereby granted, free of charge, to any person obtaining
12 // a copy of this software and associated documentation files (the
13 // "Software"), to deal in the Software without restriction, including
14 // without limitation the rights to use, copy, modify, merge, publish,
15 // distribute, sublicense, and/or sell copies of the Software, and to
16 // permit persons to whom the Software is furnished to do so, subject to
17 // the following conditions:
19 // The above copyright notice and this permission notice shall be
20 // included in all copies or substantial portions of the Software.
22 // THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND,
23 // EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF
24 // MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND
25 // NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE
26 // LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION
27 // OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION
28 // WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE.
32 using System.Collections;
33 using System.Collections.Specialized;
36 using System.ComponentModel;
37 using System.Data.OleDb;
38 using System.Security.Permissions;
40 namespace System.Web.UI.WebControls {
42 [AspNetHostingPermissionAttribute (SecurityAction.LinkDemand, Level = AspNetHostingPermissionLevel.Minimal)]
43 public class AccessDataSourceView : SqlDataSourceView {
45 OleDbConnection oleConnection;
46 OleDbCommand oleCommand;
47 AccessDataSource dataSource;
48 public AccessDataSourceView (AccessDataSource owner, string name, HttpContext context)
49 : base (owner, name, context)
52 oleConnection = new OleDbConnection (owner.ConnectionString);
55 [MonoTODO ("Handle arguments")]
56 protected internal override IEnumerable ExecuteSelect (
57 DataSourceSelectArguments arguments)
59 oleCommand = new OleDbCommand (this.SelectCommand, oleConnection);
60 SqlDataSourceSelectingEventArgs cmdEventArgs = new SqlDataSourceSelectingEventArgs (oleCommand, arguments);
61 OnSelecting (cmdEventArgs);
62 IEnumerable enums = null;
63 Exception exception = null;
64 OleDbDataReader reader = null;
66 System.IO.File.OpenRead (dataSource.DataFile).Close ();
67 oleConnection.Open ();
68 reader = (OleDbDataReader)oleCommand.ExecuteReader ();
70 //enums = reader.GetEnumerator ();
71 throw new NotImplementedException("OleDbDataReader doesnt implements GetEnumerator method yet");
72 } catch (Exception e) {
75 SqlDataSourceStatusEventArgs statusEventArgs =
76 new SqlDataSourceStatusEventArgs (oleCommand, reader.RecordsAffected, exception);
77 OnSelected (statusEventArgs);