pdf.
The Big Idea Method is an online method that develops critical thinking and writing skills.
The Big Ideas method is an online program that develops critical thinking and writing skills
References
Category:American educational theoristsQ:
Dynamic select statement SQL
I have some tables with in a DB, one of the columns is ID of another table.
I want to know how I can write a select statement to get all the records from A with the ID that is in table B.
Table A:
id|data
1|
2|
3|
4|
5|
Table B:
id|name
1|A1
2|A2
The ID of table B and column 'name' has no relation.
I am wondering how I can write this select statement.
A:
This sounds like a joins problem, but there is no join since you want to relate A to B as a foreign key.
You need two joins:
select a.*
from A
join B on B.id = A.id
This produces the result:
id data
1
2
3
4
5
or to better understand it:
select a.id, a.data, b.name
id data name
1 A1
2 A2
3 A3
4 A4
5 A5
Q:
How to use SelectMany LINQ in C#
I have this code to get List of Student from datagridview
var data=dataGridView1.DataSource as DataTable;
Related links: