主页 / 问题 / 911777
Accepted
corocoto
Asked:2020-11-26 22:27:57 +0000 UTC2020-11-26 22:27:57 +0000 UTC

将值从 TextBox 传递到 sql 查询时出错

  • 772

在此处输入图像描述

adapter = new SqlDataAdapter("SELECT  tRoutesPuncts.ID_Punct, tPuncts.sPunct FROM dbo.tRoutesPuncts INNER JOIN tRoutes ON dbo.tRoutesPuncts.ID_Route = dbo.tRoutes.ID_Route" +
       " inner join tPuncts ON dbo.tRoutesPuncts.ID_Punct = dbo.tPuncts.ID_Punct WHERE tRoutesPuncts.ID_Route=" + id.Text, connection);

        dtForAddPuncts = new DataTable();
        adapter.Fill(dtForAddPuncts);
        bsForAddPuncts= new BindingSource();
        bsForAddPuncts.DataSource = dtForAddPuncts;
        cbAddPuncts.DataSource = bsForAddPuncts;
        cbAddPuncts.ValueMember = "ID_Punct";
        cbAddPuncts.DisplayMember = "sPunct";
    }

错误出现在这里：“adapter.Fill(dtForAddPuncts);”

在此处输入图像描述 在此处输入图像描述

c#

2 个回答

  1. 它将当前 ID_Route 的值存储在 tRoutes 表中

    我对你来说算什么，斯坦尼斯拉夫斯基？

    已经写下那里有什么样的文字，否则我会给你一个减号。

    <дистанционное чтение кода сквозь монитор>

    字符串id.Text为空。因此，SQL 以

    ... WHERE tRoutesPuncts.ID_Route=

    这在语法上是错误的。

    让我们得到一个转换错误而不是你的错误：

    int ID_Route = int.Parse(id.Text);
adapter = new SqlDataAdapter("SELECT  tRoutesPuncts.ID_Punct, tPuncts.sPunct FROM dbo.tRoutesPuncts INNER JOIN tRoutes ON dbo.tRoutesPuncts.ID_Route = dbo.tRoutes.ID_Route" +
       " inner join tPuncts ON dbo.tRoutesPuncts.ID_Punct = dbo.tPuncts.ID_Punct WHERE tRoutesPuncts.ID_Route=" + 
       ID_Route.ToString(), connection);

    </дистанционное чтение кода сквозь монитор>

    • 1
  2. Best Answer
    void LoadDataFromRoutesPuncts(int id)
    {
        adapter = new SqlDataAdapter("SELECT  tRoutesPuncts.ID_Punct, tPuncts.sPunct FROM dbo.tRoutesPuncts INNER JOIN tRoutes ON dbo.tRoutesPuncts.ID_Route = dbo.tRoutes.ID_Route" +
   " inner join tPuncts ON dbo.tRoutesPuncts.ID_Punct = dbo.tPuncts.ID_Punct WHERE tRoutesPuncts.ID_Route=" + id, connection);

        dtForAddPuncts = new DataTable();
        adapter.Fill(dtForAddPuncts);
        bsForAddPuncts = new BindingSource();
        bsForAddPuncts.DataSource = dtForAddPuncts;
        cbAddPuncts.DataSource = bsForAddPuncts;
        cbAddPuncts.ValueMember = "ID_Punct";
        cbAddPuncts.DisplayMember = "sPunct";
    }

LoadDataFromRoutesPuncts(Convert.ToInt32(((DataRowView)this.bsForRoutes.Current).Row["ID_Route"]));
    • 0

相关问题