Inline Code Example Here
con.Open()
cmd.Connection = con
cmd.CommandText = "SELECT MONTH(SalesDate) as MonthlySales,Detail.ProductID, Sum (Detail.Qty/30) as Qty FROM Detail INNER JOIN HeadON Detail.HeadID = Head.HeadIDGroup By MONTH(SalesDate), Detail.ProductID"
Dim da As New SqlDataAdapter("SELECT MONTH(SalesDate) as MonthlySales,Detail.ProductID, Sum (Detail.Qty/30) as Qty FROM Detail INNER JOIN HeadON Detail.HeadID = Head.HeadIDGroup By MONTH(SalesDate), Detail.ProductID", con)
Dim dt As New DataTable
da.Fill(dt)
DataGridView1.DataSource = dt
The above is my query for my datagrid view nd it keeps saying
Incorrect syntax near '.'.
but when i do it in the query bulider in sql server it is fine can someone help please