private DataTable GetTestDataTableFromDB(string testID, Sybase.Data.AseClient.AseConnection conn)
 {
     DataTable table = new DataTable(testID);
     using (Sybase.Data.AseClient.AseDataAdapter adapter = new Sybase.Data.AseClient.AseDataAdapter("select * from QA_PAC_TIMING where TE_REF like '"+testID+"'" ,conn)) {
         adapter.Fill(table);
     }
     return table;
 }
 private void FillLocalUDTTable(DataTable gridValues)
 {
     Sybase.Data.AseClient.AseConnection conn = new Sybase.Data.AseClient.AseConnection(connectionString);
     PAC_TimingObject timingObject = new PAC_TimingObject();
     string maxLogicalTeNumber =  "PAR.TE.";
     try {
         conn.Open();
         DataTable table = new DataTable("TempTable");
         foreach (DataRow row in gridValues.Rows) {
             string selectedTe = row["closestCPUTENumber"].ToString();
             string executionContext = row["executionCtx"].ToString();
             using (Sybase.Data.AseClient.AseDataAdapter adapter = new Sybase.Data.AseClient.AseDataAdapter("Select * from QA_PAC_TIMING where TE_REF='"+selectedTe+"' and EXECUTION_TYPE='"+executionContext+"'" ,conn)) {
                 int rowsNumber =   adapter.Fill(table);
                 if (rowsNumber >1) {
                     rowsNumber = 0;
                 }
             }
         }
         Sybase.Data.AseClient.AseCommand commandMaxTE = new Sybase.Data.AseClient.AseCommand("select LOGICAL_TE from QA_PAC_REFERENCES_INT where ID in (Select max(ID) from QA_PAC_REFERENCES_INT)",conn);
         object returnedValue = commandMaxTE.ExecuteScalar();
         if (returnedValue !=null) {
             string[] teValueSplit = returnedValue.ToString().Split(new char[] {'.'},StringSplitOptions.RemoveEmptyEntries);
             Decimal teNumber = Convert.ToDecimal(teValueSplit[2]);
             teNumber = teNumber +1;
             maxLogicalTeNumber = maxLogicalTeNumber+teNumber.ToString("0000000");
         } else {
             maxLogicalTeNumber= maxLogicalTeNumber+"0000000";
         }
         DataTable table2 = table.Copy();
         table2.Columns.Add("SELECTED_TE");
         table2.Columns.Add("TE_GROUP");
         table2.Columns.Add("LOGICAL_TE");
         foreach (DataRow row in table2.Rows) {
             row["SELECTED_TE"]= row["TE_REF"].ToString();
             row["TE_GROUP"] = txtInputTes.Text.Trim();
             row["LOGICAL_TE"] = maxLogicalTeNumber;
         }
         dgvIntermediate.DataSource = table2;
     } catch (Exception ex) {
         CommonUtils.ShowError(ex.Message,ex);
     } finally {
         conn.Close();
     }
 }