public static void UpdateInputFile(String ColumnName, String Value) { String tc = TestSuite.CurrentTestContainer.DataContext.Source.Connector.Name.ToString(); //var source = ; // tc.DataContext.Source=source; // tc.DataContext.Source.Load(); Ranorex.Core.Data.DataCache myConn = DataSources.Get(tc); myConn.Load(); int row1 = TestSuite.CurrentTestContainer.DataContext.CurrentRowIndex; //var colheader= new DataConnectorBindingInfo("ApplicaitonNumber",tc.Id, tc.DataContext); var colnames = TestSuite.Current.CurrentTestContainer.DataContext.AvailableDataColumnNames; int colcount = colnames.Count; int columnindex = 0; for (int i = 0; i < colcount; i++) { if (colnames[i].FullName == ColumnName) { columnindex = i; break; } else if (i == colcount) { return; } } //int index = colnames.IndexOf("ApplicationNumber"); //int colindex = IndexOf(colnames,"ApplicationNumber"); Ranorex.Core.Data.RowCollection propTableRowsCSV = myConn.Rows; //Set the first column value for each row to "new value" // foreach (var row in propTableRowsCSV) { propTableRowsCSV[row1 - 1].Values[columnindex] = Value; // propTableRowsCSV[34].Values[0] = "20"; // propTableRowsCSV[35].Values[0] = "30"; // propTableRowsCSV[35].Values[1] = "30"; //int z = myConn.Columns.IndexOf("ApplicaitonNumber"); //string CellValue = Dataconn.Rows[1].Values[z]; } myConn.Store(); }
public static void UpdateInputFile(String ColumnName, String Value) { String tc = TestSuite.CurrentTestContainer.DataContext.Source.Connector.Name.ToString(); Report.Info("Current testcase:" + tc); Ranorex.Core.Data.DataCache myConn = DataSources.Get(tc); myConn.Load(); int row1 = TestSuite.CurrentTestContainer.DataContext.CurrentRowIndex; var colnames = TestSuite.Current.CurrentTestContainer.DataContext.AvailableDataColumnNames; Report.Info("noOfColumn in Datasheet:" + colnames.Count); int colcount = colnames.Count; int columnindex = 0; for (int i = 0; i < colcount; i++) { Report.Info("ColumnName in Datasheet:" + colnames[i].FullName); if (colnames[i].FullName == ColumnName) { columnindex = i; break; } else if (i == colcount) { return; } } Ranorex.Core.Data.RowCollection propTableRowsCSV = myConn.Rows; Report.Info("noOfRows in Datasheet:" + propTableRowsCSV.Count); { Report.Info("row " + row1 + " and column " + columnindex + " in Datasheet"); //propTableRowsCSV[row1-1].Values[columnindex] = Value; } myConn.Store(); }