Comments by ruzan hizar (Top 15 by date)

Thanks for the help...but it also not supporting in my case. I'm taking the data from Access database using XML dataset and assigning the dataset to an object. from that object only i'm taking to the report.
here is my code...

DataTable dt = new DataTable();
Class.clsReport rpt = new Cost.Class.clsReport();
dt = rpt.GenerateMainReport(Pcode);

DataSet ds = new dsReport();
foreach (DataRow dr in dt.Rows)
{
ds.Tables["mainReport"].ImportRow(dr);
}
Report.MainReport objMain = new MainReport();
objMain.SetDataSource(ds);

crvMain.ReportSource = objMain;
crvMain.Refresh();
--------------------------------------------------------------------
public DataTable GenerateMainReport(string Pcode)
{
DataTable ds = new DataTable();
try
{
string sqlStr = "SELECT * FROM tblCost WHERE Product_Code = '" + Pcode + "'";

con = new OleDbConnection(clsConnection.connect);
con.Open();

da = new OleDbDataAdapter();
da.SelectCommand = new OleDbCommand(sqlStr, con);
da.SelectCommand.ExecuteNonQuery();
da.Fill(ds);
return ds;
}
catch (Exception ee)
{
throw ee;
return ds;
}
}
Please any one can check this codes and let me know if any other easy ways to do this task... because i'm new to c#...
Thanks.