SetValue() публичный Метод

public SetValue ( int columnOffset, Field value ) : void
columnOffset int
value Field
Результат void
Пример #1
0
        public static async Task SetRowValues()
        {
            var tableInfo = new TableInfo(new ObjectName("table1"));

            tableInfo.Columns.Add(new ColumnInfo("a", PrimitiveTypes.Integer()));
            tableInfo.Columns.Add(new ColumnInfo("b", PrimitiveTypes.VarChar(22)));

            var table = new TemporaryTable(tableInfo);

            var row = table.NewRow();

            table.SetValue(row, 0, SqlObject.Integer(45));
            table.SetValue(row, 1, SqlObject.String(new SqlString("992")));

            Assert.Equal(1, table.RowCount);

            var value1 = await table.GetValueAsync(0, 0);

            Assert.Equal(SqlObject.Integer(45), value1);
        }
Пример #2
0
        private void ReadAll()
        {
            if (Result.Type == StatementResultType.CursorRef) {
                var tableInfo = Result.Cursor.Source.TableInfo;
                localTable = new TemporaryTable("##LOCAL##", tableInfo);

                foreach (var row in Result.Cursor) {
                    var rowIndex = localTable.NewRow();
                    for (int i = 0; i < row.ColumnCount; i++) {
                        localTable.SetValue(rowIndex, i, row.GetValue(i));
                    }
                }
            }
        }