Page History

...

Once the database and table are configured, the user can execute any valid SQL query to interact with the selected Snowflake table.

Executing Query

When the execution button is clicked, the ExecuteQuery method in CodeBehind assigns the query from the TextBox to the SqlStatement in the dataset query and runs SelectCommandAsync to fetch data. The retrieved data populates the queryDataTable Tag, which updates the DataGrid display.

public async Task ExecuteQuery(object sender, System.Windows.Input.InputEventArgs e)
{
	@Dataset.Query.QuerySnowflake.SqlStatement = @Tag.snowflakeQuery;
	@Tag.queryDataTable = await @Dataset.Query.QuerySnowflake.SelectCommandAsync();
}

...

Reference Information

→ See Datasets for more information.

...