How to get data from 2 table in ms access form same data base (search query )

See more:

C#

Hello ,
I want to get data from tow table from MS access database. Database name Record and table name Area (SNO, AreaCode, Code ) City (SNO, Name , city code ) I want to make a single search single search query on base of SNO

Kindly tell me i have code which get data from one table and search in one table i want to make for two table

What I have tried:

OleDbConnection mycnc = new OleDbConnection("Provider=Microsoft.Ace.OLEDB.12.0; Data Source=F:\\Database1.accdb");
OleDbDataAdapter myadpt = new OleDbDataAdapter();
DataSet mydtSet = new DataSet();
myadpt.SelectCommand = new OleDbCommand();

myadpt.SelectCommand.CommandText = "select * from area where SNO=" + textBox1.Text + "";

myadpt.SelectCommand.Connection = mycnc;
mycnc.Open();
myadpt2.Fill(mydtSet, "area");
mycnc.Close();

dataGridView1.DataSource = mydtSet;
dataGridView1.DataMember = "area";
MessageBox.Show("successfully search !");
textBox1.Clear();