Comments by Member 12270013 (Top 6 by date)

Can you be a bit more precise on the requirement.

please clarify whether,
1. "Part of SQL query" refers to a specific "Column" only, which you trying to SELECT?
eg query: SELECT empName FROM EMPLOYEES --do you need 'empName' as output to show in datagrid and not its data ?

2. "column from SQL query 'TabPrikazMzdyAZmetky.DatPorizeni' to datagridview column name 'Date'" : You want data of that column name itself to be binded to date column of datagrid? OR data under 'TabPrikazMzdyAZmetky.DatPorizeni' to your date Column of datagrid.

Firstly, where you are willing to bind both dropdowns? on pageload OR seperate method?

1) If Both are to to be binded on pageload : Change SQL query to bring both columns detail and then Use Linq to seperate it into lists and bind he lists to respective dropdowns.

2) If they are To be Binded seperately : Then You have straight forward answer. As you have made it for "IPAddress" Column, change that Column name to "MachineName".

I Have updated the solution.
please note, the value of rowValue is assumed to be a comma separated value. I hope it is the same way in your case too.

when you say 'Looping' you iterate through every single piece of string. i.e. every char in it & now you can divide that single digit by 10000. (but is that really what you need)
Now, other way around your question may be, "Condition checking on the whole string" if its a digit and then performing division on the whole string
then Do you mean to use
1> Mode(%) operation to divide the TrainNumber and get remainder?
This divides the string like (123456 % 10000) = 3456(result you get)
Now perform operations based on "3456"
OR
2> Divide(/) operation on TrainNumber and get Quotient?
This Divides string like (123456 / 10000) = 12.3456 (result you get)