><databases> > <add key="MyData\Connection" value="Provider=vfpoledb.1;Data Source=C:\TestMM26\" /> ></databases> >>
>this.TableName = "Dealers"; >this.PrimaryKey = "dlr_pk"; >this.DatabaseKey = "MyData"; >>
>protected override mmDataAccessBase CreateDataAccessObject(string dataAccessClassName) >{ > DealersDataAccessOleDb da = new DealersDataAccessOleDb(); > return da; >} >>
>using System; >using System.Data; > >using OakLeaf.MM.Main.Data; > >namespace Kirtland.SampleApp.Business >{ > /// <summary> > /// Summary description for DealersDataAccessOleDb. > /// </summary> > public class DealersDataAccessOleDb : mmDataAccessOleDb > { > private System.Data.OleDb.OleDbDataAdapter oleDbDataAdapter1; > private System.Data.OleDb.OleDbCommand oleDbSelectCommand1; > private System.Data.OleDb.OleDbCommand oleDbInsertCommand1; > private System.Data.OleDb.OleDbCommand oleDbUpdateCommand1; > private System.Data.OleDb.OleDbCommand oleDbDeleteCommand1; > > private void InitializeComponent() > { > this.oleDbDataAdapter1 = new System.Data.OleDb.OleDbDataAdapter(); > this.oleDbSelectCommand1 = new System.Data.OleDb.OleDbCommand(); > this.oleDbInsertCommand1 = new System.Data.OleDb.OleDbCommand(); > this.oleDbUpdateCommand1 = new System.Data.OleDb.OleDbCommand(); > this.oleDbDeleteCommand1 = new System.Data.OleDb.OleDbCommand(); > > // > // oleDbDataAdapter1 > // > this.oleDbDataAdapter1.UpdateCommand = this.oleDbUpdateCommand1; > this.oleDbDataAdapter1.InsertCommand = this.oleDbInsertCommand1; > this.oleDbDataAdapter1.DeleteCommand = this.oleDbDeleteCommand1; > this.oleDbDataAdapter1.SelectCommand = this.oleDbSelectCommand1; > this.oleDbDataAdapter1.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] { > new System.Data.Common.DataTableMapping("Table", "Dealers", new System.Data.Common.DataColumnMapping[] { >new System.Data.Common.DataColumnMapping("dlr_pk", "dlr_pk"), >new System.Data.Common.DataColumnMapping("company", "company"), >new System.Data.Common.DataColumnMapping("dealer", "dealer"), >new System.Data.Common.DataColumnMapping("dlr_type", "dlr_type"), >new System.Data.Common.DataColumnMapping("legalname", "legalname"), >new System.Data.Common.DataColumnMapping("addr1", "addr1"), >new System.Data.Common.DataColumnMapping("addr2", "addr2"), >new System.Data.Common.DataColumnMapping("city", "city"), >new System.Data.Common.DataColumnMapping("st", "st"), >new System.Data.Common.DataColumnMapping("zip", "zip")})}); > > // > // oleDbSelectCommand1 > // > this.oleDbSelectCommand1.CommandText = "SELECT dlr_pk, company, dealer, dlr_type, legalname, addr1, addr2, city, st, zip FROM Dealers"; > // > // oleDbInsertCommand1 > // > this.oleDbInsertCommand1.CommandText = "INSERT INTO Dealers(dlr_pk, company, dealer, dlr_type, legalname, addr1, addr2, city, st, zip) " > + "VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)"; > this.oleDbInsertCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("dlr_pk", System.Data.OleDb.OleDbType.Integer, 0, "dlr_pk")); > this.oleDbInsertCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("company", System.Data.OleDb.OleDbType.VarChar, 2, "company")); > this.oleDbInsertCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("dealer", System.Data.OleDb.OleDbType.VarChar, 5, "dealer")); > this.oleDbInsertCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("dlr_type", System.Data.OleDb.OleDbType.VarChar, 3, "dlr_type")); > this.oleDbInsertCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("legalname", System.Data.OleDb.OleDbType.VarChar, 35, "legalname")); > this.oleDbInsertCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("addr1", System.Data.OleDb.OleDbType.VarChar, 35, "addr1")); > this.oleDbInsertCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("addr2", System.Data.OleDb.OleDbType.VarChar, 35, "addr2")); > this.oleDbInsertCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("city", System.Data.OleDb.OleDbType.VarChar, 25, "city")); > this.oleDbInsertCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("st", System.Data.OleDb.OleDbType.VarChar, 2, "st")); > this.oleDbInsertCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("zip", System.Data.OleDb.OleDbType.VarChar, 10, "zip")); > > // oleDbUpdateCommand1 > > this.oleDbUpdateCommand1.CommandText = "UPDATE Dealers SET dlr_pk = ?, company = ?, dealer = ?, dlr_type = ?, legalname = ?, addr1 = ?" > + ", addr2 = ?, city = ?, st = ?, zip = ? WHERE dlr_pk = ? " ; > > this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("?dlr_pk", System.Data.OleDb.OleDbType.Integer, 0, "dlr_pk")); > this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("?company", System.Data.OleDb.OleDbType.VarChar, 2, "company")); > this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("?dealer", System.Data.OleDb.OleDbType.VarChar, 5, "dealer")); > this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("?dlr_type", System.Data.OleDb.OleDbType.VarChar, 3, "dlr_type")); > this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("?legalname", System.Data.OleDb.OleDbType.VarChar, 35, "legalname")); > this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("?addr1", System.Data.OleDb.OleDbType.VarChar, 35, "addr1")); > this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("?addr2", System.Data.OleDb.OleDbType.VarChar, 35, "addr2")); > this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("?city", System.Data.OleDb.OleDbType.VarChar, 25, "city")); > this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("?st", System.Data.OleDb.OleDbType.VarChar, 2, "st")); > this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("?zip", System.Data.OleDb.OleDbType.VarChar, 10, "zip")); > this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("?dlr_pk", System.Data.OleDb.OleDbType.Integer, 0, "dlr_pk")); > > // oleDbDeleteCommand1 > > this.oleDbDeleteCommand1.CommandText = "DELETE FROM Dealers WHERE dlr_pk = ?"; > > this.oleDbDeleteCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("?dlr_pk", System.Data.OleDb.OleDbType.Integer, 0, "dlr_pk")); > > } > > /// <summary> > /// Constructor > /// </summary> > public DealersDataAccessOleDb() > { > this.InitializeComponent(); > } > > /// <summary> > /// Returns an instance of the custom data adapter > /// </summary> > /// <returns></returns> > public override System.Data.IDataAdapter CreateDataAdapter() > { > return this.oleDbDataAdapter1; > } > } >} > >>