在DataGridView中 ,为了提高输入的效率,想给用户一些关键提示,能够自动完成,这样速度就快多了。上图:
实现的代码:
Imports System.Data
Imports System.Data.SqlClient
Public Class Form1
Private Sub Form1_Load(sender As Object, e As System.EventArgs) Handles Me.Load
Dim con As New SqlConnection("Data Source=WILTAN-NOTEPAD\SQLEXPRESS;Initial Catalog=yhxAll;Integrated Security=True")
Dim da As New SqlDataAdapter("select CkID,rtrim(ckName) as ckname from ck_ck", con)
Dim DS As New DataSet
da.Fill(DS)
Dim ck As New DataGridViewComboBoxColumn()
ck.Name = "仓库"
ck.HeaderText = "收货仓库"
ck.DataSource = DS.Tables(0)
ck.DataPropertyName = "仓库"
ck.DisplayMember = "ckname"
ck.ValueMemb