doubt in crystal report regarding sql server

protected void Button1_Click(object sender, EventArgs e)
    {
        string sql;
        sql="SELECT customer1.username, customer1.FirstName, customer1.LastName, customer1.Address, customer1.city, customer1.state, customer1.contactno, productorder.orcode, productorder.ordate, productorder.icode, productorder.qty, productorder.rate, productorder.delidate
FROM customer1 LEFT JOIN productorder ON customer1.email = productorder.email
WHERE customer1.email="'" + Label1.Text + "'";
        adp = new SqlDataAdapter(sql,con);
        ds = new DataSet();
        adp.Fill(ds,sql);
        if (ds.Tables[sql].Rows.Count >= 0)
        {
            rd = new ReportDocument();
            rd.Load(Server.MapPath("CrystalReport7.rpt"));
            rd.SetDataSource(ds);
            CrystalReportViewer1.ReportSource = rd;
        }
    }