This form allows users to create a new package entry in Oracle Database Lite.

When users make changes to the package data, this form uses OracleAdapter's Update method to save the changes to Oracle Database Lite. Me.packRoute.Text = row.Item(7).ToString() Me.packState.Text = row.Item(5).ToString() Me.packCity.Text = row.Item(4).ToString()

Me.packStreet.Text = row.Item(3).ToString() Me.packWeight.Text = row.Item(2).ToString() Me.packDesc.Text = row.Item(1).ToString() Once the Dataset is filled with Oracle Database Lite data, this form populates the UI controls using data from the DataSet object.ĭim rows As DataRowCollection = table.Rows Once an OracleAdapter object has been created successfully, this form creates a Dataset object and populates it with data from Oracle Database Lite, using the OracleDataAdapter object that was created. These OracleCommand objects are created by the transport.vb module during the main form loading process. When this form is loaded, it creates an instance of the OracleDataAdapter object and sets the appropriate OracleCommand objects namely, Select, Update, and Delete. This form demonstrates the usage of the OracleDataAdapter and DataSet classes.

It also allows the user to modify and save existing packages. This form displays existing packages from the database.

Download microsoft activesync 3.7.1