How to add a variable in SELECT FUNCTION

[shikharno.7]

Please see below image.

How do I insert a variable in the following highlighted area —>

ExcelDataTable.Select(“Programme = ‘Non Operations’”)

[vrdabberu (Varunraj Dabberu)]

Hi @shikharno.7

Try this way:
programName = "Non Operations"
ExcelDataTable.Select("Programme = '" + programName + "'")

Regards

[ppr (Peter Preuss)]

@shikharno.7

ExcelDataTable.Select(“Programme = ‘Non Operations’”)

one of many options:

ExcelDataTable.Select(String.Format("Programme = '{0}'", YourStringVar))

[aysenurerdem (Ayşe Nur Erdem)]

Hi,

Can you try String.Format merhod in Select?

ExcelDataTable.Select(String.Format(“Programme = ‘{0}’”, yourVariable))