使用vb.net在sql compact 3.5版本中进行参数查询 [英] parameter query in sql compact 3.5 edition with vb.net

问题描述

下面的参数查询代码在da.Fill（dt）给出错误

错误信息是（参数缺失。[参数序号1]）

当我取出代码工作的where子句

但我需要过滤。请帮助

 Dim conn As New SqlCeConnection（）
 Dim connect As String =Persist Security Info = False; Data Source = | DataDirectory | \ POSadmini.sdf; 
 conn.ConnectionString = connect 
 conn.Open（）
 Dim bna As Integer = 17 
 Dim query As String =SELECT * from tblbranch where branchcode = @cod
 Dim bcmd As New SqlCeCommand（query，conn）
 bcmd.Parameters.AddWithValue（@ cod，bna）
 Dim da As New SqlCeDataAdapter（query，conn）
 Dim dt As新的DataTable 
 da.Fill（dt）
 bcmd.ExecuteNonQuery（）

解决方案

嗯。

您创建一个命令，添加参数，然后......您不会使用它来构建DataAdapter。相反，你从原始字符串构建它，没有你需要提供的参数。



删除行：

 bcmd.ExecuteNonQuery（）

并使用命令对象构建DataAdapter：

 Dim da As New SqlCeDataAdapter（BCMD）

the parameter query code below gives error at da.Fill(dt)
error message is (A parameter is missing. [parameter ordinal 1])
when I take out the where clause the code works
but I need to filter. please help

Dim conn As New SqlCeConnection()
        Dim connect As String = "Persist Security Info = False; Data Source=|DataDirectory|\POSadmini.sdf;"
        conn.ConnectionString = connect
        conn.Open()
        Dim bna As Integer = 17
        Dim query As String = "SELECT * from tblbranch where branchcode = @cod "
        Dim bcmd As New SqlCeCommand(query, conn)
        bcmd.Parameters.AddWithValue("@cod", bna)
        Dim da As New SqlCeDataAdapter(query, conn)
        Dim dt As New DataTable
        da.Fill(dt)
        bcmd.ExecuteNonQuery()

解决方案

Um.
You create a command, you add parameters, then... You don't use it to build you DataAdapter. Instead, you build it from the original string, without the parameter you need to supply.

Remove the line:

bcmd.ExecuteNonQuery()

And use the command object to build the DataAdapter:

Dim da As New SqlCeDataAdapter(bcmd)

这篇关于使用vb.net在sql compact 3.5版本中进行参数查询的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！