A macro substitution function
Posted on 2004-08-24
Hello everyone there,
I am using VB.net and I want an equivalent of a macro substitution function and what I need is if I had info stored in a variable to use the data in the variable. This is what I mean:
Dim Field1, Field2, Field3 As String
m_daDataAdapter = _
New OleDb.OleDbDataAdapter("SELECT * FROM PAF _
ORDER BY Surname, ItemNumber, Dept", m_cnADONetConnection)
But instead of using the actual field names be able to use the values stored in Field1, Field2 and Field3. Meaning that I can sort on different fields any time.
Anyone there with a solution? Thanks in advance.