What's In The Box | Episode 015 | SQL Databases, Query Editor, & SQL Data Logging

What's in the Box Videos
, , ,
1

Join us this Thursday at 12pm CST for Episode 015 of What’s In The Box as Marc Taccolini (Founder/CTO) joins Tolgar Alpagut (VP of Marketing) to explore SQL Databases, Query Editor, & SQL Data Logging

Check out this livestream here

2

Hi! It’s possible to edit a data table using only the data grid? And I would like to know how can I put a combox into my data grid?

3

Hi Guilherme,

1 - Yes, you can create a DataTable and use the Data Source:

590×616 38.2 KB

This way, you can edit the data through the DataGrid in Runtime:

934×598 7.42 KB

For more information you can access: Sparklines in DataGrids - 9.2 - Tatsoft LLC

2 - We understand that you want to change the DataGrid according to the option selected in ComboBox, if so, yes you can. You can use the selected option and give its value to another tag, then you put this tag in the “Data Source” field.

580×620 37.4 KB

Let us know if we understood your question.

Best Regards,

Tatsoft Team.

4

Thank you!

How can I put a combobox in a DataGrid? And I need each option (string) of the combo box to have its value (enum) to assign this value to a specific tag? I would like how change the row background color according to a tag value?

5

Hi Guilherme,

image
image544×539 13.7 KB

We created a display to show to you how to configure a ComboBox with a DataGrid window. So, basically the tag “Tag.text” will be set as “Data Source” as shown in the image below.

image

Then you will have the CodeBehind:

image
image888×248 13.9 KB

Which, in DisplayOpening will create the ComboBox list and in DisplayIsOpen will get the selected value in ComboBox to use in the “Data Source” in “DataGrid”.

First Example:
image

Second Example:
image

Also, where exactly do you want to change the color? Could you send us a print screen please?

Best Regards,
Tatsoft Team.

6

Thank you so much!

Honestly I need to know all functions, properties and animations of DataGrid. I need to do a Dynamic DataGrid, for example: the columns" visibility linked a tag, the row’s background linked a tag…

7

Hi Guilherme,

The main grid properties of the grid, are in the configuration dialog:

606×617 40.3 KB

The other properties are accessible through CodeBehind as shown in the image below:

If you are interested in a specific property, please contact us through email: support@tatsoft.com and we are going to help you with an example.