create sql table entries with date as columns per date

OMG, thank you very much chill, Whats with the code:

Private Sub TEST_CHILL20()

Dim sCommand As MySqlCommand = New MySqlCommand()
Dim sqlQuery As System.Text.StringBuilder = New System.Text.StringBuilder()

sqlQuery.Append("select MSGR,PRODNAME,RteVal,")
'Set up the start date for 14 days prior to the datepicker (i.e. datepicker date is 15th date)
Dim CalcDate As Date = dtFrom.Value.Date.AddDays(-14)
For i As Integer = 1 To 15
sqlQuery.Append(String.Format("sum(case when rmdte = @Date{0} then ProdVal else 0 end) `DAY {1}`,", 15 - i + 1, i))

sCommand.Parameters.AddWithValue(String.Format("@Date{0}", i), CalcDate)
CalcDate = CalcDate.AddDays(1)
Next

sqlQuery.Append("sum(ProdVal)*rteval as Total from")
sqlQuery.Append("select date(remit_date) as rmdte, messenger as Msgr, item as ProdName, item_value as ProdVal,")
sqlQuery.Append("b.product as RteProd,b.product_value as Rteval FROM remittance a JOIN rate b on a.item=b.product")
sqlQuery.Append("where a.messenger = 'MESSENGER 3' and b.ratecode = '5i.35' ) as SOURCEDATA group by ProdName")

connectionString = "Server=localhost ; Port=3306 ; Database=zipdb ; user id=root; password='L3265_Vi42ck9_Ho83l13_';"
cnn = New MySqlConnection(connectionString)
cnn.Open()

sCommand.CommandText = sqlQuery.ToString()
Dim dscmd As New MySqlDataAdapter(Xsql, cnn)
Dim ds As New DataSet
dscmd.Fill(ds)
dgw.DataSource = ds.Tables(0)
cnn.Close()
End Sub





the error says that: "An unhandled exception of type 'System.InvalidOperationException' occurred in MySql.Data.dll
Additional information: The CommandText property has not been properly initialized."

thank you so much