bind crystal report with multiple query

See more:

C#

.NET

hello everybody,

i have window projet in which i want to bind crystal report with multiple query i have done by by adding command but the problem is that when i run the program it asking password and usernam of database every time and the take to much time to execute

i have only single crystal report and i want to bind it with more then one query like want to see all senior employee whose age greater then 50, and in next query i want to see all employee whose department is marketing in the same crystal report, but the problem is that it display only the first query result i bind my crystal report like that...

steps . add new item -> add crystal report -> create new connection -> chose database -> add table both (tb_Dept & tb_Employee) because i have id of dept. in my tb_Employee -> chose the field to display -> select format for crystal report -> finish

if(comboBox1.SelectedIndex==0)
           {
               //qry= "query for senior employee"
           }
           else if(comboBox1.SelectedIndex==1)
           {
            //qry= "query for marketing employee"
           }
           /* add namespace
             using CrystalDecisions.Shared;
             using CrystalDecisions.CrystalReports.Engine; */
           SqlDataAdapter adp=new SqlDataAdapter(qry,/*connection*/);
           DataTable dt=new DataTable("dt1");
           adp.Fill(dt);
           ReportDocument rd=new ReportDocument();
           rd.Load(Application.StartupPath+"\\CrystalReport1.rpt");
           crystalReportViewer1.ReportSource=rd;

the output is same only show the result of first query !
plz help me who one read this question.

Thanks in advance
Parveen Rathi