Database

Public DBConn As ADODB.Connection
 
DBConn.ConnectionString = "Provider=MSDATASHAPE; Data Provider=SQLOLEDB.1;Data Source=TOSHIBA\SQLEXPRESS; Initial Catalog=" & App.Path & "\AVON_AIR_Data.mdf; User ID=sa; Password=; Integrated Security=SSPI; Persist Security Info=False;"
 DBConn.Open DBConn.ConnectionString

RowId  OrderId  OldOrderId  Type  Example Data  
8787   1        NULL        I     The first order in sequence 1
9837   2        1           U     The second order in sequence 1
10838  3        2           U     The third order in sequence 1
11873  4        3           U     The fourth order in sequence 1
12554  5        NULL        I     The first order in sequence 2
14113  6        5           U     The second order in sequence 2
15003  7        6           U     The third order in sequence 2
18343  8        7           U     The fourth order in sequence 2

public virtual object Execute()
      {         return this.command.ExecuteNonQuery();
      }

private void SetSystemEnviroment()
        {
            try
            {
                using (OracleCommand command = this.con.CreateCommand())
                {
                    command.CommandText = "SetSystemEnviroment";
                    command.CommandType = CommandType.StoredProcedure;

                    command.ExecuteNonQuery();
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
                return;
            }
        }