Re: The Select statement includes a reserved word or an argument name that is misspel

[kaamini]

I am using vb.net 2005 and access in back end.
my code is :
[Sub fillreport(ByVal p As String)
Dim ocon As New OleDb.OleDbConnection
Dim cmd As New OleDb.OleDbCommand
Dim da As New OleDb.OleDbDataAdapter
Dim dt As New DataTable

ocon.ConnectionString = constring

Try
ocon.Open()
cmd.CommandText = "select rpt_custpur.pur_id as purid,rpt_custpur.pur_date as purdat,rpt_custpur.pur_product_id as purproductid,rpt_custpur.pur_product_quantity as pur_product_quantity,rpt_custpur.pur_from as purfrm,rpt_custpur.pur_bil_no as purbilno,rpt_custpur.enter_by as enterby,rpt_custpur.pur_rate as purrate where rpt_custpur.pur_from like '" & cbo_pur.Text & "%'"
cmd.Connection = ocon
da.SelectCommand = cmd
da.Fill(dt)

cryrpt.Load("c:\BIFT\BIFT\rpt_custpur.rpt")
cryrpt.SetDataSource(dt)
CrystalReportViewer1.ReportSource = cryrpt

Catch ex As Exception
MessageBox.Show(ex.Message, "Report could not be created", MessageBoxButtons.OK, MessageBoxIcon.Error)

End Try


End Sub]

[Rabbit]

I see no from clause in your select statement.