datagrid fill problem

[citizenstitch]

Dim sqlselect As String = "select job.jobnum,job.company,job.product_a,job.storcount,job.tline,job.week " & _
        "received.weight,received.boxnum,received.numberrecvd,received.comments,received.recdate,received.bay " & _
        "FROM received RIGHT JOIN Job ON received.JobNum = Job.JOBNUM;"
        da = New SqlCeDataAdapter(sqlselect, ceConn)
        ds = New DataSet("Job")
        da.Fill(ds)
        DataGrid.DataSource = ds.Tables(0)

it gives me errors at the last line. my guess is that it doesnt like my query. not that the sql syntax isnt good,but it doesnt want to bind it. what is the correct way to do this? also how do i filter those records by a certain criteria. what i really want to do is not have all those records viewable, but everything that matches the result of my input box.