well what funny is that i asked the question and i'm answering it!!
anyway to anyone who faces this problem and wants to print a dataset in a web application this code in c# might help..
it export's the dataset to an exel sheet and then u can print it.. not that i used a special page just to print called temp.aspx, but u can do it at the same form.
the button handler cade is
Code:
Response.Redirect("temp.aspx");
'the temp.aspx pageload code is
try
{
int x = Global.x;
//export to excel
DataSet ds = (DataSet)Session["ds"];
GridView1.DataSource = ds;
GridView1.DataBind();
Response.Clear();
Response.Buffer = true;
Response.ContentType = "application/vnd.ms-excel";
Response.Charset = "";
this.EnableViewState = false;
System.Web.UI.HtmlTextWriter(oStringWriter);
Response.Flush();
Response.End();
Global.x += 1;
}
catch (Exception ex)
{
}
note: where Global.x is a file counter, and there is some unuseful code that i didn't show here (incase some sentences made no sense ).
hopefully this will come handy to somebody needs it