ASP.NET - how to display in gridview reports

i have from date, services, userid, username, credit debit(radiobtnlist) amount

now i want to display reports from tables each are diff tables how ?
i want qry ?

{
adap = new SqlDataAdapter("select a.fromdate,b.servicename,c.userid,c.username,d.type,e.debit,a.total from creditadd a,serve b,memreg c, serviceamount d,creditdeduct e where a.fromdate between 07-02-2012 and 14-02-2012", con);

ds = new DataSet();

adap.Fill(ds);

GridView1.DataSource = ds;

GridView1.DataBind();
}

how to take reports from other tables ?

Hi,
Here is the solution.

public DataTable compareDataTables(DataTable First, DataTable Second) { First.TableName = "FirstTable"; Second.TableName = "SecondTable";

        //Create Empty Table
        DataTable table = new DataTable("Difference");
        DataTable table1 = new DataTable();
        try
        {
            //Must use a Dataset to make use of a DataRelation object
            using (DataSet ds4 = new DataSet())
            {
                //Add tables
                ds4.Tables.AddRange(new DataTable[] { First.Copy(), Second.Copy() });

                //Get Columns for DataRelation
                DataColumn[] firstcolumns = new DataColumn[ds4.Tables[0].Columns.Count];

                for (int i = 0; i < firstcolumns.Length; i++)
                {
                    firstcolumns[i] = ds4.Tables[0].Columns[i];
                }

                DataColumn[] secondcolumns = new DataColumn[ds4.Tables[1].Columns.Count];

                for (int i = 0; i < secondcolumns.Length; i++)
                {
                    secondcolumns[i] = ds4.Tables[1].Columns[i];
                }

                //Create DataRelation
                DataRelation r = new DataRelation(string.Empty, firstcolumns, secondcolumns, false);

                ds4.Relations.Add(r);

                //Create columns for return table
                for (int i = 0; i < First.Columns.Count; i++)

Hope it helps.

I think you want to show something like header/ details relationship data in gridview

Refer this post -> http://itdeveloperzone.blogspot.in/2010/11/gridview-inside-gridview-in-aspnet.html