how to do reporting with sql in asp.net c#

See more:

C#

ASP.NET

Please some one tell that how to do reporting with sql database in asp.net c#
I have done reporting with dataset it is giving output.

My code is:

DataSet1 ds = new DataSet1();
            DataTable t = ds.Tables.Add("Items");
            t.Columns.Add("COMP_NO", Type.GetType("System.Int32"));
            t.Columns.Add("STATUS", Type.GetType("System.String"));

            DataRow r;
            int i = 0;
            for (i = 0; i <= 9; i++)
            {
                r = t.NewRow();
                r["COMP_NO"] = i;
                //r["STATUS"] = "Item" + i;

                r["STATUS"] = i;
                t.Rows.Add(r);

But I need a reporting with sql database, but I don't know how.
Please someone tell that how to do reporting with sql database.