You can use Query with JOINS for this purpose. Sample code is here below:
string constr = "Data Source=.\\SQLEXPRESS; database=Library; Persist Security Info=False; Integrated Security=true;";
using (SqlConnection con = new SqlConnection(constr))
{
cmd1 = con.CreateCommand();
cmd1 = new SqlCommand("Select B.BookName, P.Publication from Books B Inner Join Publication P on B.PublicationCode = P.PublicationCode");
cmd1.Connection = con;
ds = new DataSet();
adp = new SqlDataAdapter(cmd1);
adp.Fill(ds, "Books");
dataGridView1.DataSource = ds.Tables["Books"].DefaultView;
}
Hope this will be useful for you.