Using an sql statement in my datagridview

[msboddie]

I have a datagridview and a sql statement and I need to get the data to populate in the datagridview.

Query:
sqlStr = "SELECT Release,PRODWK,SHIPMON,COMPL,TGTSHIP,SCHPROD,AB,ARM,SHAFT,FIT,HDW,FIN,WELDCMP,DATE_REQ"
sqlStr += " FROM jobscopeMeyer.dbo.PPJOBM p "
sqlStr += " Left JOIN ("
sqlStr += " Select SearchKey As RELEASE_PU, "
sqlStr += " MAX(Case When DataItem = '27 PRODWK' THEN AlphaValue END) AS 'PRODWK',"
sqlStr += " MAX(CASE WHEN DataItem = '28 SHIPMON' THEN AlphaValue END) AS 'SHIPMON',"
sqlStr += " MAX(CASE WHEN DataItem = '30 %COMPL' THEN AlphaValue END) AS 'COMPL',"
sqlStr += " MAX(CASE WHEN DataItem = '31 TGTSHIP' THEN AlphaValue END) AS 'TGTSHIP',"
sqlStr += " MAX(CASE WHEN DataItem = '70 SCHPROD' THEN AlphaValue END) AS 'SCHPROD',"
sqlStr += " MAX(CASE WHEN DataItem = '81 AB%' THEN NumericValue END) AS 'AB',"
sqlStr += " MAX(CASE WHEN DataItem = '82 ARM%' THEN NumericValue END) AS 'ARM',"
sqlStr += " MAX(CASE WHEN DataItem = '83 SHAFT%' THEN NumericValue END) AS 'SHAFT',"
sqlStr += " MAX(CASE WHEN DataItem = '84 FIT%' THEN NumericValue END) AS 'FIT',"
sqlStr += " MAX(CASE WHEN DataItem = '85 HDW%' THEN NumericValue END) AS 'HDW',"
sqlStr += " MAX(CASE WHEN DataItem = '86 FIN%' THEN NumericValue END) AS 'FIN',"
sqlStr += " MAX(CASE WHEN DataItem = '87 WELDCMP' THEN AlphaValue END) AS 'WELDCMP'"
sqlStr += " From jobscopeMeyer.dbo.UserDefinedFields"
sqlStr += " GROUP BY SearchKey"
sqlStr += ") PU ON RELEASE_PU = RELEASE"
sqlStr += " Left JOIN ("
sqlStr += " Select RELEASE AS RELEASE_PJ, MAX(DATE_REQUESTED) AS DATE_REQ"
sqlStr += " From JobscopeMeyer.dbo.PPJOBD"
sqlStr += " WHERE DATE_REQUESTED NOT IN (0,99999999)"
sqlStr += " GROUP BY RELEASE"
sqlStr += " ) PJ ON RELEASE_PJ = RELEASE"
sqlStr += " where RELEASE = '" + strRelease + "'"

Here is the output from the query:



Here is what the Datagridview look like: