Search
Search titles only
By:
Search titles only
By:
Log in
Register
Search
Search titles only
By:
Search titles only
By:
Menu
Install the app
Install
Forums
New posts
All threads
Latest threads
New posts
Trending threads
Trending
Search forums
What's new
New posts
New ads
New profile posts
Latest activity
Free Ads
Latest reviews
Search ads
Members
Current visitors
New profile posts
Search profile posts
Contact us
Latest ads
Bodim.lk out now !
Manoj Suranga Bandara
Updated:
Yesterday at 3:05 AM
Power Lifting Lever Belt
SkullVamp
Updated:
Jun 13, 2026
Ad icon
port.lk Domain for sale
Lankan-Tech
Updated:
Jun 13, 2026
Colombo
Kaduwela - Two Storey House for Sale
dilrasan
Updated:
Jun 11, 2026
Ad icon
Wechat qr verification
Pawan2005
Updated:
Jun 11, 2026
Electronics
Vehicles
Property
Search
Reply to thread
Forums
General
ElaKiri Talk!
VB.net Hel [autocomplete]
Get the App
JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an
alternative browser
.
Message
<blockquote data-quote="IDG" data-source="post: 15884836" data-attributes="member: 411624"><p><strong>[PLAIN]VB.net Help [autocomplete][/PLAIN]</strong></p><p></p><p><span style="font-size: 18px"><span style="color: DarkSlateGray">මට පොඩ්ඩක් උදව්කරනවාද මේකයි වැඩේ</span></span></p><p style="text-align: center"> <span style="font-size: 18px"><span style="color: DarkSlateGray">vb.net වලින් windows form එකක් හදාගන්න ඹනේ මෙන්න මේ විදිහට</span></span></p> <p style="text-align: center"><span style="font-size: 18px"><span style="color: DarkSlateGray">textbox එකක් තියෙනවා ඒකට data type කරනකොට auto complete වෙන්න</span></span></p> <p style="text-align: center"><span style="font-size: 18px"><span style="color: DarkSlateGray">autocomplete words ටික ms access වලින් read කරලා ගන්න </span></span></p> <p style="text-align: center"><span style="font-size: 18px"><span style="color: DarkSlateGray">මම net එකේන් එහේමෙහේ ගිහින් හොයාගත්ත ඒත් ඒකේ autocomplete වෙන්නේ 1වෙනි word එක විතරයි </span></span></p> <p style="text-align: center"><span style="font-size: 18px"><span style="color: DarkSlateGray">[YOUTUBE]YbzQbbQJQGg[/YOUTUBE]</span></span></p> <p style="text-align: center"><span style="font-size: 18px"><span style="color: DarkSlateGray">මේතියෙන්නේ කරපු විදිහ උඩ තියෙන එකත් බලාගෙන කරා</span></span></p> <p style="text-align: center"><span style="font-size: 18px"><span style="color: DarkSlateGray"></span></span><p style="text-align: left"><span style="color: DarkSlateGray"><span style="font-size: 18px">create a text box</span></span></p> <p style="text-align: left"><span style="color: DarkSlateGray"><span style="font-size: 18px">and change its properties menu</span></span></p> <p style="text-align: left"><span style="color: DarkSlateGray"><span style="font-size: 18px">autocomplete mode to suggest append</span></span></p> <p style="text-align: left"><span style="color: DarkSlateGray"><span style="font-size: 18px">autocomplete source to custom source </span></span></p> <p style="text-align: left"><span style="color: DarkSlateGray"><span style="font-size: 18px"></span></span></p> <p style="text-align: left"><span style="color: DarkSlateGray"><span style="font-size: 18px">after that form load code =</span></span></p> <p style="text-align: left"><span style="color: DarkSlateGray"><span style="font-size: 18px">[HTML]</span></span></p> <p style="text-align: left"><span style="color: DarkSlateGray"><span style="font-size: 18px">Dim con1 As New OleDbConnection</span></span></p> <p style="text-align: left"><span style="color: DarkSlateGray"><span style="font-size: 18px"> con1.ConnectionString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=E:\work\recent.accdb"</span></span></p> <p style="text-align: left"><span style="color: DarkSlateGray"><span style="font-size: 18px"> con1.Open()</span></span></p> <p style="text-align: left"><span style="color: DarkSlateGray"><span style="font-size: 18px"> MsgBox("suggestions are open")</span></span></p> <p style="text-align: left"><span style="color: DarkSlateGray"><span style="font-size: 18px">Dim dt As New DataTable</span></span></p> <p style="text-align: left"><span style="color: DarkSlateGray"><span style="font-size: 18px"> Dim ds As New DataSet</span></span></p> <p style="text-align: left"><span style="color: DarkSlateGray"><span style="font-size: 18px"> ds.Tables.Add(dt)</span></span></p> <p style="text-align: left"><span style="color: DarkSlateGray"><span style="font-size: 18px"> Dim da As New OleDbDataAdapter("select * from recent", con1)</span></span></p> <p style="text-align: left"><span style="color: DarkSlateGray"><span style="font-size: 18px"> da.Fill(dt)</span></span></p> <p style="text-align: left"><span style="color: DarkSlateGray"><span style="font-size: 18px"> Dim r As DataRow</span></span></p> <p style="text-align: left"><span style="color: DarkSlateGray"><span style="font-size: 18px"> TextBox2.AutoCompleteCustomSource.Clear()</span></span></p> <p style="text-align: left"><span style="color: DarkSlateGray"><span style="font-size: 18px"></span></span></p> <p style="text-align: left"><span style="color: DarkSlateGray"><span style="font-size: 18px"> For Each r In dt.Rows</span></span></p> <p style="text-align: left"><span style="color: DarkSlateGray"><span style="font-size: 18px"> sugg.Add(r.Item(0).ToString)</span></span></p> <p style="text-align: left"><span style="color: DarkSlateGray"><span style="font-size: 18px"> </span></span></p> <p style="text-align: left"><span style="color: DarkSlateGray"><span style="font-size: 18px"></span></span></p> <p style="text-align: left"><span style="color: DarkSlateGray"><span style="font-size: 18px"> Next</span></span></p> <p style="text-align: left"><span style="color: DarkSlateGray"><span style="font-size: 18px"></span></span></p> <p style="text-align: left"><span style="color: DarkSlateGray"><span style="font-size: 18px"> TextBox2.AutoCompleteCustomSource = sugg</span></span></p> <p style="text-align: left"><span style="color: DarkSlateGray"><span style="font-size: 18px"> con1.Close()</span></span></p> <p style="text-align: left"><span style="color: DarkSlateGray"><span style="font-size: 18px"></span></span></p> <p style="text-align: left"><span style="color: DarkSlateGray"><span style="font-size: 18px">[/HTML]මේකෙන් 1st word එකට විතරයි වැඩ කරන්නේ දන්න කෙනේක් පොඩ්ඩක් කියලා දෙනවද දිගටම type කරනකොට හැම වචනේටම suggestion පෙන්නන විදිහ </span></span></p> <p style="text-align: left"><span style="color: DarkSlateGray"><span style="font-size: 18px"></span></span></p> <p style="text-align: left"><span style="color: DarkSlateGray"><span style="font-size: 18px"><span style="color: Green">දන්නේ නැත්තම් <span style="color: DarkRed">bump </span>එකක් දාගෙන යන්න දවසක ඹයාලාටත් වැදගත් වෙයි programmer කේනේක් නම්</span></span></span></p> <p style="text-align: left"><span style="color: DarkSlateGray"><span style="font-size: 18px"></span></span></p> <p style="text-align: left"><span style="color: DarkSlateGray"><span style="font-size: 18px"></span></span></p></p> <p style="text-align: center"></p> <p style="text-align: center"></p></blockquote><p></p>
[QUOTE="IDG, post: 15884836, member: 411624"] [b][PLAIN]VB.net Help [autocomplete][/PLAIN][/b] [SIZE=5][COLOR=DarkSlateGray]මට පොඩ්ඩක් උදව්කරනවාද මේකයි වැඩේ[/COLOR][/SIZE] [CENTER] [SIZE=5][COLOR=DarkSlateGray]vb.net වලින් windows form එකක් හදාගන්න ඹනේ මෙන්න මේ විදිහට textbox එකක් තියෙනවා ඒකට data type කරනකොට auto complete වෙන්න autocomplete words ටික ms access වලින් read කරලා ගන්න මම net එකේන් එහේමෙහේ ගිහින් හොයාගත්ත ඒත් ඒකේ autocomplete වෙන්නේ 1වෙනි word එක විතරයි [YOUTUBE]YbzQbbQJQGg[/YOUTUBE] මේතියෙන්නේ කරපු විදිහ උඩ තියෙන එකත් බලාගෙන කරා [/COLOR][/SIZE][LEFT][COLOR=DarkSlateGray][SIZE=5]create a text box and change its properties menu autocomplete mode to suggest append autocomplete source to custom source after that form load code = [HTML] Dim con1 As New OleDbConnection con1.ConnectionString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=E:\work\recent.accdb" con1.Open() MsgBox("suggestions are open") Dim dt As New DataTable Dim ds As New DataSet ds.Tables.Add(dt) Dim da As New OleDbDataAdapter("select * from recent", con1) da.Fill(dt) Dim r As DataRow TextBox2.AutoCompleteCustomSource.Clear() For Each r In dt.Rows sugg.Add(r.Item(0).ToString) Next TextBox2.AutoCompleteCustomSource = sugg con1.Close() [/HTML]මේකෙන් 1st word එකට විතරයි වැඩ කරන්නේ දන්න කෙනේක් පොඩ්ඩක් කියලා දෙනවද දිගටම type කරනකොට හැම වචනේටම suggestion පෙන්නන විදිහ [COLOR=Green]දන්නේ නැත්තම් [COLOR=DarkRed]bump [/COLOR]එකක් දාගෙන යන්න දවසක ඹයාලාටත් වැදගත් වෙයි programmer කේනේක් නම්[/COLOR] [/SIZE][/COLOR][/LEFT] [/CENTER] [/QUOTE]
Insert quotes…
Verification
Hathara warak wissa keeyada? (Hathara wadi karanna 20)
Post reply
Top
Bottom