Crystal Report View From DataSet Problem

Hi All,

i have created a Report that is designed on atable from my database, but i want it to display as i fill in the dataset !! and it keeps displaying all data in a table not the one that is displayed in datagrid that i populate from my Dataset

here is the code:

Code:

---

        Report1 sReport1 = new Report1();

                        DataSet xmlDs = new DataSet();

                        SqlConnection dbConn = new SqlConnection("data source=.;initial catalog=myDB;persist security info=False;user id=sa;password=");
                        dbConn.Open();

                        string strSql= "select * from orders where security_id='test;
                       
                        SqlCommand dbCmd = new SqlCommand(strSql,dbConn);                               

                        SqlDataAdapter dbAdpt = new SqlDataAdapter(dbCmd);
                       
                        dbAdpt.Fill(xmlDs,"Table");
                       
                        dataGrid1.DataSource = xmlDs;

                        dataGrid1.SetDataBinding(xmlDs,"Table");

                       

                        sReport1.SetDataSource(xmlDs);
                                               
               
                crystalReportViewer1.ReportSource = sReport1;
                        dbConn.Close();

---

On the datagrid its displaying the actual query data but in report its displaying all data not as the query dpecify ??

Any help please ?