VS 2012 - INNER JOIN TableAdapter and DataTable
-
I have a table adapter that gets information from a SQL 2012 server and I want to do an INN JOIN on it with a datatable created in code that is attached to a datagridview. Basically I have a datagridview with a single column that I will use as a parts list. I want to join it to a parts tableadapter (that has my entire list of parts) to give me only the parts entered in the datagridview. As far as I know I can not filter the tableadapter with a parameter because it is a string field and IN ( a, b, c, d) will not work. Thanks!
-
I have a table adapter that gets information from a SQL 2012 server and I want to do an INN JOIN on it with a datatable created in code that is attached to a datagridview. Basically I have a datagridview with a single column that I will use as a parts list. I want to join it to a parts tableadapter (that has my entire list of parts) to give me only the parts entered in the datagridview. As far as I know I can not filter the tableadapter with a parameter because it is a string field and IN ( a, b, c, d) will not work. Thanks!