Синтаксическая ошибка отсутствует операнд после оператора mod

• Remove From My Forums

• Question

• User-248944896 posted

  Hi guys

  need some help, someone has given me some code to help me filter a gridview by the surname field by the selected letter of a dropdown list.

  My code is below, however if i select a letter from the dropdown and click the button i get an error, can someone take a look please.

  <%@ Page Language="VB" MasterPageFile="~/MasterPage.master" Title="Untitled Page" %>
  
  <script runat="server">
      Protected Sub Button1_Click(ByVal sender As Object, ByVal e As System.EventArgs)
          Dim dset As New Data.DataSet
          Dim dview As New Data.DataView
          dview.Table = dset.Tables("modelRegistration1")
          dview.RowFilter = "surname LIKE" + surnameFilter.SelectedValue.ToString() + " % "
          GridView1.DataSource = dview
          GridView1.DataBind()
      End Sub
  </script>
  
  <asp:Content ID="Content1" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server">
      <table>
          <tr>
              <td style="width: 100px">
                  Surname Filter:</td>
              <td style="width: 100px">
                  <asp:DropDownList ID="surnameFilter" runat="server" AppendDataBoundItems="True">
                      <asp:ListItem> - Please Select -</asp:ListItem>
                      <asp:ListItem Value="A">A</asp:ListItem>
                      <asp:ListItem Value="B">B</asp:ListItem>
                      <asp:ListItem Value="C">C</asp:ListItem>
                      <asp:ListItem Value="D">D</asp:ListItem>
                      <asp:ListItem Value="E">E</asp:ListItem>
                      <asp:ListItem Value="F">F</asp:ListItem>
                      <asp:ListItem Value="G">G</asp:ListItem>
                      <asp:ListItem Value="H">H</asp:ListItem>
                      <asp:ListItem Value="I">I</asp:ListItem>
                      <asp:ListItem Value="J">J</asp:ListItem>
                      <asp:ListItem Value="K">K</asp:ListItem>
                      <asp:ListItem Value="L">L</asp:ListItem>
                      <asp:ListItem Value="M">M</asp:ListItem>
                      <asp:ListItem Value="N">N</asp:ListItem>
                      <asp:ListItem Value="O">O</asp:ListItem>
                      <asp:ListItem Value="P">P</asp:ListItem>
                      <asp:ListItem Value="Q">Q</asp:ListItem>
                      <asp:ListItem Value="R">R</asp:ListItem>
                      <asp:ListItem Value="S">S</asp:ListItem>
                      <asp:ListItem Value="T">T</asp:ListItem>
                      <asp:ListItem Value="U">U</asp:ListItem>
                      <asp:ListItem Value="V">V</asp:ListItem>
                      <asp:ListItem Value="W">W</asp:ListItem>
                      <asp:ListItem Value="X">X</asp:ListItem>
                      <asp:ListItem Value="Y">Y</asp:ListItem>
                      <asp:ListItem Value="Z">Z</asp:ListItem>
                  </asp:DropDownList></td>
              <td style="width: 100px">
                  <asp:Button ID="Button1" runat="server" Text="Filter:" OnClick="Button1_Click" /></td>
              <td style="width: 100px">
                  </td>
              <td style="width: 100px">
                  </td>
              <td style="width: 100px">
              </td>
          </tr>
          <tr>
              <td style="width: 100px">
              </td>
              <td style="width: 100px">
              </td>
              <td style="width: 100px">
              </td>
              <td style="width: 100px">
              </td>
              <td style="width: 100px">
              </td>
              <td style="width: 100px">
              </td>
          </tr>
      </table>
      <br />
      <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" DataKeyNames="ID"
          DataSourceID="getModel" AllowPaging="True" EmptyDataText="N/A" PageSize="15">
          <Columns>
              <asp:BoundField DataField="ID" HeaderText="ID" InsertVisible="False" ReadOnly="True"
                  SortExpression="ID" />
              <asp:BoundField DataField="applicationDate" HeaderText="Sign Up Date" SortExpression="applicationDate" />
              <asp:BoundField DataField="firstName" HeaderText="First Name" SortExpression="firstName" />
              <asp:BoundField DataField="surname" HeaderText="Surname" SortExpression="surname" />
              <asp:BoundField DataField="dateOfBirth" HeaderText="DOB" SortExpression="dateOfBirth" />
              <asp:BoundField DataField="postcode" HeaderText="Post Code" SortExpression="postcode" />
              <asp:TemplateField HeaderText="Male" SortExpression="isMale">
                  <ItemTemplate>
                      <asp:CheckBox ID="isMale" runat="server" Checked='<%# Eval("isMale") %>' />
                  </ItemTemplate>
              </asp:TemplateField>
              <asp:TemplateField HeaderText="Female" SortExpression="isFemale">
                  <ItemTemplate>
                      <asp:CheckBox ID="isFemale" runat="server" Checked='<%# Eval("isFemale") %>' />
                  </ItemTemplate>
              </asp:TemplateField>
          </Columns>
      </asp:GridView>
      <asp:ObjectDataSource ID="getModel" runat="server"
          SelectMethod="GetDataBySurname" TypeName="KayKayDataTableAdapters.modelRegistration1TableAdapter">
      </asp:ObjectDataSource>
  </asp:Content>
  
  

   error message is

  Server Error in ‘/KayKay’ Application.

  ---

  Syntax error: Missing operand after ‘LIKEC’ operator.

  Description:
  An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

  Exception Details: System.Data.SyntaxErrorException: Syntax error: Missing operand after ‘LIKEC’ operator.

  Source Error:

  Line 6:          Dim dview As New Data.DataView
  Line 7:          dview.Table = dset.Tables("modelRegistration1")
  Line 8:          dview.RowFilter = "surname LIKE" + surnameFilter.SelectedValue.ToString() + " % "
  Line 9:          GridView1.DataSource = dview
  Line 10:         GridView1.DataBind()

  
  
  Source File: E:InetpubwwwrootKayKayAdminupdateModels.aspx    Line:
  8

  Stack Trace:

  [SyntaxErrorException: Syntax error: Missing operand after 'LIKEC' operator.]
     System.Data.ExpressionParser.Parse() +3158
     System.Data.DataExpression..ctor(DataTable table, String expression, Type type) +109
     System.Data.DataView.set_RowFilter(String value) +171
     ASP.admin_updatemodels_aspx.Button1_Click(Object sender, EventArgs e) in E:InetpubwwwrootKayKayAdminupdateModels.aspx:8
     System.Web.UI.WebControls.Button.OnClick(EventArgs e) +75
     System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) +97
     System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +7
     System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +11
     System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +33
     System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +4921
  

Я использую следующий код для выбора определенных строк из моего Datatable, но проблема в том, что он выполняет поиск только полного совпадающего содержимого из столбца

Dim strExpr = "`" + callerAHeader_Name + "` = " & iSrch & ""
Dim strSort = callerAHeader_Name + " DESC"
Dim foundRows As DataRow()

foundRows = ds.Tables(0).[Select](strExpr,strSort)

Он отлично работает, но для поиска по некоторым словам я использовал

Dim strExpr = "`" + callerAHeader_Name + "` LIKE '%" & iSrch & "%'"
Dim strSort = callerAHeader_Name + " DESC"
Dim foundRows As DataRow()

foundRows = ds.Tables(0).[Select](strExpr,strSort)

Что дает мне ошибку «Невозможно выполнить операцию« Нравится »в System.Double и System.String»

Если я удалю кавычки из strExpr

Dim strExpr = "`" + callerAHeader_Name + "` LIKE %" & iSrch & "%"

Выдает ошибку Синтаксическая ошибка: отсутствует операнд перед оператором Mod.

Попробуйте преобразовать значение столбца во время поиска

Dim foundRows = ds.Tables(0).Select("Convert(" & callerAHeader_Name & ", 'System.String') LIKE '*" + TextBox1.Text + "*'")

Использовать это:

Dim strExpr = "[" + callerAHeader_Name + "] LIKE '%" + Convert.ChangeType(iSrch, GetType(String)) + "%'"
Dim strSort = "[" + callerAHeader_Name + "] DESC"

РЕДАКТИРОВАТЬ: используйте GetType (String) вместо эквивалента C # typeof (string)

Вы также можете использовать оператор & для объединения строковых и целочисленных значений в vb, но я предпочитаю Convert.ChangeType

private void btnSearch_Click(object sender, RoutedEventArgs e)
{

        using (SqlConnection sc = new SqlConnection(sConn))
        {
            sc.Open();


            string SearchFor = txtSearch.Text;



            using (SqlDataAdapter adapter = new SqlDataAdapter())
            {
                DataTable dt = new DataTable();
                grdData.ItemsSource = dt.DefaultView.RowFilter = string.Concat("SELECT * FROM Student WHERE Forename LIKE '%", SearchFor, "%'");
            }

2