bind data to gridview

[lyne_asp]

Hello everybody,

PLease help me to bind the data from datasource to a dridview, here is my command

 OracleDataAdapter adTarget = new OracleDataAdapter
               ("SELECT  B.DMAIC_DESC DMAICDESC ,a.TARGET_MONTH    MONTH , a.TARGET_YEAR YEAR FROM SIXSIGMA_USER.DMAIC_TARGET A, SIXSIGMA_USER.DMAIC B WHERE a.PROJECT_ID = '" + DropDownListProject.SelectedValue + "'  AND A.DMAIC_CODE = B.DMAIC_ID ", Conn);
        

        DataSet dsTarget = new DataSet();
        adTarget.Fill(dsTarget);
        GridViewTarget.DataSource = dsTarget.Tables[0];
        GridViewTarget.DataBind();

I cant bind it to gridview, while when my select Command is from a one table, this code works, like the code below

OracleDataAdapter adTarget = new OracleDataAdapter
               ("SELECT  *    FROM SIXSIGMA_USER.DMAIC_TARGET  WHERE PROJECT_ID = '" + DropDownListProject.SelectedValue + "'  ", Conn);
        

        DataSet dsTarget = new DataSet();
        adTarget.Fill(dsTarget);
        GridViewTarget.DataSource = dsTarget.Tables[0];
        GridViewTarget.DataBind();

Thanks in advance

[kenobewan]

So the problem is with your select query?

[debasisdas]

You are unable to bind to the grid
or
unable to retrive the desired data from database ?