Click here to Skip to main content
12,064,812 members (39,462 online)
Rate this:
 
Please Sign up or sign in to vote.
See more: VB9.0 VB
How can I retrieve data from a datatable in an AutoCompleteStringCollection using a single line of code?
Is there a method using linq or any other method in vb ?

I retrieved it using this method,

Dim result = From o In Item.AsEnumerable() Select o.Field(Of String)("columnname")
Dim values() As String = result.ToArray()
 
txtGroup.AutoCompleteSource = AutoCompleteSource.CustomSource
txtGroup.AutoCompleteCustomSource = values

but it gives me error saying
Value of type '1-dimensional array of String' cannot be converted to 'System.Windows.Forms.AutoCompleteStringCollection'.


How can it be solved ?

Thanx in advance
Posted 2-Feb-12 21:49pm
Edited 3-Feb-12 6:34am
v2
Comments
B Birajdar 3-Feb-12 7:45am
   
I bet the code is not yours...

1 solution

Rate this: bad
 
good
Please Sign up or sign in to vote.

Solution 1

use txtGroup.AutoCompleteSource.AddRange() like so:

Dim result = From o In Item.AsEnumerable() Select o.Field(Of String)("columnname")
Dim values() As String = result.ToArray()
 
txtGroup.AutoCompleteSource = AutoCompleteSource.CustomSource
txtGroup.AutoCompleteCustomSource.addrange(values)

Hope that helps,

Ray
  Permalink  

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
Top Experts
Last 24hrsThis month


Advertise | Privacy | Mobile
Web04 | 2.8.160204.4 | Last Updated 3 Feb 2012
Copyright © CodeProject, 1999-2016
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100