i want data from to tables in a single gridview can i do it

How these tables are related... means relationship

if the payout_transcation table contains Forienkey relationship from payout_master, then
1) write a query joining 2 tables. Then bind the resultset to DataGrid or GridView
or
2) Create a view on both table and then query the view and bind the resultset to DataGrid or GridView

Please find the following query for sample

SELECT PT.*, PM.* FROM payout_transcation AS PT INNER JOIN payout_master AS PM ON PT.<forienkey> = PM.<primaykey>
</primaykey></forienkey>

Hope it helps you
Happy Coding :)

Join the 2 tables and bind the result to your grid view.

SqlConnection con = new SqlConnection(ConfigurationManager.AppSettings["conString"]);

SqlDataAdapter da = new SqlDataAdapter("select * from payout_transcation,payout_master", con);
        DataSet ds = new DataSet();
        da.Fill(ds);
        grv.DataSource = ds;
        grv.DataBind();

Hi friend,

yes you have to join to table(that you want to saw on grid) and then bind them to data grid view.