sql - 如何从自动完成文本框中检索数据

Question

我正在开发一个库存管理系统，我添加了带有自动完成代码的文本框。我有两种形式，一种是商品形式，另一种是库存。现在我可以从带有自动完成代码的 stockin itemnumber 文本框中获取 itemcodeID 但是当我选择那个时项目编号它没有给我描述..我的意思是说，如果用户以库存形式搜索项目代码，那么他应该自动获得该项目的描述和数量......我正在使用 vb.net 和 ms sql。

我的自动完成代码

Private Sub getData(ByVal dataCollection As AutoCompleteStringCollection)
    Dim connetionString As String = Nothing
    Dim connection As SqlConnection
    Dim command As SqlCommand
    Dim adapter As New SqlDataAdapter()
    Dim ds As New DataSet()

    connetionString = ("Server= DESKTOP-QN6F623; Database = dbo_main;Integrated Security = false;User ID=dis;Password=0m3rP@ss")
    Dim sql As String = "SELECT itemnumber FROM items"
    connection = New SqlConnection(connetionString)
    Try
        connection.Open()
        command = New SqlCommand(sql, connection)
        adapter.SelectCommand = command
        adapter.Fill(ds)
        adapter.Dispose()
        command.Dispose()
        connection.Close()
        For Each row As DataRow In ds.Tables(0).Rows
            dataCollection.Add(row(0).ToString())
        Next
    Catch ex As Exception
        MessageBox.Show("Can not open connection ! ")
    End Try
End Sub

Private Sub stockin_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
    Stockin_itemnumberTextBox.AutoCompleteMode = AutoCompleteMode.Suggest
    Stockin_itemnumberTextBox.AutoCompleteSource = AutoCompleteSource.CustomSource
    Dim DataCollection As New AutoCompleteStringCollection()
    getData(DataCollection)
    Stockin_itemnumberTextBox.AutoCompleteCustomSource = DataCollection
End Sub

我需要....当用户在 itemnumber 文本框中写入时，他应该自动获取与该数字相关的相关详细信息...文本框的 itemnumber 是自动完成的。

标签： sqlvb.net