Filter Two Table And Display In GridView RSS

• • Reply
  

  afastars

  Member

  52 Points

  221 Posts

  Filter Two Table And Display In GridView

  Nov 12, 2012 07:21 AM|LINK

  i got these error

  Incorrect syntax near the keyword 'like'.

  when i try to filter data, below is my code:

  Dim carian As String

  If DrpKategori.SelectedValue = "Ponteng" And DrpSubKes.SelectedValue = "Perhimpunan" Then           

  carian ="SELECT MaklumatPelajar.Nama, MaklumatPelajar.NoIc, KesalahanDisiplin.KategoriKes, KesalahanDisiplin.SubKes" & "KesalahanDisiplin.AduanOleh FROM MaklumatPelajar INNER JOIN KesalahanDisiplin ON MaklumatPelajar.IdPelajar = KesalahanDisiplin.IdPelajar" & _"where(SubKes like '%" + DrpSubKes.SelectedValue.ToString() + "%')"

  SqlDataSource1.SelectCommand = carian

  If GridView1.Rows.Count > 0 Then

  GridView1.EmptyDataText ="No Information"

  End If

  Need help from expertise here

• • Reply
  

  me_ritz

  Star

  9339 Points

  1448 Posts

  Re: Filter Two Table And Display In GridView

  Nov 12, 2012 07:46 AM|LINK

  afastars

  carian ="SELECT MaklumatPelajar.Nama, MaklumatPelajar.NoIc, KesalahanDisiplin.KategoriKes, KesalahanDisiplin.SubKes" & "KesalahanDisiplin.AduanOleh FROM MaklumatPelajar INNER JOIN KesalahanDisiplin ON MaklumatPelajar.IdPelajar = KesalahanDisiplin.IdPelajar" & _"where(SubKes like '%" + DrpSubKes.SelectedValue.ToString() + "%')"

  Change this to:

  carian = "SELECT MaklumatPelajar.Nama, MaklumatPelajar.NoIc, KesalahanDisiplin.KategoriKes, KesalahanDisiplin.SubKes" & ",KesalahanDisiplin.AduanOleh FROM MaklumatPelajar INNER JOIN KesalahanDisiplin ON MaklumatPelajar.IdPelajar = KesalahanDisiplin.IdPelajar" & _
  " where KesalahanDisiplin.SubKes like '%" + DrpSubKes.SelectedValue.ToString() + "%'"

  
  
  

  Please mark the post as "Answer" that helps you.
  • Edited by me_ritz on Nov 12, 2012 07:47 AM
  • Marked as answer by afastars on Nov 12, 2012 09:55 AM
• • Reply
  

  afastars

  Member

  52 Points

  221 Posts

  Re: Filter Two Table And Display In GridView

  Nov 12, 2012 09:54 AM|LINK

  hi me_ritz,

  thanks for reply, i got it... thanks you so much you resolve my problem,

  Now i realize my mistake....