I am a PHP/MYSQL developer, slowly venturing into the realm of C#/MSSQL and I am having a problem in C# when it comes to reading an MSSQL query that joins two tables.
Given the two tables:
SELECT * FROM TableA,TableB WHERE TableA.b_id = TableB.id;
SqlDataReader data_reader= sql_command.ExecuteReader();
The result set only sees the returned data/column names, not the underlying table. Change your query to something like
SELECT TableA.Name as Name_TA, TableB.Name as Name_TB from ...
Then you can refer to the fields like this: