Hi \r\n \r\nI use this code to call data into combobox \r\nI use 4 combobox and read from Table1 / Table2 3 and 4 \r\n \r\nIs it poseble to chance this code so I only need to write only 1 \r\n \r\nand call combofill ??? to read from difrent table and record? \r\n \r\nDim Rcordset As ADODB.Recordset \r\n \r\n \r\n Set Rcordset = New ADODB.Recordset \r\n strSQL = "SELECT * FROM starfsmenn;" \r\n Rcordset.Open strSQL, conTree, adOpenStatic, adLockOptimistic \r\n \r\nWith Rcordset \'Either ADO or DAO \r\n Do While Not .EOF \r\n txtdeild.AddItem Rcordset.Fields("deildir").Value \'String varible \r\n txtdeild.ItemData(txtdeild.NewIndex) = .Fields("ID").Value \'Numeric varible \r\n .MoveNext \r\n Loop \r\nEnd With
I use this code to call data into combobox
I use 4 combobox and read from Table1 / Table2 3 and 4
Is it poseble to chance this code so I only need to write only 1
and call combofill ??? to read from difrent table and record?
Dim Rcordset As ADODB.Recordset
Set Rcordset = New ADODB.Recordset
strSQL = "SELECT * FROM starfsmenn;"
Rcordset.Open strSQL, conTree, adOpenStatic, adLockOptimistic
With Rcordset 'Either ADO or DAO
Do While Not .EOF
txtdeild.AddItem Rcordset.Fields("deildir").Value 'String varible
txtdeild.ItemData(txtdeild.NewIndex) = .Fields("ID").Value 'Numeric varible
.MoveNext
Loop
End With
The ASP.NET 2.0 Anthology
101 Essential Tips, Tricks & Hacks - Free 156 Page Preview. Learn the most practical features and best approaches for ASP.NET. subscribe
\r\n\r\n\r\n
Combobox help read data
Threaded Mode
