Control Script
Public Function CARI_SUPPLIERID(ByVal _Namenya As String) As String
MeKONEKSI.TUTUPKONEKSI()
COMMAND.CommandType = CommandType.Text
COMMAND.CommandText = "SELECT SUPPLIERID FROM TABELSUPPLIER " & _
"WHERE SUPPLIERNAME = '" & _Namenya & "'"
COMMAND.Connection = MeKONEKSI.BUKAKONEKSI
DTR = COMMAND.ExecuteReader
Return DTR.Read
End Function
Boundary Script
With CmbSUPPLIERNAME
.AutoCompleteMode = AutoCompleteMode.SuggestAppend
.AutoCompleteSource = AutoCompleteSource.ListItems
.DataSource = MeSupplier_Control.SUPPLIERID_SUPPLIERNAME
.DisplayMember = "SUPPLIERNAME"
.SelectedIndex = -1
.Text = "- SELECT SUPPLIER -"
End With
Comments
Post a Comment