I apologize up front. I KNOW this has been answered in other threads but I was not able to find them.
Background: I have populated a datatable with data from an Access database. (I know... I know... but it's all they let me have.
) In addition, I have populated two other datatables with data from Excel spreadsheets. I now need to combine these into one table for further processing.
Question: How do I run a query against these internal tables? An adapter requires a connection string, so what is the connection string for an internal table?
Okay, I'm leaving this in case someone else needs it.
Finally found some info on Google. Apparently, you cannot run actual SQL against a datatable. You can only use the datatable.Select method. At least that will allow you to run a filter.
Background: I have populated a datatable with data from an Access database. (I know... I know... but it's all they let me have.
) In addition, I have populated two other datatables with data from Excel spreadsheets. I now need to combine these into one table for further processing.Question: How do I run a query against these internal tables? An adapter requires a connection string, so what is the connection string for an internal table?
Okay, I'm leaving this in case someone else needs it.
Finally found some info on Google. Apparently, you cannot run actual SQL against a datatable.
You can only use the datatable.Select method. At least that will allow you to run a filter.
Last edited:
