1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30
| [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
private void InitAdapter() {
this._adapter = new global::System.Data.OleDb.OleDbDataAdapter();
global::System.Data.Common.DataTableMapping tableMapping = new global::System.Data.Common.DataTableMapping();
tableMapping.SourceTable = "Table";
tableMapping.DataSetTable = "tbVolume";
tableMapping.ColumnMappings.Add("VersionID", "VersionID");
tableMapping.ColumnMappings.Add("I_Minutes_Start_REF", "I_Minutes_Start_REF");
tableMapping.ColumnMappings.Add("ClickDate", "ClickDate");
tableMapping.ColumnMappings.Add("Volume", "Volume");
this._adapter.TableMappings.Add(tableMapping);
this._adapter.InsertCommand = new global::System.Data.OleDb.OleDbCommand();
this._adapter.InsertCommand.Connection = this.Connection;
this._adapter.InsertCommand.CommandText = "INSERT INTO `tbVolume` (`VersionID`, `I_Minutes_Start_REF`, `ClickDate`, `Volume`" +
") VALUES (?, ?, ?, ?)";
this._adapter.InsertCommand.CommandType = global::System.Data.CommandType.Text;
this._adapter.InsertCommand.Parameters.Add(new global::System.Data.OleDb.OleDbParameter("VersionID", global::System.Data.OleDb.OleDbType.Integer, 0, global::System.Data.ParameterDirection.Input, ((byte)(0)), ((byte)(0)), "VersionID", global::System.Data.DataRowVersion.Current, false, null));
this._adapter.InsertCommand.Parameters.Add(new global::System.Data.OleDb.OleDbParameter("I_Minutes_Start_REF", global::System.Data.OleDb.OleDbType.Integer, 0, global::System.Data.ParameterDirection.Input, ((byte)(0)), ((byte)(0)), "I_Minutes_Start_REF", global::System.Data.DataRowVersion.Current, false, null));
this._adapter.InsertCommand.Parameters.Add(new global::System.Data.OleDb.OleDbParameter("ClickDate", global::System.Data.OleDb.OleDbType.Date, 0, global::System.Data.ParameterDirection.Input, ((byte)(0)), ((byte)(0)), "ClickDate", global::System.Data.DataRowVersion.Current, false, null));
this._adapter.InsertCommand.Parameters.Add(new global::System.Data.OleDb.OleDbParameter("Volume", global::System.Data.OleDb.OleDbType.Double, 0, global::System.Data.ParameterDirection.Input, ((byte)(0)), ((byte)(0)), "Volume", global::System.Data.DataRowVersion.Current, false, null));
this._adapter.UpdateCommand = new global::System.Data.OleDb.OleDbCommand();
this._adapter.UpdateCommand.Connection = this.Connection;
this._adapter.UpdateCommand.CommandText = "UPDATE tbVolume SET VersionID = ?, I_Minutes_Start_REF = ?, Clic" +
"kDate = ?, Volume = ?";
this._adapter.UpdateCommand.CommandType = global::System.Data.CommandType.Text;
this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.OleDb.OleDbParameter("VersionID", global::System.Data.OleDb.OleDbType.Integer, 0, global::System.Data.ParameterDirection.Input, ((byte)(0)), ((byte)(0)), "VersionID", global::System.Data.DataRowVersion.Current, false, null));
this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.OleDb.OleDbParameter("I_Minutes_Start_REF", global::System.Data.OleDb.OleDbType.Integer, 0, global::System.Data.ParameterDirection.Input, ((byte)(0)), ((byte)(0)), "I_Minutes_Start_REF", global::System.Data.DataRowVersion.Current, false, null));
this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.OleDb.OleDbParameter("ClickDate", global::System.Data.OleDb.OleDbType.Date, 0, global::System.Data.ParameterDirection.Input, ((byte)(0)), ((byte)(0)), "ClickDate", global::System.Data.DataRowVersion.Current, false, null));
this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.OleDb.OleDbParameter("Volume", global::System.Data.OleDb.OleDbType.Double, 0, global::System.Data.ParameterDirection.Input, ((byte)(15)), ((byte)(0)), "Volume", global::System.Data.DataRowVersion.Current, false, null));
} |
Partager