Can I use DataTable for SQL difference?

froginwell

as follows
If you set a name for DT

string sql = "select a. *, b. * from sqltb a left join" + dt.tablename + "b on a.id = b.id";

=============
This does not work, the object name is invalid

peng16889

Seems to be impossible

darkcyj

Can you use SQL statements to directly manipulate the DataTable and perform queries and other operations on it.

dongsun

public DataSet aaa(DataTable dt)
{
    string sql ="select a.*,b.* from tba left join "+dt+" b on a.id=b.id";
}


Change it

public DataSet aaa(DataTable dt)
{
step 1:
Read tba data and write to dataTableA

step 2:
Build a dataset and merge dt and dataTableA into the dataset

step 3:
Establish a relationship. From your SQL, dataTableA is the parent table and dt is the slave table

In this way, you can access whatever data you want

}