anxious! !! !! How to use DBGrid to display the contents of another data table? (Wait for answers online)

824655

I use ADOConnection1 + ADOTable1 + DataSource1 + DBGrid1 to access the Access database, but DBGrid can only display the linked tables, and somehow dynamically link other tables.
  It is to use a button to excite another table and display it in the current DBGrid.

red1188

Wouldn't adotable-> tablename = "you want a table" work?
For example: the table you want is: table, write in a button click event:
adotable-> active = false;
adotable-> tablename = "table";
adotable-> active = true;
That should do it.

delraich

Did not understand, do you want to display two tables in a DBGrid, or do you want to display two different tables in two DBGrid?

delraich

I suggest that the Lord make the problem clear, and others can help you ~

zhongshuan

Change the name of tablename and reopen
Otherwise, just use the adoquery control, and you can use some sql statements.

mad_diablo

Everyone makes sense

824655

What I mean is that the table in the current DBGrid is replaced with the contents of another table, not the two tables are merged. (Use a button to change)
It hasn't been solved so far. I haven't used the following methods.

Form_yhzlgl-> ADOConnection1-> DefaultDatabase = "D:\hnsfot_mrp\Access\student_01";
Form_yhzlgl-> ADOConnection1-> LoginPrompt = false;
Form_yhzlgl-> ADOConnection1-> Connected = true;
           // Set ADOConnection1
Form_yhzlgl-> ADOTable1-> Connection = ADOConnection1;
Form_yhzlgl-> ADOTable1-> TableName = "Table name";
Form_yhzlgl-> ADOTable1-> Active = true;
           // Set ADOTable1
Form_yhzlgl-> DataSource1-> DataSet = ADOTable1;
           // Set DataSource1
Form_yhzlgl-> DBGrid1-> DataSource = DataSources1;
           // Set DBGrid1

delraich

Never used ACCESS, SQL Server implementation seems very simple.
void __fastcall TForm1 :: Button1Click (TObject * Sender)
{
  ADOQuery1-> Close ();
  ADOQuery1-> SQL-> Clear ();
  ADOQuery1-> SQL-> Text = "select * from biao2";
  ADOQuery1-> Open ();
}

824655

This issue has been resolved, thank you for your participation!
  I am not grateful.