问题

My database has 3 filters and I am trying to have them work together for a better search, but the code I am using says it is correct, but it is not working and often crashing the database with the error:

System.Data.SyntaxErrorException: 'Syntax error: Missing operand before '=' operator.'

here is my code

private void textBox3_TextChanged(object sender, EventArgs e)
{
    DataView DV = new DataView(this.datasetocean.Water_Level);

    if (yearfilter.Text != null && yearfilter.Text.Length > 0 &&
        locationfilter.Text != null && locationfilter.Text.Length > 0 &&
        textBox1.Text != null && textBox1.Text.Length > 0)
    {
        if (yearfilter.Text.Length > 0 && int.TryParse(yearfilter.Text, out _))
        {
            DV.RowFilter = string.Format("location LIKE '%{0}%' AND waterlevel LIKE '%{1}%' AND year = '{2}'", yearfilter.Text, locationfilter.Text, textBox1.Text);
        };
    }
    else if (locationfilter.Text != null && locationfilter.Text.Length > 0 &&
            textBox1.Text != null && textBox1.Text.Length > 0)
    {
        DV.RowFilter = string.Format("location LIKE '%{0}%' AND waterlevel LIKE '%{1}%'", locationfilter.Text, textBox1.Text);
    }
    else if (yearfilter.Text != null && yearfilter.Text.Length > 0 &&
        locationfilter.Text != null && locationfilter.Text.Length > 0)
    {
        DV.RowFilter = string.Format("location LIKE '%{0}%' AND year = '{1}'", yearfilter.Text, locationfilter.Text);
    }
    else if (yearfilter.Text != null && yearfilter.Text.Length > 0 &&
        textBox1.Text != null && textBox1.Text.Length > 0)
    {
        DV.RowFilter = string.Format("year = '{0}' AND waterlevel LIKE '{1}'", yearfilter.Text, textBox1.Text);
    }
    // Otherwise only include the name filter if the name filter is not empty
    else if (yearfilter.Text != null && yearfilter.Text.Length > 0)
    {
        DV.RowFilter = string.Format("year = '{0}'", yearfilter.Text);
    }
    else if (locationfilter.Text != null && locationfilter.Text.Length > 0)
    {
        DV.RowFilter = string.Format("location = '{0}'", locationfilter.Text);
    }
    else if (textBox1.Text != null && textBox1.Text.Length > 0)
    {
        DV.RowFilter = string.Format("waterlevel = '{0}'", textBox1.Text);
    }

    water_LevelDataGridView.DataSource = DV;
}

private void textBox2_TextChanged(object sender, EventArgs e)
{
    DataView DV = new DataView(this.datasetocean.Water_Level);

    if (yearfilter.Text != null && yearfilter.Text.Length > 0 &&
        locationfilter.Text != null && locationfilter.Text.Length > 0 &&
        textBox1.Text != null && textBox1.Text.Length > 0)
    {
        if (yearfilter.Text.Length > 0 && int.TryParse(yearfilter.Text, out _))
        {
            DV.RowFilter = string.Format("location LIKE '%{0}%' AND waterlevel LIKE '%{1}%' AND year = '{2}'", yearfilter.Text, locationfilter.Text, textBox1.Text);
        };
    }
    else if (locationfilter.Text != null && locationfilter.Text.Length > 0 &&
            textBox1.Text != null && textBox1.Text.Length > 0)
    {
        DV.RowFilter = string.Format("Location LIKE '%{0}%' AND WaterLevel LIKE '%{1}%'", locationfilter.Text, textBox1.Text);
    }
    else if (yearfilter.Text != null && yearfilter.Text.Length > 0 &&
        locationfilter.Text != null && locationfilter.Text.Length > 0)
    {
        DV.RowFilter = string.Format("location LIKE '%{0}%' AND year = '{1}'", yearfilter.Text, locationfilter.Text);
    }
    else if (yearfilter.Text != null && yearfilter.Text.Length > 0 &&
        textBox1.Text != null && textBox1.Text.Length > 0)
    {
        DV.RowFilter = string.Format("year = '{0}' AND waterlevel LIKE '{1}'", yearfilter.Text, textBox1.Text);
    }
    // Otherwise only include the name filter if the name filter is not empty
    else if (yearfilter.Text != null && yearfilter.Text.Length > 0)
    {
        DV.RowFilter = string.Format("year = '{0}'", yearfilter.Text);
    }
    else if (locationfilter.Text != null && locationfilter.Text.Length > 0)
    {
        DV.RowFilter = string.Format("location = '{0}'", locationfilter.Text);
    }
    else if (textBox1.Text != null && textBox1.Text.Length > 0)
    {
        DV.RowFilter = string.Format("waterlevel = '{0}'", textBox1.Text);
    }

    this.water_LevelDataGridView.DataSource = DV;
}

private void textBox1_TextChanged(object sender, EventArgs e)
{
    if (textBox1.Text.Length > 0 && int.TryParse(textBox1.Text, out _))
    {
        DataView DV = new DataView(this.datasetocean.Water_Level);

        if (yearfilter.Text != null && yearfilter.Text.Length > 0 &&
            locationfilter.Text != null && locationfilter.Text.Length > 0 &&
            textBox1.Text != null && textBox1.Text.Length > 0)
        {
            if (yearfilter.Text.Length > 0 && int.TryParse(yearfilter.Text, out _))
            {
                DV.RowFilter = string.Format("location LIKE '%{0}%' AND waterlevel LIKE '%{1}%' AND year = '{2}'", yearfilter.Text, locationfilter.Text, textBox1.Text);
            };
        }
        else if (locationfilter.Text != null && locationfilter.Text.Length > 0 &&
                textBox1.Text != null && textBox1.Text.Length > 0)
        {
            DV.RowFilter = string.Format("location LIKE '%{0}%' AND waterlevel LIKE '%{1}%'", locationfilter.Text, textBox1.Text);
        }
        else if (yearfilter.Text != null && yearfilter.Text.Length > 0 &&
            locationfilter.Text != null && locationfilter.Text.Length > 0)
        {
            DV.RowFilter = string.Format("location LIKE '%{0}%' AND year = '{1}'", yearfilter.Text, locationfilter.Text);
        }
        else if (yearfilter.Text != null && yearfilter.Text.Length > 0 &&
            textBox1.Text != null && textBox1.Text.Length > 0)
        {
            DV.RowFilter = string.Format("year = '{0}' AND waterlevel LIKE '{1}'", yearfilter.Text, textBox1.Text);
        }
        // Otherwise only include the name filter if the name filter is not empty
        else if (yearfilter.Text != null && yearfilter.Text.Length > 0)
        {
            DV.RowFilter = string.Format("year = '{0}'", yearfilter.Text);
        }
        else if (locationfilter.Text != null && locationfilter.Text.Length > 0)
        {
            DV.RowFilter = string.Format("location = '{0}'", locationfilter.Text);
        }
        else if (textBox1.Text != null && textBox1.Text.Length > 0)
        {
            DV.RowFilter = string.Format("waterlevel = '{0}'", textBox

<details>
<summary>英文:</summary>

My database has 3 filters  and I am trying to have them work together for a better search, but the code I am using says it is correct, but it is not working and often crashing the database with the error 

&gt; System.Data.SyntaxErrorException: &#39;Syntax error: Missing operand
&gt; before &#39;=&#39; operator.&#39;

here is my code
 
        private void textBox3_TextChanged(object sender, EventArgs e)
        {
           

                DataView DV = new DataView(this.datasetocean.Water_Level);



            if (yearfilter.Text != null &amp;&amp; yearfilter.Text.Length &gt; 0 &amp;&amp;
                locationfilter.Text != null &amp;&amp; locationfilter.Text.Length &gt; 0 &amp;&amp;
                textBox1.Text != null &amp;&amp; textBox1.Text.Length &gt; 0)
            {
                if (yearfilter.Text.Length &gt; 0 &amp;&amp; int.TryParse(yearfilter.Text, out _))
                {

                    DV.RowFilter = string.Format(&quot;location LIKE &#39;%{0}%&#39; AND waterlevel LIKE &#39;%{1}%&#39; AND year = &#39;{2}&#39;&quot;, yearfilter.Text, locationfilter.Text, textBox1.Text);
                };
            }
            else if (locationfilter.Text != null &amp;&amp; locationfilter.Text.Length &gt; 0 &amp;&amp;
                    textBox1.Text != null &amp;&amp; textBox1.Text.Length &gt; 0)
            {
                DV.RowFilter = string.Format(&quot;location LIKE &#39;%{0}%&#39; AND waterlevel LIKE &#39;%{1}%&#39;&quot;, locationfilter.Text, textBox1.Text);
            }
            else if (yearfilter.Text != null &amp;&amp; yearfilter.Text.Length &gt; 0 &amp;&amp;
                locationfilter.Text != null &amp;&amp; locationfilter.Text.Length &gt; 0)
            {
                DV.RowFilter = string.Format(&quot;location LIKE &#39;%{0}%&#39; AND year = &#39;{1}&#39;&quot;, yearfilter.Text, locationfilter.Text);
            }
            else if (yearfilter.Text != null &amp;&amp; yearfilter.Text.Length &gt; 0 &amp;&amp;
                textBox1.Text != null &amp;&amp; textBox1.Text.Length &gt; 0)
            {
                DV.RowFilter = string.Format(&quot;year = &#39;{0}&#39; AND waterlevel LIKE = &#39;{1}&#39;&quot;,
                yearfilter.Text, textBox1.Text);
            }
            // Otherwise only include the name filter if the name filter is not empty
            else if (yearfilter.Text != null &amp;&amp; yearfilter.Text.Length &gt; 0)
            {
                DV.RowFilter = string.Format(&quot;year = &#39;{0}&#39;&quot;,
                yearfilter.Text);

            }
            else if (locationfilter.Text != null &amp;&amp; locationfilter.Text.Length &gt; 0)
            {
                DV.RowFilter = string.Format(&quot;location = &#39;{0}&#39;&quot;,
                locationfilter.Text);
            }
            else if (textBox1.Text != null &amp;&amp; textBox1.Text.Length &gt; 0)
            {
                DV.RowFilter = string.Format(&quot;waterlevel = &#39;{0}&#39;&quot;,
                textBox1.Text);
            };

            water_LevelDataGridView.DataSource = DV;


        }

        private void textBox2_TextChanged(object sender, EventArgs e)
        {
            
            DataView DV = new DataView(this.datasetocean.Water_Level);

            if (yearfilter.Text != null &amp;&amp; yearfilter.Text.Length &gt; 0 &amp;&amp;
                locationfilter.Text != null &amp;&amp; locationfilter.Text.Length &gt; 0 &amp;&amp;
                textBox1.Text != null &amp;&amp; textBox1.Text.Length &gt; 0)
            {
                if (yearfilter.Text.Length &gt; 0 &amp;&amp; int.TryParse(yearfilter.Text, out _))
                {

                    DV.RowFilter = string.Format(&quot;location LIKE &#39;%{0}%&#39; AND waterlevel LIKE &#39;%{1}%&#39; AND year = &#39;{2}&#39;&quot;, yearfilter.Text, locationfilter.Text, textBox1.Text);
                };
            }
            else if (locationfilter.Text != null &amp;&amp; locationfilter.Text.Length &gt; 0 &amp;&amp;
                    textBox1.Text != null &amp;&amp; textBox1.Text.Length &gt; 0)
            {
                DV.RowFilter = string.Format(&quot;Location LIKE &#39;%{0}%&#39; AND WaterLevel LIKE &#39;%{1}%&#39;&quot;, locationfilter.Text, textBox1.Text);
            }
            else if (yearfilter.Text != null &amp;&amp; yearfilter.Text.Length &gt; 0 &amp;&amp;
                locationfilter.Text != null &amp;&amp; locationfilter.Text.Length &gt; 0)
            {
                DV.RowFilter = string.Format(&quot;location LIKE &#39;%{0}%&#39; AND year = &#39;{1}&#39;&quot;, yearfilter.Text, locationfilter.Text);
            }
            else if (yearfilter.Text != null &amp;&amp; yearfilter.Text.Length &gt; 0 &amp;&amp;
                textBox1.Text != null &amp;&amp; textBox1.Text.Length &gt; 0)
            {
                DV.RowFilter = string.Format(&quot;year = &#39;{0}&#39; AND waterlevel LIKE = &#39;{1}&#39;&quot;,
                yearfilter.Text, textBox1.Text);
            }
            // Otherwise only include the name filter if the name filter is not empty
            else if (yearfilter.Text != null &amp;&amp; yearfilter.Text.Length &gt; 0)
            {
                DV.RowFilter = string.Format(&quot;year = &#39;{0}&#39;&quot;,
                yearfilter.Text);

            }
            else if (locationfilter.Text != null &amp;&amp; locationfilter.Text.Length &gt; 0)
            {
                DV.RowFilter = string.Format(&quot;location = &#39;{0}&#39;&quot;,
                locationfilter.Text);
            }
            else if (textBox1.Text != null &amp;&amp; textBox1.Text.Length &gt; 0)
            {
                DV.RowFilter = string.Format(&quot;waterlevel = &#39;{0}&#39;&quot;,
                textBox1.Text);
            };

            this.water_LevelDataGridView.DataSource = DV;


        }

        private void textBox1_TextChanged(object sender, EventArgs e)
        {
            if (textBox1.Text.Length &gt; 0 &amp;&amp; int.TryParse(textBox1.Text, out _))
            {
            DataView DV = new DataView(this.datasetocean.Water_Level);

                if (yearfilter.Text != null &amp;&amp; yearfilter.Text.Length &gt; 0 &amp;&amp;
                    locationfilter.Text != null &amp;&amp; locationfilter.Text.Length &gt; 0 &amp;&amp;
                    textBox1.Text != null &amp;&amp; textBox1.Text.Length &gt; 0)
                {
                    if (yearfilter.Text.Length &gt; 0 &amp;&amp; int.TryParse(yearfilter.Text, out _))
                    {

                        DV.RowFilter = string.Format(&quot;location LIKE &#39;%{0}%&#39; AND waterlevel LIKE &#39;%{1}%&#39; AND year = &#39;{2}&#39;&quot;, yearfilter.Text, locationfilter.Text, textBox1.Text);
                    };
                }
                else if (locationfilter.Text != null &amp;&amp; locationfilter.Text.Length &gt; 0 &amp;&amp;
                        textBox1.Text != null &amp;&amp; textBox1.Text.Length &gt; 0)
                {
                    DV.RowFilter = string.Format(&quot;location LIKE &#39;%{0}%&#39; AND waterlevel LIKE &#39;%{1}%&#39;&quot;, locationfilter.Text, textBox1.Text);
                }
                else if (yearfilter.Text != null &amp;&amp; yearfilter.Text.Length &gt; 0 &amp;&amp;
                    locationfilter.Text != null &amp;&amp; locationfilter.Text.Length &gt; 0)
                {
                    DV.RowFilter = string.Format(&quot;location LIKE &#39;%{0}%&#39; AND year = &#39;{1}&#39;&quot;, yearfilter.Text, locationfilter.Text);
                }
                else if (yearfilter.Text != null &amp;&amp; yearfilter.Text.Length &gt; 0 &amp;&amp;
                    textBox1.Text != null &amp;&amp; textBox1.Text.Length &gt; 0)
                {
                    DV.RowFilter = string.Format(&quot;year = &#39;{0}&#39; AND waterlevel LIKE = &#39;{1}&#39;&quot;,
                    yearfilter.Text, textBox1.Text);
                }
                // Otherwise only include the name filter if the name filter is not empty
                else if (yearfilter.Text != null &amp;&amp; yearfilter.Text.Length &gt; 0)
                {
                    DV.RowFilter = string.Format(&quot;year = &#39;{0}&#39;&quot;,
                    yearfilter.Text);

                }
                else if (locationfilter.Text != null &amp;&amp; locationfilter.Text.Length &gt; 0)
                {
                    DV.RowFilter = string.Format(&quot;location = &#39;{0}&#39;&quot;,
                    locationfilter.Text);
                }
                else if (textBox1.Text != null &amp;&amp; textBox1.Text.Length &gt; 0)
                {
                    DV.RowFilter = string.Format(&quot;waterlevel = &#39;{0}&#39;&quot;,
                    textBox1.Text);
                };

                this.water_LevelDataGridView.DataSource = DV;
            }
        }

</details>


# 答案1
**得分**: 2

你有一些代码行如下：

```csharp
DV.RowFilter = string.Format("year = '{0}' AND waterlevel LIKE = '{1}'",

LIKE 的语法不使用等号运算符，这很可能是你的问题所在。

这是更友好的建议，但如果你尝试简化一些条件并用函数替换重复的代码，调试代码会更容易。

英文:

You have a few lines that have

         DV.RowFilter = string.Format(&quot;year = &#39;{0}&#39; AND waterlevel LIKE = &#39;{1}&#39;&quot;,

The syntax for LIKE doesn't use an equals operator, and this is likely your issue.

This is more friendly advice, but you'll have a much easier time debugging your code if you try to simplify some of your conditions and replace repeating code with functions

通过集体智慧和协作来改善编程学习和解决问题的方式。致力于成为全球开发者共同参与的知识库，让每个人都能够通过互相帮助和分享经验来进步。

C#筛选字段不起作用，但代码看起来是正确的。

问题

如何在子表中使用新创建的主键创建多个记录

无法使用 WinUI 3 文件选择器。

如何在查询中强制删除 COALESCE 函数。C# EntityFramework 7.0.2 LINQ

这是AND和OR运算符与NULL的真值表吗？

What's the correct way to type hint an empty list as a literal in python?

如何在Highcharts Gantt中更改本地化的星期名称

如何在同一个流中使用多个过滤器和映射函数？

如何使用Map/Set来将代码优化到O(n)？

.NET MAUI Android在GitHub Actions上构建失败，错误代码为1。

如何在Playwright视觉比较中屏蔽多个定位器？

在C++中，可以使用可变模板参数来检索类型的内部类型。

selenium.common.exceptions.StaleElementReferenceException: Message: stale element reference: stale element not found

Creating and opening a URL to log in to Website via Basic Auth with Robot Framework/Selenium (Python)

AG Grid 在上下文菜单中以大文本形式打开

发表评论