bind data from two tables

See more:

C#

i want to bind fields from two table in gridview.

e.g Table A
fields :A B C D

Table B
fields : E F G H

so i want to bind grid with first two fileds of A and first Fileds From B.

>> E is a checkbox and i want to bind it with E field and display all records from A.

Thnaksss....
Mitesh

GridView1.DataSource = c.getdata("select id,title,bit_indicator from document where category='" + drop_cat.SelectedItem.Text + "' and subctgry='" + drop_sub_cat.SelectedItem.Text + "'");
        GridView1.DataBind();

this is code which display all records from the document table but i want first field which is checkbox and it value come from second table for checked or unchecked the checkbox and all records display from the first table.